Unanswered

Dynamic datasource? Is it possible to use changing datasource?

(1) Share

Report

Posted on by IT-16081002-0

Hello,

Is it possible to use something like one drive/SP location for datasource, so in this location will be document changed like every day.

We desire that as datasource we would use dump from database, which would be then put into .csv/excel format and this dump would be every day, after dump .csv file would be uploaded to some location onedrive/SP. Is it able to define somehow this location to power apps so it will use as datasource always new .csv document.

Of course we would like to have it without any additional inputs in power app edit view. Just to set the location, where .csv/excel file would be uploaded daily.

Ivan - power platform enjoyer

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (2)

Answers (0)

WarrenBelz 153,127 Most Valuable Professional on at

Like (0)

Report

Hi IT-16081002-0

Two issues here - populating new records into a Excel table outside of Power Apps will not be recognised in the data as Power Apps needs to write its id reference to every record (so you cannot simply upload a whole new set of data except through Power Apps. Secondly, Excel is a highly inferior data source for Powers Apps with inconsistency and many restrictions and should only be used if another option (such as SharePoint) is available.

Your model will however work if you uses a SharePoint Table and cleared/imported the CSV file into it, either by copy/paste (for smaller data sets) or with Power Automate.

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No
IT-16081002-0 4 on at

Like (0)

Report

Hello, thanks for answer, but i think you havent exactly understood what iam asking for.

Is it possible to use dynamic datasource as .csv (dump from sql database) located in some OneDrive or Sharepoint location?

My expectation is to use this dump of database as datasource in power apps, with condition that new dump would be created every day and powerapps would load everyday information from it.

Ivan - power platform newbie

Was this reply helpful? Yes No