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').
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
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.
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:
Join us for the first ever Power Platform Online Conference!
Look out for new contribution recognition badges coming SOON!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Watch & learn from the Power Automate Community Video Gallery!