web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Use a Dynamic Table Na...

Power Automate

Answered

Use a Dynamic Table Name in 'Update a Row' Dataverse Action

(1) Share

Report

Report

Posted on by donalmc

304

I am trying to use a dynamic table name in the Update a Row Dataverse action and am hitting a syntax challenge.

The images below show what the peek code output is if I did it the normal way and when I try to use a dynamic table name.

Update a row 2 fails with "The request entity's media type 'text/plain' is not supported for this resource."

Is it even possible to do what I am trying to do?

Thanks

Categories:

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (1)

Verified answer

Brian_The_Tran 10 on at

Like (1)

Report

Have you found a solution for this? I see your post and I am able to figure out the solution for what I am trying to do. "Row Item" value must be in the JSON format i.e. {"firstname":"test", "lastname":"testtest"}. For your scenario, it would be {"item/activatestageid@odata.bind":"processstages(@{variables('Activate Stage ID')})"}. This will get assigned to "parameters" by the flow at run time as you can see from the output you have shown.

Was this reply helpful? Yes No
donalmc 304 on at

Like (2)

Report

Yes - and thanks for reminding me, as I had intented to update this post.
I solved it exactly as you describe - the JSON format is the key.

{
"activestageid@odata.bind": "/processstages(@{variables('Active Stage ID')})"
}

Was this reply helpful? Yes No
Mattw112b 1,088 on at

Like (0)

Report

I have this exact scenario but the "Row Item" I want to update is a Option Set. What would I use for the JSON for that? I've tried several things, so hoping someone knows.

Was this reply helpful? Yes No
Mattw112b 1,088 on at

Like (0)

Report
nvm, looks like I was overthinking it I just did this and it worked:

{ "new_practice": 100000015 }

Was this reply helpful? Yes No

Join the conversation