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

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Create a flow to read ...
Power Automate
Suggested Answer

Create a flow to read rows from an excel table dynamically

(1) ShareShare
ReportReport
Posted on by 53
In my company there are several work groups that work on different sharepoint sites
and they fill out a table in an excel file every month.
each site has its own excel file and all the excel files have the same name and are in a Document library with the same name.
I would like to create a Power automate flow that reads the URLs of the sites from a Sharepoint list and reads from each site the table called "Gestione Maestranze.xlsx" in each site.
I can't dynamically pass the values ​​to the List rows present in a table action, every attempt gives me an error.
Does anyone know which values ​​to pass as 
Document Library, File and Table.
Thanks
Categories:
I have the same question (0)
  • Suggested answer
    Nived_Nambiar Profile Picture
    18,136 Super User 2026 Season 1 on at
    Hi 
     
    Try to provide the site url value as dynamic while provide all other fields values as static/custom value
     
     
    I assume there is no change in other fields.
     

    Thanks & Regards,
    Nived N

    Stay connected:
    LinkedIn | YouTube | Blogs

    Was this answer helpful?
    If yes, please mark it as the solution by selecting the checkbox in the discussion thread.
    Your feedback motivates me to keep contributing. Thank you!

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

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!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 237 Super User 2026 Season 1

#2
David_MA Profile Picture

David_MA 173 Super User 2026 Season 1

#3
Kalathiya Profile Picture

Kalathiya 95 Super User 2026 Season 1

Last 30 days Overall leaderboard