web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Need Help with Excel a...
Power Automate
Suggested Answer

Need Help with Excel and SharePoint List Sync in Power Automate

(1) ShareShare
ReportReport
Posted on by CU13091929-1 2
Hey everyone,
 
I'm setting up a flow in Power Automate to keep an Excel file on SharePoint in sync with a SharePoint list. I've got the basics down but am hitting a few snags and could use some pointers.
 
What I'm working with:
 
Excel Online: My Excel file has several columns for tracking data (IDs, dates, statuses, and more).
 
SharePoint List: I made a list that matches the Excel structure to sync data across.
 
What I'm trying to do:
 
New Entries: When a new row pops up in Excel, I want to see a new item in SharePoint.
 
Updates: If something changes in Excel, it should update in SharePoint.
 
Tried something but its giving me error wish if anyone could help out
 
 
20240914_010121.jpg
Categories:
Using flows
I have the same question (0)
  • Suggested answer
    Michael E. Gernaey Profile Picture
    Michael E. Gernaey 53,969 Moderator on at
    Hi
     
    You haven't probably us what the error is, what its doing and not.
     
    Also you don't have your apply to each opened, so it wont tell us what you are doing.
     
    Go to a Run, and show us picture sof that, with all the actions opened and the inputs and outputs of the actions.
     
    I also noticed you used a Scheduled Flow. You could however, use the SharePoint when an item or file is created or modified
    Since you said the Excel is IN SharePoint, this would allow you to be trigged when the updates happen.
     
    Totally up to you. I do not know how your file gets updated and by whom. Another issue is someone opens it and they dont close it and then things dont work
     
     

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 592

#2
Valantis Profile Picture

Valantis 340

#3
11manish Profile Picture

11manish 284

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!
Survey: Power Automate mobile app
How to Ask for Help with Your Power Automate Workflow
Flows are not visible for users who sign in with their personal accounts
Start and wait for an approval action
Restore a deleted flow
List of actions cheat sheet for Power Automate Desktop
Question for everyone : How are you using Create Text GPT in AI Builder?
Welcome to the Power Automate forum!

Product updates

Microsoft Power Platform Community release plans