Insert row into data table

(2) Share

Report

Posted on by 79

Hello,

I'm trying to insert row into data table when there is two columns and I'm not able to do that I'm facing this error:

The amount of values provided to be added (1) don't match the columns of the data table (2).

How I can specify column with this command?

Thank you.

Categories:

Power Automate Desktop

I have the same question (16)

All responses (6)

Answers (2)

VJR 7,635 on at

Like (0)

Report
Copy link

Link copied!

Hi @79

This post should answer how to insert row either using List or a datarow, if not then a variable using + character.

Was this reply helpful? Yes No
79 15 on at

Like (0)

Report
Copy link

Link copied!

but is it possible to insert variable not value in this case?

Was this reply helpful? Yes No
ryule 929 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Refer to these as well:
https://www.flowjoe.io/2022/04/12/add-variables-to-a-data-table-on-power-automate-desktop/
https://powerusers.microsoft.com/t5/Power-Automate-Desktop/How-to-Add-Data-to-Data-Table/m-p/1582707/highlight/true#M14217

Was this reply helpful? Yes No
Verified answer

VJR 7,635 on at

Like (3)

Report
Copy link

Link copied!

Absolutely, you can add a variable instead of a direct value but the variable needs to be used in the right syntax.

This is a 2 column datatable and InputVariable1 and InputVariable2 are two different variables.

Set Variable:

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (3)

Report
Copy link

Link copied!

hi @79

Try this
This is values for three columns

1 people found this reply helpful.

Was this reply helpful? Yes No
ryule 929 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Please refer to this post by @JCiriello98
https://powerusers.microsoft.com/t5/Power-Automate-Desktop/To-create-DataTable-in-Power-Automate-Desktop/m-p/1705004/highlight/true#M16885

Was this reply helpful? Yes No