Power Platform Community Forum Thread Details

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

Categories:

Building Power Apps

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:

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: