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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Insert row into data t...
Power Automate
Unanswered

Insert row into data table - PowerFx

(1) ShareShare
ReportReport
Posted on by 47
Hello, I'm barely new in PAD and i want to perform something that it's not working as intended. 
I have a data table that I want to insert some data, i do this:
And although it does save it, it looks like this:
Could anybody please give me a hand on how to use it so i dont get it like that? Id like to have only the values.
 
Thanks!
I have the same question (0)
  • Verified answer
    eetuRobo Profile Picture
    4,204 Super User 2025 Season 2 on at
    With Power Fx in PAD datatables seem to still be bit difficult.

    Here is a thread that had this issue some time ago and I gave solution with two different ways to deal with datatables in Power Fx flows. So essentially either copy and paste insert row into data table -action from regular flow to your power fx flow or use script to handle data table actions
    https://community.powerplatform.com/forums/thread/details/?threadid=87055e07-a7cb-ef11-b8e8-6045bddb8ef7

    Also you can use "Update data table item" -action to update the row that you just added. Unfortunately you need to update every column per action.

    Insert row:


    After Update data table item on both columns:




    Could be that there is a way to do this in more clean way but since I never really use Power Fx enabled flows I haven't figured it out.

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

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard