cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

AddDays expression bringing back false results

Hi

 

I am relatively new to Power Automate, but my objective was to run a scheduled flo to email me 1day before the target date built into an item list in SP, in a Date formatted column(MM/DD/YYYY)

 

It seems to declare the run successful, however I continually get false results, even though I know the due date is tomorrow.

 

Can anyone tell me why? or what I am doing incorrectly? - Screen shots below.

 

Expression I am using is: addDays(utcNow(),1,'MM/DD/YYYY')

 

Thanks You

 

 

Expression is addDays(utcNow(),1,'MM/DD/YYYY')Expression is addDays(utcNow(),1,'MM/DD/YYYY')

 

Date Column in SPDate Column in SP

1 ACCEPTED SOLUTION

Accepted Solutions
Super User III
Super User III

Hi @EloiseJane1 

 

Try this expression

 

addDays(utcNow(),1,'yyyy-MM-dd')


Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

Power Automate Video Tutorials

View solution in original post

2 REPLIES 2
Super User III
Super User III

Hi @EloiseJane1 

 

Try this expression

 

addDays(utcNow(),1,'yyyy-MM-dd')


Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

Power Automate Video Tutorials

View solution in original post

Hi@

 

Thank you 🙂 it worked!

 

 

Helpful resources

Announcements
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Users online (8,449)