Going crazy trying to Insert Records on a data table with variables

(0) Share

Report

Posted on by rpatinopty

I have been trying to get this work with no success, I am able to insert records to the data table with text

with the insert row action but if I built the exact same syntax but put on a variable it doesnt work

I created a variable gridinsert which has the same syntax as the manual static text but it keeps sending error amount of values provided to be added dont match the columns of the data table

Any ideas is greatly appreciated

Categories:

Power Automate Desktop

I have the same question (0)

All responses (6)

Answers (1)

Sort by

VishnuReddy1997 2,666 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @rpatinopty ,

Can just provide the screenshot of both DataTables and wanted to how many columns both Contains.
Meanwhile,Double-check the number of columns in your data table.Both Should have same.

(Note:- if you got your solution you can mark as solution and gives kudos)

Thanks & Regards
Vishnu Reddy

Was this reply helpful? Yes No
Deenuji_Loganathan_ 6,255 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

@rpatinopty

Allow me to provide an example to illustrate how I implemented it in my specific scenario.

Here's the structure of my data table:

And this is the format of my list:

Instead of attempting to create individual rows, I directly extracted values from the grid list and inserted them into my grid records data table.

After the insertion, the results appear as follows:

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No
rpatinopty 21 on at

Like
a
(0)

Report
Copy link

Link copied!

It is a 2 columns data table and this is the content of the variable I am using called GridInsert using the insert row int data table action

Was this reply helpful? Yes No
Verified answer

eetuRobo 4,572 Super User 2026 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!

It seems like your Set variable GridInsert is string of text. So thats why it will give error since you are trying to insert a string of text into a datatable that is expecting values for two columns. Since you only give it one string it gets value for one column alone.
Your set variable GridInsert should looks like this:

Was this reply helpful? Yes No
Deenuji_Loganathan_ 6,255 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

@eetuRobo

My above suggested approach also works in similar way but where instead of creating a row, directly I pushed values from list into data table 🙂

Was this reply helpful? Yes No
rpatinopty 21 on at

Like
a
(0)

Report
Copy link

Link copied!

It worked thanks a lot god bless you!!!

Was this reply helpful? Yes No