
Announcements
Dear Power App developers,
I would like to ask for your best practice opinion on the following scenario.
I have a power app which is taking multiple data from SharePoint lists for various lookups, drop-downs, filters etc. In my situation it can happen that a whole SP list changes so I need to replace it by a brand new one (not just change a couple of items e.g., new results published monthly etc.).
What do you think is the best way for an user to replace the SP list items completely (please note header names should remain unchanged only the items should be replaced).
I was thinking to build a flow with a folder trigger which a) deletes old SP list items, b) takes new row data from excel and c) create new SP list items but I wanted to ask your opinion first, as this seems to be a frequent case.
Thank you for your thoughts.
In general you are on the right track. Trying to do this in PowerApps can be done, but it is a little counterintuitive to have an app do this based on a user. Instead you would want PowerAutomate to do the data changes behind the scenes so that when the user uses the App, it has the appropriate data.
I hope this is helpful for you.