Power App - Changing Data Source on Existing App

%3CLINGO-SUB%20id%3D%22lingo-sub-2139530%22%20slang%3D%22en-US%22%3EPower%20App%20-%20Changing%20Data%20Source%20on%20Existing%20App%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2139530%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20all.%20Seeking%20some%20advice%20on%20changing%20an%20app's%20data%20source%20after%20the%20app%20is%20up%20and%20running.%20We%20have%20a%20SharePoint%20list%20that%20is%20connected%20to%20a%20Power%20App.%20From%20time%20to%20time%2C%20our%20plan%20changes%20and%20the%20underlying%20sharepoint%20list%20needs%20to%20be%20updated.%20I%20have%20been%20going%20in%20and%20manually%20updating%20the%20sharepoint%20list%20-%20this%20is%20time%20consuming%20and%20prone%20to%20error.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20I%20could%20upload%20from%20excel%20our%20new%20plan%20into%20sharepoint%20list%20and%20reconnect%20the%20app%20to%20the%20new%2C%20updated%20data%20source%3F%20Will%20this%20screw%20up%20the%20power%20app%20ID's%20that%20are%20always%20applied%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20better%20way%20to%20update%20the%20sharepoint%20list%20when%20our%20plan%20changes%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%20in%20advance%2C%20for%20any%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPaul%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2139530%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Esharepoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Contributor

Hi, all. Seeking some advice on changing an app's data source after the app is up and running. We have a SharePoint list that is connected to a Power App. From time to time, our plan changes and the underlying sharepoint list needs to be updated. I have been going in and manually updating the sharepoint list - this is time consuming and prone to error.

 

Is there a way I could upload from excel our new plan into sharepoint list and reconnect the app to the new, updated data source? Will this screw up the power app ID's that are always applied?

 

Is there a better way to update the sharepoint list when our plan changes?

 

Thanks, in advance, for any help.

 

Paul

1 Reply

@slohombre It depends on a PowerApps type. If you use PowerApps for SharePoint form customization, I think that it's not possible. But if you have a standalone application, and you want to switch between lists with the same name and structure (column names and types), but on different webs, there is a way. You can remove the connector definition from the app and add new to the second location. Make application backup before this step, of course.