web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Insert Row Into Data T...
Power Automate
Answered

Insert Row Into Data Table Error

(0) ShareShare
ReportReport
Posted on by Nilufer Dogan 7

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.

0118770d-555d-4a4f-b9f1-92d4bacb8dc4.JPG
e5194cbd-e74d-4947-b26a-c6c6bc1222a6.JPG
Categories:
Power Automate Desktop
I have the same question (0)
  • Verified answer
    eetuRobo Profile Picture
    eetuRobo 4,522 Super User 2026 Season 1 on at
    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
  • Nilufer Dogan Profile Picture
    Nilufer Dogan 7 on at
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 959

#2
Valantis Profile Picture

Valantis 872

#3
Haque Profile Picture

Haque 589

Last 30 days Overall leaderboard

Featured topics

Known issue with browser automation in Power Automate for Desktop on Google Chrome 146 and 147
Share your ideas and struggles with building Power Automate flows!
Survey: Power Automate mobile app
How to Ask for Help with Your Power Automate Workflow
Flows are not visible for users who sign in with their personal accounts
Start and wait for an approval action
Restore a deleted flow
List of actions cheat sheet for Power Automate Desktop
Welcome to the Power Automate forum!

Product updates

Microsoft Power Platform Community release plans