Showing results for 
Search instead for 
Did you mean: 
New Member

Flow to send email 180 days (6 months) from a either a calculated SP list item or for Flow to adddays (180) to date entered on SP list



Stuck on generating a flow that will send out an email based on a SP calculted date.


The below works, but it uses a manual date within the SP list ('Review date manual'). If I change it to the calcluated list tem in SP ('Review Date') that adds 180 days from 'date added' it fails. So I need the flow to accept/recognise the calculated date or Flow to add 180 days to the 'date added' list item and then send the email (s).


The expression used is:  formatDateTime(utcNow(), 'yyyy-MM-dd') which sends out an email if list item equals today's date. Idealy dynamic content should use the calculated SP item ('Review Date').





Dual Super User II
Dual Super User II

Hi @blackandgold 


Microsoft flow will not intepret SP calculated columns since they are calulcated at run time


You would have to add the calculattion logic within flow

so if you need to add 180 days to a particular date field then use expression




Reza Dorrani


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Thanks. But where should this go. Does it need to be?


Action:Compose - 'date' field


Condition: adddays(datefield,180) 'is equal to' formatDateTime(utcNow(),'MM-dd')



Since review date has logic to have 180 days added to created date


on review date use expression




Thanks again, but I'm unable to add dynamic content within that bracket. 


I did try the following, that didn't work. 







Hi @blackandgold 


In the expression window,


type adddays( - then switch to dynamic content and pick the column

then switch baack to expression and coninue  with ,180)



I've looked on here and either you have an updated version of Flow (or license) or something is wrong as I can only select the following(see image below). Some responses suggest this feature is not available whereas others say it is (inserting a DC into an expression).


Whereupon I tried the following as I could not select the SP item I wanted: 

addDays (outputs('Get_items')?['DateAdded']),180)






addDays (item()?['DateAdded']),180)


@RezaDorrani wrote:




addDays (item()?['DateAdded']),180)

Thanks, however I get:


'The expression is invalid.' 


This should be simple to achieve - are there differences beteen free version (with license) and paid version? Otherwsie what am I missing...

Helpful resources

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.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

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.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Top Kudoed Authors
Users online (3,444)