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 / Add a new dataverse ro...
Power Automate
Answered

Add a new dataverse row gives odata error

(0) ShareShare
ReportReport
Posted on by 84

My powerautomate flow has an "Add a new row" action that gives an ODataUnrecognizedPathException.

JeroenJanssens_2-1675239605203.png

I checked the raw input and the IDs are all correct values.

JeroenJanssens_1-1675239569878.png

But I get this error

JeroenJanssens_0-1675239504207.png

Any thoughts on how I can fix this?

Categories:
I have the same question (0)
  • Verified answer
    JeroenJanssens Profile Picture
    84 on at
  • Verified answer
    Expiscornovus Profile Picture
    33,851 Most Valuable Professional on at

    Hi @JeroenJanssens,

     

    It looks like these fields are mostly lookups. In that case you want to refer to the name of the related table. @tom_riha has a blog about this approach:

    https://tomriha.com/how-to-update-dataverse-lookup-column-with-power-automate/

     

    In that case you could try and use a syntax like below for example for the Fractie field?

    In this example I guessed the name of your table, it might be different in your setup 😁

     

    /sgw_fracties(@{outputs('Get_a_row_by_ID')?['body/_sgw_fractie_value']})

     

    fractie.png

  • Expiscornovus Profile Picture
    33,851 Most Valuable Professional on at

    Hi @JeroenJanssens,

     

    Apologies, I did not refresh my page and I know see you already found the 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

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 March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 598

#2
Valantis Profile Picture

Valantis 477

#3
Vish WR Profile Picture

Vish WR 370

Last 30 days Overall leaderboard