Answered

Insert Row Into Data Table Error

(0) Share

Report

Posted on by nilufer

I'm trying to patch seven variables generated in my flow to a data table named "SearchDetails". Despite following all the approaches suggested in the Microsoft documentation, I keep encountering an error.

Here's the expression I'm using:

Error I got after test (Values Provided To Be Added (1) Don't Match The Columns Of The Data Table (7));

So far, I've tried two approaches:

1. Using the "Insert row into data table" action and applying the function above.

2. Setting the variables individually and attempting to add them directly to the data table.

Neither method has worked. Any insights or suggestions would be appreciated.

Categories:

Process Advisor

0118770d-555d-4a4...

e5194cbd-e74d-494...

All responses (2)

Answers (1)

nilufer 4 on at

Like (0)

Report

Insert Row Into Data Table Error

eetuRobo I followed your advice, and it worked perfectly!

Thank you so much! Since it was my first time using Power Automate Desktop, I wasn't aware of this. I truly appreciate it.
Verified answer

eetuRobo 3,587 Super User 2025 Season 1 on at

Like (1)

Report

Insert Row Into Data Table Error

Hello,

Problem is that you are using Power Fx enabled flow and in the "Insert row into data table" -action you use regular flows syntax. Power Fx does not use percent signs. New values should be =["1", "2"]

I suggest you recreate the flow but do not enable Power Fx. That will give you more trouble than help unless you really need power fx.
If you stick with power fx then most likely next issue will be this: https://community.powerplatform.com/forums/thread/details/?threadid=cdf7dd06-3447-f011-877a-6045bda9c2a9

So read that thread and try solutions I gave there.

Hope this helps