Hi @Anonymous ,
Thanks for reaching out.
There is indeed a known issue with the Excel (Business) connector, that it does not support dynamic content in the "File" and "Table" fields.
Below is a similar request from users on the Power Automate Ideas Forum, which you can vote for: Dynamic content in File & Table inputs - Excel (B... - Power Platform Community (microsoft.com)
Alternatively, you can propose a new idea for voting by other users in the same Forum.
----------------------------------------------
However, there is a workaround to implement your needed functionality by using IDs in those fields from file metadata and the table inside your Excel file.
For your case, after you use the List files in folder action from the OneDrive for Business connector, inside the Apply to each loop, you have the following:
1. Get file metadata (OneDrive connector) - pass the ID value from the "List files in folder" as dynamic content;
2. Get tables (Excel Business) - select OneDrive in the first 2 fields and pass the ID value from "Get file metadata" as dynamic content;
3. Open another Apply to each loop (iterates through tables in file)
4. List rows present in a table (Excel business) - select OneDrive in the first 2 fields and pass the ID value from "Get file metadata" for the "File" field and the ID value from "Get tables" for the "Table" field as dynamic content;
5. Open another Apply to each loop (iterates through rows in table)
6. Add row into a table (Excel Business) - select OneDrive, your destination file and your table for first 4 fields, and for your columns write the expression item()?['SourceTable_ColumnName']
Your flow should look like this:
And here is the complete flow:
The ID value of the created excel file and the table make it possible for the Excel connector to reference those elements through dynamic content.
The last "Apply to each" loop is needed in order for the "item()?['Value']" expression to reference the values of each row, as "item()?" gives you context to the currently running item in the loop.
Please try this and then apply the same logic to the rest of your flow.
Let me know if there is anything else I can help with.
Regards,
Antonia Nanau
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
