Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Unanswered

Condition not working

(0) ShareShare
ReportReport
Posted on by 4

flow 2.PNGflow1.jpgDear all,

 

I am attempting to build a workflow based on a SP list that sends an email to the project manager 30 days before the contract of one of his staff expires. I am able to achieve that with the flow below.

Now, I have a "contract type" column in the list, which is a look up column from another list. I would like to send the reminder email for all the categories except for Hourly Contract and MEDICAL ESCORT, so if a contract is set as "hourly contract", nothing happens 30 days before its expiration.

Could you please let me know what am I doing wrong?

thanks 🙂

 

Contract type.PNG

 

  • DiegoTrec Profile Picture
    4 on at
    Re: Condition not working

    dear all, 

     

    any clue regarding the error I am facing?

    thank you!

  • DiegoTrec Profile Picture
    4 on at
    Re: Condition not working

    thanks for your answer @yashag2255 !

    I modified the flow as suggested and added three entries in the SP list (expiring in 30 days as of today), but this way the flow fails, see pictures below

    2.PNGPAfails.PNG

  • yashag2255 Profile Picture
    24,442 Super User 2024 Season 1 on at
    Re: Condition not working

    Hi @DiegoTrec 

     

    Can you check and confirm on what you have selected in the condition on the left side? It should be Contract Type Value from the dynamic selector. 

     

    Hope this Helps!

    If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,651 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,997 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow