cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ArtW
Level: Powered On

Execute Recurrence Flow using calculated Date.

Even Jon Levesque couldnt help.  I built a Recurrence Flow with a fixed date; when the current date matched the fixed column date it sends an email fine. I NEED to send FLOW when current date matches Calcuated date! In the examples below I have a Recurrence FLOW that works great when date is fixed. When I calculate the date the error messages show, basically stops short of sending email. THE ONLY CHANGE is changing the fixed date to calculated.

Using the Excel information below, set up a column with email addresses, a column for POP (Period of performance) and a column with 27 Month report.  The 27 month report is a calculated column; usin the formula "=[PoP Start]+820" the flow will not read the date or send email. My excel example gives you estimated POP dates to equal current date once formula is applied. 

HELP????

Functioning Flow.jpgerror.jpgUntitled.jpg

Spoiler
Spoiler
Spoiler
 
3 REPLIES 3
Community Support Team
Community Support Team

Re: Execute Recurrence Flow using calculated Date.

Hi @ArtW ,

 

Could you provide details of the configuration in the Compose action?

Could you share more details about the Calcuated date you mentioned?

 

Basically, if you want to use a field plus the specified number of days to compare against the current date, you could refer to the following method.

For example, compare Due Date plus two days to the current date.

Expression reference:

addDays(items('Apply_to_each')['DueDate'],2,'yyyy-MM-dd')

Image reference:

11.PNG

Also please make sure the Due Date is not empty.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ArtW
Level: Powered On

Re: Execute Recurrence Flow using calculated Date.

Hello,

Maybe I misunderstood the Flow you were trying to explain but it didnt work. 

Attached below are the columns in my SharePoint List and the way the 3 columns are setup in the list.

For over a month I am trying to get my flow to work. 

My SharePoint Page has a Pop Start (project start date) / Calculated date adding 820 days in the ITR Preparation / Send and Email to Manager when the ITR daye matches todays date.

 

Here are my SharePoint Columns. I calculated the dates for you to match the next 3 or 4 days.

SharePoint Columns.jpg

Here is the way each column is setup in the list!

3 columns.jpg

ArtW
Level: Powered On

Re: Execute Recurrence Flow using calculated Date.

I responded 2 weeks ago. is there anyone that can actualy understand the need and help with this flow.


@v-bacao-msft wrote:

Hi @ArtW ,

 

Could you provide details of the configuration in the Compose action?

Could you share more details about the Calcuated date you mentioned?

 

Basically, if you want to use a field plus the specified number of days to compare against the current date, you could refer to the following method.

For example, compare Due Date plus two days to the current date.

Expression reference:

addDays(items('Apply_to_each')['DueDate'],2,'yyyy-MM-dd')

Image reference:

11.PNG

Also please make sure the Due Date is not empty.

 

Best Regards,


 

Helpful resources

Announcements
firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors
Users online (5,429)