数据存储选项用于 Power Apps

huangapple go评论70阅读模式
英文:

Data Storage options for power apps

问题

我正在开发一个应用程序,将由销售代表在多个不同客户的销售环节中使用。这意味着每个销售代表将拥有一个运行该应用程序的设备,并将在销售演示期间使用客户的数据进行导入和操作。这还意味着在演示期间,我们不希望不同客户看到其他客户的数据。我们希望数据仅存在于该Power应用程序的“实例”中。我对Power Apps如何存储数据并不很熟悉,但每次演示期间临时存储的数据类型可能包括数据文件或输入数据。是否可以使用Azure以这种方式“实例化”数据?

英文:

I'm building an application that will be used in a sales aspect by sales reps for many different clients at the same time. This means that each sales rep will have a device that will run the app and will be importing and running operations using the client's data during the sales demo. This also means that during the demo, we don't want different client's seeing other's data. We would like to have the data exist only on that 'instance' of the power app. I'm not very familiar with how Power Apps stores data, but the types of data will most likely be storing temporarily for each demo would be things such as data files or input data. Is there a way to 'instance' the data in this way using Azure?

答案1

得分: 1

假设你是在谈论PowerApps的画布应用程序,你有选择广泛的数据源的选项。

> 来自Microsoft文章
>
> 最常见的数据源是表格,您可以用来检索和存储信息。您可以使用与数据源的连接来读取和写入Microsoft Excel工作簿、使用Microsoft Lists创建的列表、SharePoint库、SQL表等格式的数据,这些数据可以存储在OneDrive for Business、DropBox和SQL Server等云服务中。

例如,您可以设计您的应用程序从OneDrive中根据客户名字提取Excel/CSV数据。在应用程序开始时,您可以有一个屏幕来选择客户,并根据选择将数据源切换到相应的文件夹并加载数据。根据需求,还有许多其他可能的解决方案。

参考链接
https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/working-with-data-sources

英文:

Assuming you are talking about powerapps Canvas App you have an option to choose from wide array of datasources.

> From Microsoft article
>
> The most common data sources are tables, which you can use to retrieve
> and store information. You can use connections to data sources to read
> and write data in Microsoft Excel workbooks, lists created using
> Microsoft Lists, SharePoint libraries, SQL tables, and many other
> formats, which can be stored in cloud services such as OneDrive for
> Business, DropBox, and SQL Server.

Example, You can architect your app to pull data from excel/csv from one drive based on client name. On the beginning of the app you can have a screen to choose the client and based on selection the data source can be switched to respective folder and load data. Many other possibile solutions are there depends on the requirement.

Reference
https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/working-with-data-sources

huangapple
  • 本文由 发表于 2023年6月14日 23:50:45
  • 转载请务必保留本文链接:https://go.coder-hub.com/76475401.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定