Answered

How to Insert a Row into Data Table with Power Fx Enabled

(1) Share

Report

Posted on by Mark Nanneman

991 Moderator

What's the proper way to write the "New value(s)" expression for an "Insert row into data table" action in a PDA flow with "Power Fx" enabled? Is it possible?

I'm trying to expand my knowledge of Power Automate Desktop and have been exprimenting with "Power Fx Enabled" PDA flows.

I noticed an issue with inserting rows into a data table that I haven't been able to figure out. I tried reading the Power Automate Desktop documentation and searching the forums, but didn't see an answer.

First of all, the notation required is different when I use "Power Fx Enabled" vs without.

This works fine on the Power Fx DISABLED flow:

The only way I could get the Power FX ENABLED flow to run without errors was to write the expression like the following (the %[]% format would cause an error):

However, this inserts an object into each table column:

I saw one suggestion on another similar question about setting the table to a variable, and then using a Collect() Power Fx expression, but I could not get that to work either.

Anyone know the proper way to do this, or why it's behaving like this?

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

eetuRobo 4,484 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

I think the Power Fx enabled version is still lacking in some ways like data table handling. Only ways I have been able to insert rows so that they have normal values are:

1. create "Insert row into data table" in a regular PAD flow first. Then copy and paste that into you Power Fx enabled flow. Like so:

Downside is that if you try to edit that action ever in Power Fx it will break since it wants corrext power fx syntax. So that action editing has to be done in the regular flow and the copy and paste it to the power fx one.

2. Create a script that inserts the row into data table. Like C# script:

Run .NET script action:

Result:

Similar issue I responded some months ago: https://community.powerplatform.com/forums/thread/details/?threadid=301cb040-f994-ef11-8a6a-000d3a8c383b

Was this reply helpful? Yes No
Esbastian 24 on at

Like (1)

Report
Copy link

Link copied!

Thanks!

It is madness how broken this simple activity is.

1 people found this reply helpful.

Was this reply helpful? Yes No
CU06020208-0 4 on at

Like (0)

Report
Copy link

Link copied!

I tried using powerfx Collect function, but it didn't work.

Only way I have been able to insert rows so that they have normal values was by create the list element by element...

I hope this can help.

Regards

Jaime

Was this reply helpful? Yes No