Replace Sharepoint list

[apeawakening]

My company is moving from SP Onpremise to SP Online , I have created a standalone canvas app and the datasource is a SP list A(for example) after migrating the that SP list from On-premise to SP online site created a new SP Online list B.
Now my task here is to replace the datasource SP List A with new SP List B, so what are the best ways in which I can replace all columns and all other formulas without affecting my app performance and all validation applied to it ?
I'm looking expert advice .

[WarrenBelz · Accepted solution]

Hi @apeawakening ,

If you delete the old data source (first) and then add the new one, you should be able to use the Find and Replace (bottom icon on your left side bar) to replace all instances of the old name with the new one. If the field names and types are identical, it all should work.

Please click Accept as solution 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 Thumbs Up.

MVP (Business Applications)   Visit my blog Practical Power Apps

[apeawakening]

Thanks Warren, but my list B is having different column name , than how shall I go ahead with it.
My Schema is same , but column names are different .

[WarrenBelz]

@apeawakening ,

Same process, you will have to replace all instances of each column name with the new ones (and I assume you do not have two column names the same but with different data). This could be tricky if you have a column name being part of another's name, so start with the long ones first.

[apeawakening]

Okay , I get it.
Now I'm thinking , if I try to change the name and column of List A exact same of List B, will that work fine for search and replace or I have to replace all instance one by one of column ?

[WarrenBelz]

@apeawakening ,

One by one for each column - this would be much easier if you simply used the same column structure.