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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Problems working with ...
Power Automate
Unanswered

Problems working with Excel dynamically in Power Automate

(0) ShareShare
ReportReport
Posted on by
Hi all,
I am trying to automate a flow in Power Automate that adds rows to a table in one or another Excel file according to variable .
  •     I have several Excel files with dynamic names, for example: “VASESPAÑOL variable.xlsx”.
  •     Within these files, there is always a table called “Table2”.
  •     The idea is that according to a variable that is obtained previously, Power Automate performs the action in the corresponding file and the table to add rows.
The problem.
  1.     The action “Add a row to a table” does not recognize the table structure when the name is dynamic, and does not allow me to map the columns.
  2.     If I specify a fixed file and table (without using the variable name), it works perfectly.
How can I make Power Automate recognize dynamically the columns of the table when the file name is variable?
 
I really appreciate any advice, examples or solutions you can offer me.
Thanks in advance!
 
Categories:
I have the same question (0)
  • narayan225 Profile Picture
    2,547 Moderator on at
    I have worked on this problem in the past.
     
    You will need to create objects with the column name and value mapping and then add the collection of objects into the row field in the action.
     
    Like this:
     
     
    Hope this helps.
    Cheers!

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
David_MA Profile Picture

David_MA 112 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 52

#3
Ellis Karim Profile Picture

Ellis Karim 51 Super User 2026 Season 1

Last 30 days Overall leaderboard