AddDays expression bringing back false results

[EloiseJane1]

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')

Date Column in SP

[abm · Accepted solution]

Hi @EloiseJane1 

Try this expression

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

[EloiseJane1]

Hi@abm

Thank you 🙂 it worked!