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

 

Categories:
I have the same question (0)
  • yashag2255 Profile Picture
    24,769 Super User 2024 Season 1 on at

    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!

  • DiegoTrec Profile Picture
    4 on at

    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

  • DiegoTrec Profile Picture
    4 on at

    dear all, 

     

    any clue regarding the error I am facing?

    thank you!

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 245

#2
David_MA Profile Picture

David_MA 216 Super User 2026 Season 1

#3
Valantis Profile Picture

Valantis 212

Last 30 days Overall leaderboard