Re-RUN failed Power automate flow

[SAGOS_12]

Hello all,

I have flow - which gives me this  error, which i understand that there is no particular value in the column of the item.

Now that i added column value to the dataverse item and want to re-run the flow. When i clicked on re-submit it didn't worked. The trigger is item created/modified and only triggers if status changed. Now that i cannot change status but want to trigger this flow which does bunch of activities like updates diff tables and send emails. How to re run the flow?

[DJ_Jamba]

Hi @SAGOS_12 

Is the action Get_a_row_by_ID_2 getting recordId from the trigger?
If so, you cannot re-run a flow and expect it to get new trigger values. It will always use the original trigger values on a resubmit. 

[SAGOS_12]

Thank you for responding. How could i run the flow with new trigger values in this case? or how can we better design flows to handle such fail scenarios when business expects emails on the status changes? if flow fails, i correct data at backend and re- run the flow so it would continue the process. how can we do that?

[DJ_Jamba]

You could have 2 flows.
The first flow would be triggered in the same way your current flow is, except it would write the values received from the trigger to a separate temporary table.
Then the flow you have now would become the 2nd flow and would be triggered when an item is created in the temporary table.
If the 2nd flow encountered an error like the one you received, al you would have to do is create a new row in the temporary table with the correct data.