I want to keep a SharePoint list up to date with a database which is constantly changing:
The reason why I want to keep a single list is that the list is connected to Power Apps as a data source. I have heard that changing data source is not ideal. Please advice otherwise.
Piggybacking my last question. If I could use Excel instead of CSV that would be even better - not sure if that's possible or not though. Thanks again.
Hi Eric - this solution may be exactly what I've been trying to figure out for a month (not a technical guy, just a freelance functional consultant). I've used the update items / create items actions before from your second screenshot, but the first step you showed gets the data from SQL which kinda stumps me. I have a regular csv file that I have to download from another source every day and I created a SP list with it initially but can't update it. Can I use your approach here to update existing items with any changes & add new items to the list every day from my csv file? Do I need to do something with sql or are there other triggers/steps I need?
Thanks in advance for any insight you can share!
Hi @Anonymous
Hi @eric-cheng,
Thank you for the prompt reply! As I am quite new to Power Automate, could you please also show me the flow box that is used to update the sharepoint list? Many thanks in advance.
Hi @Anonymous ,
You can use the below triggers to trigger flows when a SQL table row is inserted or updated. Your flow can then create/update a SharePoint list item.
--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up