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,484 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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