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.

 

 

 

View solution in original post

hcomenetz
Frequent Visitor

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

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

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,312)