Unanswered

Update Multiple Excel Tables with List data in Power Automate

(0) Share

Report

Posted on by bbesant

Hello All,

I have a SharePoint site that contains multiple excel files within the General folder and subfolders. Each of the excel files have the same Table11 within them. I also have a List that holds information about individual emails. I need all of the tables to have the same information that is in the list. Whenever the List item is updated I need it to iterate through the folders and update all of the Table11 located in each excel file.

Can this be done using a Power Automate Flow?

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (0)

Michael E. Gernaey 53,928 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

@bbesant

Hi there, as this is a yes or no question, I will answer you, Yes, it would be easy to do.

If you please mark this one as Resolved/Answered, and possibly a thumbs up, and if you need help making it, please make another Question(post) for that.

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
bbesant 18 on at

Like (0)

Report
Copy link

Link copied!

@FLMike Thank you for the Yes answer. Any chance I could get help with how to set up this flow?

I have tried to Get the file properties from the individual excel files. With an apply to each loop I am listing rows present in table. I than tried another apply to each loop to update a row but I am unable to figure out how to get the column values that normally appear when you select a table from the dropdown.

Was this reply helpful? Yes No
bbesant 18 on at

Like (0)

Report
Copy link

Link copied!

@FLMike

Hello again. I was wondering if I could get some guidance on this request? Thank you!

Was this reply helpful? Yes No
bbesant 18 on at

Like (0)

Report
Copy link

Link copied!

Hello @FLMike ,

Sorry to be a bother but I could really use some assistance on this task. Still having issues 😞

Was this reply helpful? Yes No
bbesant 18 on at

Like (0)

Report
Copy link

Link copied!

If anybody has any solutions using Power Automate web I would greatly appreciate it.

Was this reply helpful? Yes No
bbesant 18 on at

Like (0)

Report
Copy link

Link copied!

@FLMike Hello. You mentioned that this would be easy. Would you be able to show me the flow? I am still stuck with this 😞

Was this reply helpful? Yes No