Insert row into data table

Like (2) Share

Report

Posted on 4 Aug 2022 11:10:50 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.

I have the same question (0)

Summarized by AI

AI generated content may be incorrect

Did you find this summary helpful?

All responses (6)

Answers (2)

ryule 929 Super User 2024 Season 1 on 08 Aug 2022 at 14:27:28

Like (1)

Report

Re: Insert row into data table

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
Verified answer

Community Power Pla... on 08 Aug 2022 at 11:25:48

Like (3)

Report

Re: Insert row into data table

hi @79

Try this
This is values for three columns

Was this reply helpful? Yes No
Verified answer

VJR 7,635 on 05 Aug 2022 at 03:06:05

Like (3)

Report

Re: Insert row into data table

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
ryule 929 Super User 2024 Season 1 on 04 Aug 2022 at 14:27:53

Like (0)

Report

Re: Insert row into data table

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
79 15 on 04 Aug 2022 at 11:33:41

Like (0)

Report

Re: Insert row into data table

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

Was this reply helpful? Yes No
VJR 7,635 on 04 Aug 2022 at 11:18:38

Like (0)

Report

Re: Insert row into data table

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