Unanswered

Date column will not trigger as condition in flow

(0) Share

Report

Posted on by Charvat2

I have a dataverse table that I am trying to send an email based on 4 conditions from 4 different columns. I can get the flow to run successfully EXCEPT when I add in the date condition. I have it looking at a column titled TrainingDate and I have the condition set as 'is equal to' expression formatDateTime(utcNow(),'yyyy-MM-dd'). I have also tried

formatDateTime(items('Apply_to_each')?['cr596trainingdate'], 'd'). Any advice on how to get a flow to trigger from dataverse table date column?

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (0)

MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hello @Charvat2 ,
please share the flow in Edit mode and the error you're getting, so that it's much easier helping you.

BR,
Marco

Was this reply helpful? Yes No
Charvat2 2 on at

Like (0)

Report
Copy link

Link copied!

Here is how I have the flow built. I don't get an error, it says that it ran successfully but no email is sent so it is actually failing.

Was this reply helpful? Yes No
Blurryface 149 on at

Like (0)

Report
Copy link

Link copied!

Hi @Charvat2

You will need to update the
expressions to:
formatDateTime(utcNow(),'yyyy-MM-dd')
and then the other expression is:
formatDateTime(items('Apply_to_each')?['cr596trainingdate'],’yyyy-MM-dd')

Was this reply helpful? Yes No