cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
FrankEsch
Helper I
Helper I

Update a value in a nested Dataverse table

Hi,

 

I have a Dataverse instance that I would like to update through a PowerAutomate FLow. 

I can update the field on the first level, but if I try to update a field in the nested table, it failed. 

 

In my screenshot "Status" is a field in table "Competences". "Value" is an nested table that has an field "ValueNumber". I wan't to update "ValueNumber" for this Competence. 

 

UpdateRow.png

Any help is appreciated.

1 ACCEPTED SOLUTION

Accepted Solutions
Mira_Ghaly
Dual Super User
Dual Super User

@FrankEsch

You need to pass the value of the nested table as:

/nestedtableschemainplural/guid

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

View solution in original post

3 REPLIES 3
Mira_Ghaly
Dual Super User
Dual Super User

@FrankEsch

You need to pass the value of the nested table as:

/nestedtableschemainplural/guid

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

I don't get it. (I'm relatively new with the use of Flow). I've tried almost every combination. 

 

In PowerApps I'm passing the GUID of the Value. In Flow I tried different combinations to update the field "Value", with not result.

updateArow2.png

Table_Value.png

FrankEsch
Helper I
Helper I

FrankEsch_0-1618230995772.png

Fixed, had to prefix with my custom table value. "customtable_entity(row)"

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022- Season 2 has kicked off!

Users online (4,304)