Answered

Updating SharePoint list with csv

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I want to keep a SharePoint list up to date with a database which is constantly changing:

Can I do that without creating a new list everytime?
How can I pass the data? Is it by exporting .csv file to SharePoint?
Can I use Power Automate to carry out this task on a daily basis?

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.

Categories:

Using connectors

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Verified answer

eric-cheng 5,171 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
eric-cheng 5,171 on at

Like (1)

Report
Copy link

Link copied!

Hi @Anonymous

Was this reply helpful? Yes No
jkellyllc 4 on at

Like (0)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No
jkellyllc 4 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No