New actions for data tables - unclear input format

(0) Share

Report

Posted on by hoernchen

Hi all,

Hi all, I have a hard time to add data to a data table row with the new action "insert row into tada table".

Which format is needed to do that? My tries with a defined table of 4 colums were already:

1,2,3,4
1;2;3;4
"1";"2";"3";"4"
'1';'2';'3';'4'
1+2+3+4
['1'] + .........

Unfortunately the documentation is not clear in that point....

BR
Heiko

Categories:

Power Automate Desktop

I have the same question (0)

All responses (5)

Answers (2)

Sort by

ryule 929 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

I 100% agree with you that you should be able to insert new data directly into the table. I haven't figured out how to do it using these new Actions.

I did discover you can insert a row into the datatable with a list, as long as the list has the same amount of rows as the datatable has columns.
So for instance, below, I created a list with 3 rows of values, and then created a datatable with 3 columns, then inserted the list as a row, and it worked....

Was this reply helpful? Yes No
Verified answer

VJR 7,635 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @hoernchen

As you see in the parameter info that the row it accepts should be of type List or a datarow (for eg CurrentItem within a loop).

So go by @ryule's suggestion if you have a List or can dynamically create one.

On the other hand, if you are having your data in the form of strings or variables then go by the old approach of adding using the + character.

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

Was this reply helpful? Yes No
hoernchen 21 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi VJR,

thanks for your explanation, understood👍
I expected to have the functionaility of adding via the variable in the new insert row functionality, therefore I was confused....

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @hoernchen

Try this syntax
No need for lists or datarows

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

Like
a
(0)

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