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

Notifications

Announcements

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,951 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,951 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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 501 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 323 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard