Answered

Excel Flow on Sharepoint.

(0) Share

Report

Posted on by CU26021815-0

Hi everybody.

I'm looking to build a flow to automatically update an excel file on sharepoint. But I can't find a solution to my problem.

What the flow should do:

When an excel file is added to sharepoint run a script to format it as table (already works)
Then after that copy the table and add the rows to another excel sheet (always the same file)

It might sound simple, but since i can't manually cklick on the newest added excel file (i instead use the identifier from trigger) i can't choose the correct table (Table1) in the action "List rows present in a table".

Does somebodey have a solution for this or maybe workarounds.

Thanks a lot in advance for your answers

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

rzaneti 4,476 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @CU26021815-0,

You can use the Get tables action to access all tables from an Excel file - it works great when you're working with tables created during the flow run :)

Based on your description, it looks like there will be only one table in your Excel file, so you can use a design like this:

Some comments:

- In the Add a row into a table action, you will inform the table dynamically, by accessing the name property of the first element of the Get tables output.

- Once you enter a dynamic table, Power Automate will not identify the table structure, so you will need to provide the row input in a JSON format (highlighted in blue). Make sure to match the property names identically to the name of your table columns.

Let me know if it works for you or if you need any additional help!

✅ If this solved your issue, please mark it as Accepted Answer.
👍 If it helped, feel free to give it a like!

🌐 Explore more Power Platform content on my Website or on my ▶️ YouTube
💼 Find me on LinkedIn

Was this reply helpful? Yes No
CU26021815-0 7 on at

Like
a
(1)

Report
Copy link

Link copied!

Thank's a lot!!!!!

I will check out your Youtube Videos

Was this reply helpful? Yes No