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

Ms Flow - Get Reminders on calculated date field

Hi, 

 

Is there any possible way to get reminders on calculated date field? I read many posts that says it is not possible as of now. 

I have an Date field, Number field and a calculated column as RevokeDate which is (Date+Number).

 

Even if I use getitems action, it is not possible to filter on - revokedate eq today!!

 

Is there any workaround for this?

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
v-duann-msft
Community Support
Community Support

Hi @PriyaFernandes 

 

Thanks for your posting.

 

According to your requirement, you would like to use calculated field as condition to send reminder. The most annoying part is the time format. Thus, we can use ‘formatDateTime’ function to format calculated field data.

 

This is my simple spo list :

v-duann-msft_0-1611129247282.png

 

 

I configured filter flow using condition action as below:

 

Related fx(Bold part is my dynamic content, please kindly replace accordingly):

  • formatDateTime(items('Apply_to_each')?['Calculated'],'yyyy-MM-dd')
  • formatDateTime(utcNow(),'yyyy-MM-dd')

 

v-duann-msft_1-1611129247289.png

 

 

Once test, I received two emails as I have two records in SPO list:

v-duann-msft_2-1611129247292.png

 

 

For more information, please refer below link for reference:

https://powerusers.microsoft.com/t5/Building-Flows/Flow-reminder-from-a-SharePoint-List-Calculated-F...

Reference guide for functions in expressions - Azure Logic Apps | Microsoft Docs

 

Hope the content may help you.

 

Thanks.

Anna

View solution in original post

1 REPLY 1
v-duann-msft
Community Support
Community Support

Hi @PriyaFernandes 

 

Thanks for your posting.

 

According to your requirement, you would like to use calculated field as condition to send reminder. The most annoying part is the time format. Thus, we can use ‘formatDateTime’ function to format calculated field data.

 

This is my simple spo list :

v-duann-msft_0-1611129247282.png

 

 

I configured filter flow using condition action as below:

 

Related fx(Bold part is my dynamic content, please kindly replace accordingly):

  • formatDateTime(items('Apply_to_each')?['Calculated'],'yyyy-MM-dd')
  • formatDateTime(utcNow(),'yyyy-MM-dd')

 

v-duann-msft_1-1611129247289.png

 

 

Once test, I received two emails as I have two records in SPO list:

v-duann-msft_2-1611129247292.png

 

 

For more information, please refer below link for reference:

https://powerusers.microsoft.com/t5/Building-Flows/Flow-reminder-from-a-SharePoint-List-Calculated-F...

Reference guide for functions in expressions - Azure Logic Apps | Microsoft Docs

 

Hope the content may help you.

 

Thanks.

Anna

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (1,388)