Update a row with Error 404

[Anonymous]

Hello,

I am create a flow with Microsoft Form: Once the form is submitted, its response is recorded on an excel; if submitted past a certain time, it will have to go through an approval, and i'd like to have the approval info being recorded as well so i used "Update a row".

I read a few post about the "Key value" under "Update a row" works best if dynamic. For me, the key value is the outcome of the approval so the flow has been returning 404 error. Please help.

 

[RezaDorrani]

Hi @Anonymous 

When you are updating the row

seems like you are providing the Id value as "Approve"

Id would be the unqiue value identifying your row

[abm]

Hi @Anonymous 

Could you please show your IF condition in design mode?

Thanks

[Anonymous]

Hi @RezaDorrani,

Sorry i am new, can you elaborate? The Key value is the "Outcome" of the approval, please see below:

[Anonymous]

Hi @abm ,

Like below?

[abm]

Hi @Anonymous 

Could you please map the outcome in a string variable before the update row. Then map the string vairable in your update row step.

If that doesn't work then check the run history variable value. Make sure this key value is unique in your excel sheet.

Let me know the outcome.

Thanks

[Anonymous]

Hi @abm 

Forgive me if below is not what you needed:

Outcome String:

{

"responses": [

{

"responder": {

"id": "5b842564-b750-4472-a5b7-993e828d07ff",

"displayName": " XXXX",

"email": "XXXXX",

"tenantId": "8bbff09f-621e-44c4-a92c-da664a64ac6d",

"userPrincipalName": "XXXXX"

},

"requestDate": "2019-09-16T19:43:16Z",

"responseDate": "2019-09-16T19:43:32Z",

"approverResponse": "Approve"

}

],

"responseSummary": "Approver:XXXXX\r\nResponse: Approve\r\nRequest Date: Monday, September 16, 2019 7:43:16 PM\r\nResponse Date: Monday, September 16, 2019 7:43:32 PM",

"completionDate": "2019-09-16T19:43:33Z",

"outcome": "Approve",

"name": "b95e0006-7ab4-4c52-ba8e-ec4f4c6f440c",

"title": "RUSH SERVICE APPROVAL NEEDED",

"requestDate": "2019-09-16T19:43:15Z"

}

Update a row:

{

"Late Request (Y/N)": "Yes",

"Approval Outcome": "Approve",

"Late Request Approver/Rejector": "XXXX"

}

[abm]

Hi @Anonymous 

Did your added a new variable step? Is this the output?

Thanks

[abm]

Hi @Anonymous

Please see below and check my previous replies. Hope it make sense.

[Anonymous]

Hi @abm 

What do you mean by "move the outcome into a variable" before the step? Can you elaborate how?

[Anonymous]

Hi @abm 

Do you mean the condition below shouldn't be a value, it should be variables?

[abm]

Hi @Anonymous 

Like this. Here map the outcome and use the variable name mapping in your update step.

[Anonymous]

Hi @abm 

I only have the basic preview version of the flow, so the variable functions are not available..

Is there any way i can do it with the basion version?

[abm]

Hi

Click New step. Under the choose action type variables. Check whether you can see initialise flow step available or not?

Thanks

[Anonymous]

Hi @abm 

Yes, i found the variables and did below. But the run is still popping Error 404.

[v-litu-msft]

Hi @Anonymous,

However, I have tested on my side with the above Flow you created, it works well. I'm not sure if it's an Excel file issue, but could you please try creating a new Excel file and test it?

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.