Showing results for 
Search instead for 
Did you mean: 

Dynamic Data Source

I have created an app for a certain SharePoint site. I am using this same app for other SharePoint sites that have the same structure (tables, columns, etc.) To do this I know have to save the app with another name and replace the data source manually inside the app editor. It would be perfect to have just one single app where I can give the SharePoint site url, or site tables when opening the app.


An idea that comes to my mind would be to have the user select the SharePoint that he wants to connect to and do the data source connection relative to the user's choice.


Status: New
Advocate II

Yes being able to use patch which uses a variable would equally solve this. A user selects at Powerapp start there department - and that is stored as a variable which means the list/document library you want to then patch to can be placed as a variable in the path formula.


We have an app that is used for multiple Sharepoint site collections that have the same lists set up - but we have to create and consequently any updates to app have to be duplicated. Being able to have one app, that user selects the site they wanting to connect to would mean we deploy one app that can right to which ever Sharepoint list that is then specified in the library.

New Member

This is much needed. I have the same App for all my customers but the SQL database for every customer is different. Now I have to open the open and replace all connections to the different tables that are being used. There must be an easier way. 

Kudo Collector

Hey powerapps staff! Any news on this?

New Member

Much needed feature to be able to push a template from development to multiple production environments (which all have the samen structure, but a different SQL data source). 

New Member

I absolutely agree with this. Failing to provide dynamic data source support violates the basic open/close software engineering principle. You shouldn't need to modify the app in order to use it in a new, practically identical, environment.

Frequent Visitor

Excellent idea.

Today I have a document management system and data for each department is stored in different SharePoint libraries (for obvious reasons, ISO 9001, data separation, but also because content types might be different).

What I have to do today is duplicate the same screen for 15 departments and change the datasource to point to the department library in each source.


What I'd like, is one screen and to be able to change the datasource dynamically seeing as the display and functionality is eactly the same for each department.

Advocate II

Absolute essential, much needed. And would be perfect to have something like Set(DataSource, Switch(User().FullName,Name1,Source1,Name2,Source2)). Obviously wouldn't work in this case now, but I tried in hopes that it would 😞

P.S. There is workaround now, to have all the tables in a collection OnStart, and then LookUp based on the user, but I would then have to paste all that code in every screen that I would want to have a conditional dataset. Not too neat, but I guess what we'll have to use until updates on this topic

New Member

It would be great if the user could select the APP data source, for example I could develop the app based on a standard SharePoint List, but when the user play the app he/she would select what SharePoint List he/she wants to use, the structure of the list must be the same, though.