Stored Procedure - check if result set is empty

(0) Share

Report

Posted on by NewBee117

247

How do I get to this input box in the Condition control so I can put in the condition string?

Here is the screen I am stuck with,

Categories:

Process Advisor

I have the same question (0)

All responses (6)

Answers (1)

SamLed 2,334 Moderator on at

Like (0)

Report

Re: Stored Procedure - check if result set is empty

Well, I don't know what output your proc stock returns, but in the following action I would check if empty using empty() function expression passing it the output of previous action.
______________________________________________________________
If I have answered your question, please Accept the post as solution.
If you like my response, please Thumbs Up.

Was this reply helpful? Yes No
NewBee117 247 on at

Like (0)

Report

Re: Stored Procedure - check if result set is empty

@SamLed that is what I am trying to do, but how? I don't get the text input box like the first image above.

Was this reply helpful? Yes No
SamLed 2,334 Moderator on at

Like (0)

Report

Re: Stored Procedure - check if result set is empty

using a condition action, check this topic: Solved: Check if Get Items is Empty - Power Platform Community (microsoft.com)

But check length of your stored proc action output when returns empty result to fit condition to the right length.

[Edit] of course, replace outputs('Get_items') by your action output: outputs('revProjectIDLookupPAD_p')
______________________________________________________________
If I have answered your question, please Accept the post as solution.
If you like my response, please Thumbs Up.

Was this reply helpful? Yes No
NewBee117 247 on at

Like (0)

Report

Re: Stored Procedure - check if result set is empty

Updated condition: length(outputs('revProjectIDLookupPAD_p')?['body']?['ResultSets']) = 0
New error:

Was this reply helpful? Yes No
Verified answer

SamLed 2,334 Moderator on at

Like (0)

Report

Re: Stored Procedure - check if result set is empty

Ok, to fake your action output I used a compose, see how I check empty result for your case:

Use expression on left condition side: empty(outputs('revProjectIDLookupPAD_p')?['ResultSets'])

Result:

______________________________________________________________
If I have answered your question, please Accept the post as solution.
If you like my response, please Thumbs Up.

Was this reply helpful? Yes No
NewBee117 247 on at

Like (0)

Report

Re: Stored Procedure - check if result set is empty

That works! thank you so much! 🙂

Was this reply helpful? Yes No