Trigger email based on List date column

(0) Share

Report

Posted on by sestillings

Hey Power Automate community!

I'm struggling to get Flow working with my SharePoint List. Here's what I'd like to happen:

A new list item is added and a calculated column ("Send Survey") is populated 2 weeks after the added date (this works fine)
An email is sent to each item on the "Send Survey" column date. (A couple iterations of my Flow worked but would resend the email to past items which I don't want)

I've tried setting this up a couple different ways but nothing works exactly right. I'm willing to start a whole new build if it makes sense. Here's where my build is right now:

I think the problem I'm facing in this approach is around the utcNow expression I'm using (admittedly I'm new to this expression) as the Flow consistently recognizes the condition of "Send Survey" is equal to utcNow as FALSE. My SharePoint List calculated column using the MM/DD/YYYY format however it does not input a 0 in front of a single digit date (i.e., July = 7, not 07).

Thank you for any suggestions on how to get this working!

I have the same question (0)

All responses (7)

Answers (0)

MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (0)

Report

Re: Trigger email based on List date column

Hello @sestillings,
in the “Condition” control both dates must have the same date format.
So, I suggest tu use this expression for both dates:
formatDateTime(‘your_value’, ‘MM/dd/yyyy’)

Just to be sure your getting the Sending Survey date correctly, please add a “Compose” action before the condition and put the value inside. Then, run the flow and check in the “Compose” outputs which value you’ve got.

Let me know

BR,
Marco

Was this reply helpful? Yes No
sestillings 26 on at

Like (0)

Report

Re: Trigger email based on List date column

Thank you for the response, @MarconettiMarco!

I'm not sure I totally understand what the 'your_value' should reference? Here's the changes I've made so far:

Was this reply helpful? Yes No
MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (0)

Report

Re: Trigger email based on List date column

Hello @sestillings ,
'your_value' has to correspond to your dynamic content, like "Send Survey".

BR,
Marco

Was this reply helpful? Yes No
sestillings 26 on at

Like (0)

Report

Re: Trigger email based on List date column

Ok, that's what I thought but since I'm not able to actually add the dynamic content to the expression I wasn't sure if I was understanding correctly. I'll try it like this!

Was this reply helpful? Yes No
MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (0)

Report

Re: Trigger email based on List date column

Hello @sestillings ,
please start typing the expression in the expression bar and, when you have to add the Dynamic content, switch to the dynamic content bar and select your value.

BR,
Marco

Was this reply helpful? Yes No
sestillings 26 on at

Like (0)

Report

Re: Trigger email based on List date column

I did but I'm not seeing the Send Survey value as an option I can add:

Was this reply helpful? Yes No
v-yujincui-msft on at

Like (0)

Report
Re: Trigger email based on List date column

Hi @sestillings ,

Sometimes, we can get field value through expression even if there is no corresponding dynamic content displayed in the Dynamic content tab.

formatDateTime(items('Apply_to_each')?['SendSurvey'],'MM/dd/yyyy')
formatDateTime(items('Apply_to_each')?['internalcolumnname'],'MM/dd/yyyy')
formatDateTime(utcNow(),'MM/dd/yyyy')

Result Screenshot:

Best Regards,
Charlie Choi

Was this reply helpful? Yes No