Populate an Excel Sheet Table for an Excel sheet file that will be created inside the Flow

(0) Share

Report

Posted on by johnjohnPter

1,811 Super User 2024 Season 1

I have those actions as part of a flow, Where I am getting the file content of an excel sheet which contain a table >> Then i am creating a new excel sheet >> but when i tried to populate the table of the newly created excel sheet, the "Add a Row into a table" did not show the table columns, as follow:-

While if i explicitly reference a file which was created already inside another flow run, I will get the excel sheet Table's fields as follow:-

so how i can have the same option for the newly created excel sheet inside the same flow run?

Thanks

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report

Use Get Tables action to retrieve tables from a worksheet and then reference your table from the output in the Add a row action.

Was this reply helpful? Yes No
johnjohnPter 1,811 Super User 2024 Season 1 on at

Like (0)

Report

@SudeepGhatakNZ

Thanks for the reply, but i did not get what i need to do? also your picture is trimmed at the end so i can not see the final result. also why you are getting the table first ? we can directly reference the table inside the "Add a row into a table" action,, but i did not get the cells.. this is my main question..

Was this reply helpful? Yes No
Suggested answer

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report
@ johnjohnPter

Sorry I might not have explained properly.

Since the table doesn’t exist at design time in the flow, Power Automate won’t initially recognize the columns in the "Add a Row into a Table" action. However, there might be a work around this limitation. I haven't tested it though.

Start by creating a temporary (dummy) Excel file with a table that includes the columns you intend to use in your new file.

Set this table with the exact column names you’ll eventually want in the new file’s table. This will allow Power Automate to recognize the column structure in the designer.

In your flow, add the Add a Row into a Table action and point it to the dummy Excel file.

Select the table and map your data to the columns you want to populate.

After defining the columns in the "Add a Row" action using the dummy file, switch the file reference to use dynamic content

Was this reply helpful? Yes No