Column names "In insert row into data table" or "Set variable"

(1) Share

Report

Posted on by JA-04031051-0

Power automate desktop - Column names "In insert row into data table" or "Set variable"

Hi all

I'm a newbie in power automate, and I'm trying to create a flow that will save me from having my brain fried everyday by repetitive tasks

I'm trying to to insert a new row into an existing data table. The catch is that I'm trying to use column names in my expression, and for the life of my, I cannot find how to do that online
Each data row will contain over 15 columns for me, I need to be able to keep track of column in the expression

I know how to create a new row, without column names using the "set variable function/insert row functions": (EG. %DataTable + ['1', '2']% // "%['1', '2']%)

Ideally my syntax would look something like "%DataTable + [DatabaseColumn1:'1', DatabaseColumn2'2']%

Is this possible?

I've literally been at this for over 2 hours, any help appreciated

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

eetuRobo 4,204 Super User 2025 Season 2 on at

Like (0)

Report

When you insert a row in to datatable you need to give all the columns some value. I recommend first using "Insert row into datatable" -action where you give all the columns a default value or just empty string ''
Then use "Update data table item" -action to update certain column in the row.

In this example I use "Insert row into data table" -action to insert empty values to a datatable that has 7 columns. So the syntax is seven times empty string: %['', '', '', '', '', '', '']%
Then I use update table item to the datatable where I get to refer to the column by its name (Column6).

Result:

Was this reply helpful? Yes No
Suggested answer

AK_RPA 7 on at

Like (0)

Report

Hi,

You can refer to this ms learn document. This will give you more clarity on creating, updating data tables using set variable action.

https://learn.microsoft.com/en-us/power-automate/desktop-flows/variable-data-types#datatable

Was this reply helpful? Yes No