Start and wit approval - doesn't update the approver's response and showing error

[Wah22]

I am creating a flow for approval connecting with power apps. When the approver responses approve or reject , that response needs to be updated at the status column at dataverse. The flow can be seen in screenshot. I have the opportunity ID in dataverse. I don't know what is wrong in my flow. 

[ScottShearer]

@Wah22 

When you run your Flow, what happens?  Do you see an error?  If so, what is the error?

[Wah22 · Accepted solution]

The error shows as below. 

{ "error": { "code": "0x80060888", "message": "Bad Request - Error in query syntax." } }

When I put the responses approval ID at Get a row action, the error shows ' Entity does not exit'.

[ScottShearer · Accepted solution]

@Wah22 

The issue is with the row ID - here is a link that will help you resolve your issue.

[Wah22]

HI Scott,

How to get that GUID from a row? Can I only put the opportunity ID from dynamic content? 

Thanks. 

[ScottShearer · Accepted solution]

@Wah22 

While I am no Dataverse expert, I know that each table has a primary column and the primary column has a GUID associated with each row in that column.

Go to dynamic properties and search for "unique" - you should be able to select the GUID associated with that row.

[Wah22]

Hi Scott, 

The flow works successfully. But the outcome of approver doesn't update in status column. Should I put dynamic content "outcome" or just choose approved from multiple choice in default? 

[ScottShearer]

@Wah22 

Use the same row id in the update action as you did in the get a row action.  You cannot update the unique ID.

Give this a try and see if the approval status is updated.

What type of column is Opportunity ID?

[Wah22]

Hi @ScottShearer ,

It doesn't work and update at the table. The flow ran one time successfully and now it is still running. At the successful running stage, I put the outcome from dynamic.  When I try again , it is still running as screenshot. 

[Wah22]

Hi @ScottShearer , 

I still haven't solved the issue yet. Can you please help me to solve?

[ScottShearer]

@Wah22 

The screen shot above indicates that the approval has not yet been completed. 

[Wah22]

Hi @ScottShearer , 

The flow ran successfully. But the outcome of approval is not updating at the dataverse and powerapps as well.

Here is my flow process to update the data. I would like to update the status column based on the approval response.