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

Community site session details

Session Id : IWt56zVQlOyHmkrSeW9enk
Power Automate - Building Flows
Answered

Searching for existence of a string

Like (0) ShareShare
ReportReport
Posted on 20 Sep 2022 21:44:20 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?

  • Courty Profile Picture
    32 on 21 Sep 2022 at 03:56:31
    Re: Searching for existence of a string

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

  • ChristianAbata Profile Picture
    8,949 Most Valuable Professional on 20 Sep 2022 at 23:49:23
    Re: Searching for existence of a string

    you are welcome @Courty ... !!

  • Courty Profile Picture
    32 on 20 Sep 2022 at 23:46:06
    Re: Searching for existence of a string

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

  • Verified answer
    ChristianAbata Profile Picture
    8,949 Most Valuable Professional on 20 Sep 2022 at 23:35:45
    Re: Searching for existence of a string

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

    contains(string(outputs('Compose')),'Raise CRM')

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

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2