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

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 538 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 405 Moderator

#3
abm abm Profile Picture

abm abm 252 Most Valuable Professional

Last 30 days Overall leaderboard