Trying to trigger an email when start date equals today

[hcomenetz]

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

[tom_riha]

Hello @hcomenetz ,

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

[v-LilyW-msft]

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:

Result

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

Hope the content above may help you.

Best Regards

[hcomenetz]

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. 

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. 

[v-LilyW-msft · Accepted solution]

Hi @hcomenetz 

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

Expression:

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

Result:

Best Regards.

[hcomenetz]

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