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,
That works! thank you so much! 🙂
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.
Updated condition: length(outputs('revProjectIDLookupPAD_p')?['body']?['ResultSets']) = 0
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.
@SamLed that is what I am trying to do, but how? I don't get the text input box like the first image above.
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.