web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Searching for existenc...
Power Automate
Answered

Searching for existence of a string

(0) ShareShare
ReportReport
Posted on by 32

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:

2022-09-21_073318.jpg

 

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'. 

2022-09-21_073351.jpg

 

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?

Categories:
I have the same question (0)
  • Verified answer
    ChristianAbata Profile Picture
    8,953 Most Valuable Professional on at

    hi @Courty  Could you try this: 
    Add in another compose action the next expresion:

    contains(string(outputs('Compose')),'Raise CRM')
  • Courty Profile Picture
    32 on at

    Brilliant! A thousand thanks @ChristianAbata ,  that worked perfectly!

  • ChristianAbata Profile Picture
    8,953 Most Valuable Professional on at

    you are welcome @Courty ... !!

  • Courty Profile Picture
    32 on at

    @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?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 523

#2
Valantis Profile Picture

Valantis 318

#3
David_MA Profile Picture

David_MA 235 Super User 2026 Season 1

Last 30 days Overall leaderboard