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.
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.
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!
Problems working with Excel dynamically in Power Automate
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.
Share
Report
All responses (
Answers (
2,390
