Answered

I want to set up a flow that goes from a SharePoint List to Excel

(1) Share

Report

Posted on by Chilladin

Hello I'm pretty new / beginner to Power Automate and I'm trying to setup a SharePoint (SP) list to automatically take the current list and then update if i add new list elements to the SP.

Right now my flow doesn't update, but sometimes I'm able to get the 1st row to update, but there are 7 elements in my list.

I've posted the Flow, SharePoint list and Excel Document.

Flow:

This is my formular in the condition: int(length(outputs('List_rows_present_in_a_table')?['body/value']))

Excel document:

SharePoint List:

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Suggested answer

chiaraalina 2,425 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @CU09060506-0

Almost there. You need a Filter in the List rows present in a table action and use ID from SharePoint in the Add a row into a table. And the trigger should be When an item is created or modified.

Let me know if it worked!

Was this reply helpful? Yes No
Chilladin 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @Chiaraalina,

I tried to change the ID's and such, but when I ran it this happened:

Could the reason for it failing be the "For each 1" and "For each" Boxes? Cause I don't see them on your pictures.

Was this reply helpful? Yes No
Chilladin 8 on at

Like
a
(0)

Report
Copy link

Link copied!

@chiaraalina I think i didnt at you correctly I'll try this message, my bad.

Was this reply helpful? Yes No
Verified answer

chiaraalina 2,425 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Chilladin

Yes, please remove them, and do exactly how I did. It worked for me!

Let me know!

Was this reply helpful? Yes No
Chilladin 8 on at

Like
a
(0)

Report
Copy link

Link copied!

@chiaraalina, thank you for the help and solution! :)

Was this reply helpful? Yes No