cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
hcomenetz
Frequent Visitor

Trying to trigger an email when start date equals today

Hi, 

 

I am trying to create a simple flow that sends a reminder email based on a task start date. However, I only want this on certain tasks so I've used the pink label to indicate the ones I want. The flow works when I test it but doesn't send an email. I'm hoping someone can help me find the issue.  I've pasted the flow below. This is the expression I've used for the value Start Date equals - 

formatDateTime(utcNow(),'MM/dd/yyyy')

 

hcomenetz_0-1638372729900.png

 

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @hcomenetz 

You can try to add Compose 2, then format the outputs of Compose.

Expression:

formatDateTime(outputs('Compose'),'MM/dd/yyyy')

vLilyWmsft_2-1638752998895.png

Result:

vLilyWmsft_3-1638753098302.png

Best Regards.

 

 

 

View solution in original post

5 REPLIES 5
tom_riha
Super User
Super User

Hello @hcomenetz ,

try to use the standard ISO date format: 'yyyy-MM-dd' in the conditions.



[ If I have answered your question, please Accept the post as a solution. ]
[ If you like my response, please give it a Thumbs Up. ]

[ I also blog about Power Automate solutions even for non-IT people. ]
v-LilyW-msft
Community Support
Community Support

Hi @hcomenetz 

Please check the format of ‘value Start Date Time’, if the format is not ‘MM/dd/yyyy’, please also format it as ‘MM/dd/yyyy’, the date formats on both sides of the Condition need to be the same.

You can add a compose action before this Condition and fill this field with 'value Start Date' to check its format.

I test on my side and found that the output of start Date Time is like this:

vLilyWmsft_0-1638503381212.png

Result

vLilyWmsft_1-1638503428039.png

So format it and test again, the result of Condition is true.

vLilyWmsft_2-1638503773055.png

vLilyWmsft_3-1638503822304.png

Hope the content above may help you.

Best Regards

hcomenetz
Frequent Visitor

Hi all, thank you for your help on this. I think I'm closing in on a solution and it looks like the format of the date field is the issue.

 

Here is the Compose I added. 

 

hcomenetz_0-1638538920514.png

 

 

That said, I'm not sure how to change the format of the field. I think I can change the format with a function in the Compose statement. If that doesn't work, I'll use the long format (yyyy-MM-ddThh:mm:ssZ). If you have any other recommendations, I'd appreciate it. I've been spending far to much time on this. 

Hi @hcomenetz 

You can try to add Compose 2, then format the outputs of Compose.

Expression:

formatDateTime(outputs('Compose'),'MM/dd/yyyy')

vLilyWmsft_2-1638752998895.png

Result:

vLilyWmsft_3-1638753098302.png

Best Regards.

 

 

 

hcomenetz
Frequent Visitor

@v-LilyW-msft  Thank you! That worked. 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (1,761)