cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
btabbert
New Member

Flow Condition Not Applying

Hi friends,

 

Having an issue with a flow not applying the condition correctly. Could use some help, thanks. I'm not sure if my logic is bad or if I'm incorrectly using the condition.

 

  • Flow Intent: Notify reviewers of policy documents whose "Next Revision" date (metadata column in library) is coming up in 60 days or less. Send 1 email per document needing review.
  • Current Result: Every single file in the library is generating a Yes and sending 5 review notification emails.

 

Flow (Get Properties):

btabbert_0-1635263982835.png

 

Flow (Get Metadata):

btabbert_1-1635264042526.png

 

Flow (Apply to Each, Compose):

btabbert_2-1635264177505.png

 

Flow (Apply to Each, Condition):

btabbert_0-1635267439318.png

 

Flow (Apply to Each, Condition, Yes, Convert Time Zone and Email):

btabbert_6-1635264387393.png

 

Library Screenshot:

btabbert_0-1635267586848.png

 

 

Thanks so much for the help!

1 ACCEPTED SOLUTION

Accepted Solutions
btabbert
New Member

Solved my own issue; posting here in case others are looking for similar answers.

 

I went simple and didn't use ticks or an addDays. I used a "Get Future Time" and condition comparing my library's column for "Next Revision Date" to that future time. It now works exactly as intended—only documents with due dates within 60 days of today get flagged and only 1 email is generated per document.

 

btabbert_0-1635277408208.png

btabbert_1-1635277431142.png

 

View solution in original post

2 REPLIES 2
btabbert
New Member

Solved my own issue; posting here in case others are looking for similar answers.

 

I went simple and didn't use ticks or an addDays. I used a "Get Future Time" and condition comparing my library's column for "Next Revision Date" to that future time. It now works exactly as intended—only documents with due dates within 60 days of today get flagged and only 1 email is generated per document.

 

btabbert_0-1635277408208.png

btabbert_1-1635277431142.png

 

Thanks for your posting here and sharing the solution in the forum as it would be helpful to anyone who encounters similar issues.

Best Regards.

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,272)