You’re offline. This is a read only version of the page.
Announcements
3
Hi Everyone,
We have a use case where we are recieving multiple excel files (always the same format) into a onedrive folder and want to extract the rows from table in the excel file and insert into common document.
Source file name is dynamic, table is always called table1
Destination file is static and table1 matches table1 in the source for column names
The problem is that in the add rows to table function I cannot see a way to map the column names from the source.
I have attached a screen shot of the flow.
Does anyone have any ideas how to resolve this ?
Thanks
Matt
Hi @mdavies456 ,
Could you please share a bit more about your scenario?
Do you want to achieve your needs using Power Automate flow?
Based on the needs that you mentioned, I think the Workflow Definition Language expression could achieve your needs. I have made a test on my side, please consider take a try with the following workaround:
Within the "Add a row into a Table" action, set the TaskName field to following:
Share
Report
All responses (
Answers (
item()?['TaskName']set the Executor field to following:
item()?['TaskID']...
...
The flow works well as below:
On your side, please configure your flow as I mentioned above (remove the "Get Tables" action from your flow). Within the "Add a row into a Table" action, set the Name field to following:
item()?['Name']set the Email field to following:
item()?['Email']set the Studio field to following:
item()?['Studio']....
....
More details about the Item() expression, please refer to the following article:
Please consider take a try with above solution, check if the issue is solved.
Best regards,
