cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Microsoft
Microsoft

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
Microsoft
Microsoft

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
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 (60,334)