Unanswered

Date column will not trigger as condition in flow

Like (0) Share

Report

Posted on 14 Jul 2022 21:43:26 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?

All responses (3)

Answers (0)

Blurryface 149 on 20 Jul 2022 at 23:54:59

Like (0)

Report

Re: Date column will not trigger as condition in flow

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')
Charvat2 2 on 15 Jul 2022 at 13:51:04

Like (0)

Report

Re: Date column will not trigger as condition in flow

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.
MarconettiMarco 3,812 Super User 2024 Season 1 on 15 Jul 2022 at 08:19:39

Like (0)

Report

Re: Date column will not trigger as condition in flow

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