0

I have been trying to update several rows in the lookup column in my microsoft dataverse table using power automate. My flow is supposed to list all rows, and then update the same column in each row. At first I was getting "URL Not Parsed" error from my Update a Row block, but after finding the EntitySetName I stopped getting that error. Now it simply says I have a bad request error.

Error message enter image description here

I am struggling to find my error here, I have checked that I am using the correct logical names for my columns multiple times. I remade the flow from scratch. Nothing has been working. I'll include a screenshot of my overall flow, of the individual components, and of my error message. Any help would be greatly appreciated

My overall flow

enter image description here

Apply to each

enter image description here

my compose. I can't understand why this isn't returning me the one value I'm looking for.

enter image description here

My actual Update a Row. I looked up the plural entityname for the lookup table, crfbf_financialrecords. Before that I was getting 'URL Not Parsed' error, but since I added the correct name now I've just been getting bad request

enter image description here

Improve this question
2

1 Answer 1

Reset to default
0

Your Compose step is a mix of an expression and free text, that won't work.

You need to use the expression editor when adding your first() expression ...

enter image description here

... next step ...

enter image description here

... then your expression will look like this ...

enter image description here

Improve this answer
1

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.