Hi all,
I'm relatively new to Power Automate, so unsure if I'm using the correct terminology. I'll try to describe my issue as best I can.
I'm building a flow that assesses iAuditor inspections and sends an email notification if a particular condition is met. The condition is whether a string exists in the underlying iAuditor data or not (the possibilities are that it doesn't exist, or exists in one or more instances). I've tried a number of different methods to query its existence, but due to my inexperience I'm feeling around in the dark, and I have not been able to get it to work at this point, even though it seems it should be a relatively simple operation.
I've used Compose to hold the data from iAuditor, and I can see from the Raw Output that it contains the string I'm looking for:
The next step (which seems to be where I'm failing) is querying whether the string exists, and simply returning true or false. The most obvious solution I've tried is as follows (although I've tried many other variations), but it only ever returns 'false'.
I feel as though I've either used the Condition incorrectly, or I'm missing a step. Can someone point me in the right direction?
@ChristianAbata it turns out my idea was flawed... after some more testing I have found that the string exists in all instances. So the obvious solution (to me) would be to change the Compose expression to count (?) the occurrences of the nominated string, so that the condition would be true where the Compose Output is greater than 1. Is that a simple change?
Brilliant! A thousand thanks @ChristianAbata , that worked perfectly!
hi @Courty Could you try this:
Add in another compose action the next expresion:
Michael E. Gernaey
497
Super User 2025 Season 2
David_MA
436
Super User 2025 Season 2
Riyaz_riz11
244
Super User 2025 Season 2