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
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
Was this reply helpful?YesNo
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.
2
Share
Report
All responses (
Answers (
