How can deal if store procedure return empty instead of value in power automate because of that flow is failed

[Manojpatidar840]

How can deal if store procedure return empty instead of value in power automate because of that my flow is falling failed. 

[lbendlin]

How have you configured your "run after"  settings?

[Manojpatidar840]

Hi @lbendlin In the recurring flow scheduled to run daily at a fixed time, if the stored procedure returns a non-empty result set, the flow continues to execute normally. However, if the stored procedure returns a null value, the flow will failed. to avoid failed i want to make a condition in the flow that checks if the length of the stored procedure body result set is greater than zero. If true, continue with the subsequent actions; if false, terminate the flow.. I think this is what u r asking ???

[lbendlin]

not exactly.  In Power Automate you can choose to continue processing even if the previous step was not successful.

[Manojpatidar840]

@lbendlin Thank you for your reply, I checked with all the option, actually problem is what i want to check that if Store procedure passing null value then i want condition id not null then proceed for below flow if null then condition should be false and should be stop instead of failed. I am using this in the condition 

" length(body('Parse_JSON-HSE')) "

[lbendlin]

and should be stop instead of failed

You can use the "Terminate"  action and set it to signal a successful completion of the flow rather than a failure.

[Manojpatidar840]

Thank you @lbendlin 

Also ca n you tell me how can correct below condition if return value is null form store procedure then condition should be false else true , i am using " length(body('Parse_JSON-HSE')) " is it correct ?? as i am getting error.

[lbendlin · Accepted solution]

As the error states - you are trying to measure the length of the entire payload.  You would need to stringify the object first. Better to address the result array inside the body payload. There you can ask for the number of rows.

[Manojpatidar840]

perfect working thank you so much...