cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
darrenfloyd666
Post Prodigy
Post Prodigy

Date triggered Flow Condition not working

Hi Automaters

 

I'm trying to get a Flow to fire off an email alert when a date field on a list is coming up to 15 days.

 

I got it working in a test environment but not in production.

 

Here's how I've got the condition written:

Condition.png

 

The first line is Date (the date field) is equal to utcNow()

 

In the list field the date is formatted DD/MM/YYYY however when I get the output from the Flow of the date field it's coming out as YYYY/MM/DD.

 

All suggestions welcome

1 ACCEPTED SOLUTION

Accepted Solutions
RobElliott
Super User
Super User

Hi Darren @darrenfloyd666 the way I do these reviews is shown in the screenshots below. Particularly if it's a document review I'd add in a link to the item in the email as well. If anything isn't clear just shout.

0-trigger-getItems-compose.png

 

1-compose-condition.png

 

2-greenChannel.png

 

3-emailResult.png

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

View solution in original post

4 REPLIES 4
RobElliott
Super User
Super User

Hi Darren @darrenfloyd666 the way I do these reviews is shown in the screenshots below. Particularly if it's a document review I'd add in a link to the item in the email as well. If anything isn't clear just shout.

0-trigger-getItems-compose.png

 

1-compose-condition.png

 

2-greenChannel.png

 

3-emailResult.png

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

darrenfloyd666
Post Prodigy
Post Prodigy

Thanks @RobElliott again! I followed your actions and it's running but not spitting out an email.

 

I've got four items with dates:

 

7/02/2020

10/02/2020

22/02/2020

29/02/2020

 

and I thought one of them would trigger an email.

 

The Outputs I'm getting on the JSON actions are:

Compose Day: 2020-02-07

Compose Expiry Date: 2018-06-14

Compose ReviewDate: 2018-06-07T00:00:00.0000000

Compose 2018-06-07

 

Where am I going wrong?

 

Hi Darren, your review dates don''t match today as far as I can see so the flow will go down the red if no channel of the condition and the email won't be sent. If you've got old items in the list that you still want to get reviewed then you could change the condition to greater than or equal to.

Rob
Los Gallardos

BOOM! That worked when I changed the condition to 'Less than or equal to' thanks @RobElliott !

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

New Process Advisor Capabilities carousel.png

Read the blog for the latest news

Read the latest about new experiences and capabilities in the Power Automate product blog.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

Users online (2,153)