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

Add days to expression, from date in Sharepoint List

Hi there,

 

I'm trying to state a date in an email, taken from a Sharepoint List. I have no problem 'getting' this date, but I want it to be displayed as one day ahead of the date in the list i.e. if date taken from List is "05/10/2020", I want the email to read "Hi, the cut off date for this invoice is 06/10/2020

 

This is the formula I have so far, but it's failing the Flow Test. I'm hoping it's just a simple problem with my syntax? I also want the date to be displayed as 'dd/MM/yyyy', and I'm not sure where to fit that into the expression either.

 

jbuta_0-1601903266320.png

 

Any help much appreciated!

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User II
Super User II

@jbuta 

 

You are using format Date but did not provided date format which is required parameter in formatDateTime().

but if you are using addDays() no need of formatDateTime. Use in this way-

addDays(Date,1,'dd/MM/yyyy')

 

Thanks

Hardesh

View solution in original post

2 REPLIES 2
Super User II
Super User II

@jbuta 

 

You are using format Date but did not provided date format which is required parameter in formatDateTime().

but if you are using addDays() no need of formatDateTime. Use in this way-

addDays(Date,1,'dd/MM/yyyy')

 

Thanks

Hardesh

View solution in original post

That's perfect. Thank you very much indeed

 

Helpful resources

Announcements
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

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!

Users online (43,553)