Change SP data connection to different list

[aortiz-arroyo]

Hello,  I have a PowerApp with a SharePoint Connection to ListA.  During the developement we created a different ListB that now replaces ListA.  How can I cange the SharePoint Connection from ListA to ListB?  I can definetly add a new connection, but I cannot switch.  ONly way I have found is to delete the existing connnection and go object by object and change it.

[v-xida-msft]

Hi @aortiz-arroyo,

Could you please share a bit more about your scenario?

Do you want to replace List A data source within all related formulas within your app using List B data source?

Currently, if you use List A as data source within all formulas within your app, and you want to replace it with/using List B, you could only go object by object (one formula by one formula) and change it.

As an fixed solution, you could consider take a try to save your SP List A as a Collection in your app (using ClearCollect function as below), and then use this Collection as a data source within your all formulas instead of List A.

Set OnVisible/OnStart property of the first screen of your app to following:

ClearCollect(DataCollection, ListA)

Use the DataCollection as data source within your all formulas in your app instead of List A. When you want to replace List A with List B, please modify above formula as below:

ClearCollect(DataCollection, ListB)

Best regards,

Kris

[aortiz-arroyo]

Hi @v-xida-msft,

In my scenario when we started development the PowerApp was using list .../sites/SiteA/ListA/.  Because of changes we made to the list and/or now it will reside in a different site collection we need to change the connection to SharePoint for said list.  In my mind, this is like changing the database name from a database connection string.  Currently in flow, I cannot change that for an existing SharePoint connection, I will have to delete it and add a new SPO Connection, and have to go through the code to change the connection name as well, because the list name changed.