Power Platform Community Forum Thread Details

Hi everyone,

I’m running into an issue with a flow I just created in Power Automate. The flow copies an Excel file into a folder that doesn’t exist yet (the folder is created during the flow). When I use the “Add a row to a table” action right after that, I’m unable to map the different columns of my Excel table. Instead of seeing the usual column mapping options, I only get a single field called “Row to add into the specific Excel table”.
I’m not sure what I’m supposed to enter in this field.

I noticed that in the outputs of the previous step, two new columns appear:

@odata.etag
ItemInternalId

Right now, inside my loop, I’m sending the current item into the “Row to add” field, but this item includes those two extra columns. The flow doesn’t fail, so the row is technically added to the file, but all inserted values end up empty.
Has anyone already encountered this situation or knows what the correct way is to populate this “Row to add” field when the file was just created?

Thanks in advance!