Skip to main content

Notifications

Power Automate - Using Connectors
Answered

Updating SharePoint list with csv

(0) ShareShare
ReportReport
Posted on by

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

  1. Can I do that without creating a new list everytime?
  2. How can I pass the data? Is it by exporting .csv file to SharePoint?
  3. 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.

  • jkellyllc Profile Picture
    jkellyllc 4 on at
    Re: Updating SharePoint list with csv

    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.

  • jkellyllc Profile Picture
    jkellyllc 4 on at
    Re: Updating SharePoint list with csv

    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!

  • eric-cheng Profile Picture
    eric-cheng 5,171 on at
    Re: Updating SharePoint list with csv

    Hi @Anonymous 

     

    ericcheng_0-1626688433160.png

     

  • Re: Updating SharePoint list with csv

    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.

  • Verified answer
    eric-cheng Profile Picture
    eric-cheng 5,171 on at
    Re: Updating SharePoint list with csv

    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.  

     

    ericcheng_0-1626686969237.png

     

    --------------------------------------------------------------------------
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard

Featured topics