cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Yattering82
New Member

FLOW TO SEND EMAIL WHEN DATE APPROACHES

Hi there

 

This is the first time posting in the forum but a long time user of the forum. What I am trying to do, is to get a flow to trigger an sending an email when the date of a required audit approaches. The audit due dates are listed in a SharePoint list and you would think that this would be a simple thing to do. However, no matter how much I tinker and how much I see what others have done, I cannot get this to work.

 

This is what I have done:

 

@equals(item()?['Nextauditdue'], adddays(utcnow(),'mm-dd-yyyy')+14)

 

So basically I want this to send me an email when it is 14 days to the audit due date. 

 

If anyone can shed light on this, I would be most grateful.

112 REPLIES 112

ok, I will try that solution. thank you

I can not see the formula used in the Apply to each step

@SmokeEater1996 , the apply to each step has been modernized since this thread was created. 

 

What are you trying to accomplish? Which part are you stuck at? 

 

To replicate something similar to the original post, I have in my apply to each step the following:

 

formatDateTime(item()?['Due_x0020_Next'], 'MM/dd/yyyy')

is equal to

formatDateTime(addDays(utcNow(), 30), 'MM/dd/yyyy')

 

The above is checking my "Due Next" column, which is filled with dates, are 30 days away from today's date.

I'm trying to do something very similar to what you have here, I will try that formula thanks.

SmokeEater1996_0-1594147585248.png

This is what I have and it does not work. @kristof805 

@SmokeEater1996 I think you got several things happening here that I can already see:

 

  • You are using the formula under the Filter Query section of Get Items instead of Apply to each step. This may change things.
  • Your formula is missing the number of days, which can be put as 0 if you want to check for the same today's date. Check the exact formula code on my previous codes. You cannot omit parts, as far as I know.
  • Your column name is most likely wrong. Please look at your output under Get Items step after your flow ran. It'll show you the correct formatting of the column name. For example, I have a column called "Due Next" but I have to type it in as "Due_x0020_Next" when using it in different Flows.
  • You'll also need quotes around your formateDateTime formula in your Filter Query.

What errors are you getting, if any?

 

 

Jacobpetley57
New Member

So I'm not to sure this will help out or not,I have 0 experience with microsoft or coding/programming...

I've managed to upgrade my Android platform from 9 to 12+without documentation work adding microsoft. Downloaded flow today and learning about flow and buttons/push notifications and decided to share it with Edge and it said solved in green highlight to your link. So there you have it. Maybe you could return the favor...

maggd78
Regular Visitor

Hi all,

I am new here on the forum, thanks for all your posts, really enriching.

I discover PowerAutomate, and my english level isn't good at all, sorry 😉

I read all contents of the post but i didn't find THE key to solve my problem...

 

I'm trying to create an

- automatic flow, launched every day

- for all documents in a doclib

- which have a date "CreateTask" (calculated column in SharePoint) equals Today

- in order to create a task in Planner. 

 

Here's what i've done but it doesn't work.

 

2021-11-11_22h27_48.png

2021-11-11_22h29_27.png

 

I tested in the condition

 - Left : formatDateTime(item()['DateCreationTache'],'yyyy-MM-dd')

 - Right : formatDateTime(utcNow(),'yyyy-MM-dd')

 

but in results, false appears for all of them 😭

2021-11-11_23h32_59.png

In advanced thanks for your help,

Regards

 

After your Flow has ran, you should be able to look at the details, so where it says false, there should be outputs of what was compared to what. Your formatting may be right but it may be that the utcNow() is returning the wrong day (depending on where you are located) so you may have to do a time conversion.

You can see from my previous posts that the code that ended up working for me was:
@equals(formatDateTime(item()?['Insurance_x0020_Expiry_x0020_Dat'], 'MM/dd/yyyy'), formatDateTime(addDays(utcNow(), 30), 'MM/dd/yyyy'))

 

This compares date column Insurance Expiry Date to see if that date is 30 days from now. Hope that helps or write back and we can troubleshoot more.

maggd78
Regular Visitor

Thanks a lot @kristof805 for your answer, it's work 😍!!! 

Have a nice day!!

LoneWolfe47
Frequent Visitor

@kristof805 
Hello,

I'm trying to create a flow that does something similar to this except my data is in the data verse, and not in SharePoint. 
Is there anyway you may have a method of doing basically the same thing but with the data verse?

Hey @LoneWolfe47 ,

 

I haven't created a flow with Microsoft's Dataverse actions but there should be a similar action to "Get Items" from a SharePoint list. Check out this article for functionality:
https://docs.microsoft.com/en-us/power-automate/dataverse/overview

 

After that, you should be able to copy my flow / logic after replacing my column name with a Dataverse column name. The syntax may be slightly different but you should be able to get an example from the output of your flow.

@kristof805 Thank you for getting back to me. I actually already figured it out before i found this reply, but i thank you so much for looking into it for me.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (4,827)