Share
ReportHi 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.
- 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!
Thanks in advance!
Categories:
All responses (
Answers (
2,547
