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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Dynamically Insert row...
Power Automate
Unanswered

Dynamically Insert rows to dataverse

(0) ShareShare
ReportReport
Posted on by 3

I have a flow that initially uploads Excel Documents to a SharePoint Location. The SharePoint files are then to be loaded to the corresponding dataverse table. Example Employee Information.xlsx is loaded to Employee Information table.

The bit I need help with is passing the row item to the Add a new row action. Column names in the Excel and table match letter for letter. i am referencing the table name dynamically, currently I am passing the row items in the format:

{
  "Column1": "xxx",
  "Column2": "xxx",
  "Column3": "xxxx"
}
 
The attached image shows the current flow.
 
I am reading the rows from the excel, removing some unwanted columns, then looping through each excel row to adding them dynamically to the table.
I need help with how the row input data is expected and any information known on the error above.
 
This gives me the error: 
Error identified in Payload provided by the user for Entity  Invalid property 'ID' was found in entity>Does not support untyped value in non-open type.
Dynamically Add Rows Issue.png
Categories:
  • Jcook Profile Picture
    7,783 Most Valuable Professional on at

    Hi @stul95 

     

    You will need to pass in the proper name for the table in dataverse. There will a prefix to your table name based on the publisher of solution.

     

    To find the exact name, select the table from the dropdown, click the 3 dots on the action and click “Peek code” check the table name.

     

    Than when your putting in the dynamic name for the table name, make sure to add that prefix first.

     

  • stul95 Profile Picture
    3 on at

    That is helpful thank you. It made me realise that I actually have the correct table names but I need to add a prefix to the column names. Any idea how i can dynamically add the same prefix to all columns within each object ? I've been trying for a few hours and can't seem to come across a logical/simple solution.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 321 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 271

#3
Henil Profile Picture

Henil 115

Last 30 days Overall leaderboard