cancel
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
Comments
JC75NATS
Advocate I

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.

mcharing
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. 

clau0289
Kudo Collector

Hey powerapps staff! Any news on this?

LuukJ
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). 

kevinlrak_csu
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.

nbuttery
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.

raf-avag_99
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