Unanswered

Not send email if the last email was sent less than 30 days

(0) Share

Report

Posted on by r0663664

Hi,

I am creating a flow to send customer survey daily but I want to ensure that customers is only survey once in 30 days. How should I construct this flow? I have a date that trigger the email and also a field called Email Sent where the date is captured. Thanks.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

lbendlin 8,474 Super User 2025 Season 2 on at

Like (0)

Report

Do you have a sharepoint list that captures your email sending events?

Was this reply helpful? Yes No
r0663664 28 on at

Like (0)

Report

I have a field to capture the date and time it was sent. Any advice?

Was this reply helpful? Yes No
emadrigal Microsoft Employee on at

Like (0)

Report

Hello @r0663664

You could do something similar to this, instead of using "NextReviewDate" in the input field, here you should use your Email Sent field.

formatDate() is less than or equal to addDays()

If yes --- dont survey
If no --- survey

Let me know if it this helps you!

Regards,

Community Support Team - Edgar Madrigal
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
r0663664 28 on at

Like (0)

Report

It involves looking at previous entry, like a vlookup so I am not sure your solution will work.

Was this reply helpful? Yes No
r0663664 28 on at

Like (0)

Report

Anyone has any idea?

Was this reply helpful? Yes No