web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Add & update excel dat...

Power Automate

Answered

Add & update excel data to the SharePoint list. (Schedule flow)

(0) Share

Report

Report

Posted on by IslamFahmy5

30

Hi everyone,

Although I prepared my flow with schedule action every 60 M, i still need to run my flow manually to update the SharePoint list while the excel table has been updated or added a new row, i will attached my flow action with edit mood, in order to check well.

so, appreciate your support regarding.

Screenshot 2024-01-04 132903.png

Screenshot 2024-01-04 132954.png

Screenshot 2024-01-04 132932.png

Categories:

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @IslamFahmy5,

Do you want to update SP list based on Excel updates?

If so, I think you should modify you flow as below:

length(body('Filter_array'))

On my side, I have a condition to check if one item in Excel has been existed in SP list, if yes, update an item, otherwise, create an item.
IslamFahmy5 30 on at

Like
a
(0)

Report
Copy link

Link copied!

hi @v-qiaqi-msft
Thank you for your support, actually its was perfect solution (easier, faster & effective), but how like that solution not shared in any of YT tutorials. it was amazing!!

in additional, (for the old flow) can you share the reason why of my SP list wasn't updated, if only I made a run flow despite of, I scheduled to run every 60 seconds?

Join the conversation