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 Automate
Answered

Condition question

(0) ShareShare
ReportReport
Posted on by 25

I have an approval process that is triggered from adding a new item to a list. My goal is to not have the approval email go out if certain people (managers) are the ones adding the new item to the list themselves. After the trigger, the next step in the flow is to retrieve the manager's name from another list depending on what department is selected in the new item entry. This is to be used to retrieve their email information to use in the approval process email later on in the flow. Right after the get manager action, there is a variable initiated for this as there are many different departments and managers on the list. Next is the append variable to a string action. After that is where the problem occurs. I have a condition that looks at if the variable (Manager's email) is equal to or not equal to: I list my email. To test this, I have myself as the manager of a certain department but I'm also the one adding the new item to the list. The exact same flow worked once and did not send me an approval email because the condition returned 'false' (The manager's email is not equal to 'may email address') so I added another condition with a different manager's name and asked him to put in the ticket as well and he received the approval email anyway and when I add a new item it now always returns 'true' for what had worked and returned 'false' previously. What's going on with that? and does anyone have any suggestions on what I can do to fix this?

Categories:
I have the same question (0)
  • ScottShearer Profile Picture
    25,270 Most Valuable Professional on at

    @RUSLO 

    I would need to see the Flow to comment further, but string comparisons are case sensitive.  Check the run that did not work as you expected for that or simply convert both sides of the condition to upper or lower case and test again.

     

     

     

  • RUSLO Profile Picture
    25 on at

    RUSLO_1-1645638968416.pngRUSLO_0-1645638877123.png

    Hi Scott, I wrote the email just as it is displaying in the previous append action from another test. If I'm just typing this email, in my condition, does it need to have quotations? I finally got the condition to return a false (since I'm the manager and the one who added an item to the list) but as soon as I added the next manager, it just keeps returning 'true' even if it should be 'false'. 

    Is there a way for me to copy the entire flow?

    Louise

  • ScottShearer Profile Picture
    25,270 Most Valuable Professional on at

    @RUSLO 

    Can you post the same screen shot for a run that did not produce the results that you expected?

     

  • RUSLO Profile Picture
    25 on at

     

    See below,

    All I did was add the next manager in the condition and I've never been able to get it to return 'false' again on the condition. 

    RUSLO_5-1645645698496.png

     

     

    RUSLO_4-1645645575839.png

     

    RUSLO_2-1645645525642.png

     

    The one time it worked

    RUSLO_6-1645645851086.png

    The approval was never started and that's what we want.

     

    Hopefully these screenshots help!

    Louise

     

  • Verified answer
    ScottShearer Profile Picture
    25,270 Most Valuable Professional on at

    @RUSLO 

    I believe the OR in you condition is the issue.  One of the two will return true always.  Break it out into two conditions or change the OR to an AND.

     

     

     

  • RUSLO Profile Picture
    25 on at

    oh right! That's true! But that's going to get extremely long!

    If I was to list the names instead inside a trigger condition, (I tried this but wasn't successful) do I use an expression with the function 'contains' or 'not equals'. It basically would be the person's name that created the item on the list is not equal to: then I would list all of the manager's names.

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
David_MA Profile Picture

David_MA 223 Super User 2025 Season 2

#2
Expiscornovus Profile Picture

Expiscornovus 205 Most Valuable Professional

#3
harshdeol Profile Picture

harshdeol 167 Moderator

Last 30 days Overall leaderboard