Update a value in a nested Dataverse table

(0) Share

Report

Posted on by FrankEsch

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.

Any help is appreciated.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Mira Ghaly 11,413 Moderator on at

Like (0)

Report

Re: Update a value in a nested Dataverse table

@FrankEsch

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

/nestedtableschemainplural/guid

Was this reply helpful? Yes No
FrankEsch 40 on at

Like (0)

Report

Re: Update a value in a nested Dataverse table

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.

Was this reply helpful? Yes No
FrankEsch 40 on at

Like (0)

Report

Re: Update a value in a nested Dataverse table

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

Was this reply helpful? Yes No