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

Re: FLOW TO SEND EMAIL WHEN DATE APPROACHES

ok, I will try that solution. thank you

Highlighted
New Member

Re: FLOW TO SEND EMAIL WHEN DATE APPROACHES

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

Highlighted
Helper IV
Helper IV

okeRe: FLOW TO SEND EMAIL WHEN DATE APPROACHES

@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.

Highlighted
New Member

Re: okeRe: FLOW TO SEND EMAIL WHEN DATE APPROACHES

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

Highlighted
New Member

Re: FLOW TO SEND EMAIL WHEN DATE APPROACHES

SmokeEater1996_0-1594147585248.png

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

Highlighted
Helper IV
Helper IV

Re: FLOW TO SEND EMAIL WHEN DATE APPROACHES

@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?

 

 

Helpful resources

Announcements
firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

Join the new Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (12,948)