Unanswered

FLOW (Get Items) Filter SharePoint list on Expiration Date

(0) Share

Report

Posted on by fverdu

Hi,

I have a sharepoint list to track contract renewals. I want make a flow to send an email to group for notification or filtered items with a date value.

thanks

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

Sort by

v-yamao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @fverdu,

Do you want to send out a reminder email before the expiration date? Do you have a Date (date only) column in the SharePoint list?

Say you want to send a reminder email 3 days before the expiration date, you could use Filter query to filter the items. The code in the Filter query is:

Date eq formatDateTime(addDays(utcnow(),3),'yyyy-MM-dd')

Note: Date is of type date and time and is Date only formatted in the list, the function formateDateTime must be surrounded with a single quote.

In order to send the all the items at a time, use the action Create HTML table, then in the action Send an email, make sure enable Yes for the Is HTML field.

Please check the following screenshot for a reference.

More details about Odata filter query, please check the following doc:

https://docs.microsoft.com/en-us/previous-versions/dynamicsnav-2016/hh169248(v=nav.90)

More details on Workflow definition language, please check the following link:

https://docs.microsoft.com/en-us/azure/logic-apps/logic-apps-workflow-definition-language

Please feel free reply if you need more help.

Best regards,

Mabel Mao

Was this reply helpful? Yes No
fverdu 12 on at

Like (1)

Report
Copy link

Link copied!

ohh thanks.
It's possible to get a reminder email 15 days before expiration date of a list item? i don't need the html table with the resume, only the reminder to make de renewal of our customers before expiration.
thanks.

Was this reply helpful? Yes No
fverdu 12 on at

Like (1)

Report
Copy link

Link copied!

Hi Mabel,
the flow fails at the apply filter step. Please can give me some email to send you some captures with my configuration?
Thanks in advance

Was this reply helpful? Yes No
fverdu 12 on at

Like (1)

Report
Copy link

Link copied!

Hi Mabel
please see the captures of our config and error, the flow is completed with your instructions and fails in the filter step:

https://zerkana-my.sharepoint.com/:f:/p/fverdu/ErjhZpNhTKhPprtVr5v7bsIBnAx6KgbcUEHiMV_nHJlerg?e=1wb0Is

Escenario:
I have a sharepoint list with a Date and Time column named "RenewalDate". The column's config is "Only Date". This is to track the renewal contracts of our customers.

Needs:
I need a flow that alert me by mail 30 days before contract expiry. If the mail attach a resume of contract that need renewal, it will be nice too.

Thanks in advance.

Was this reply helpful? Yes No
Fernanda 380 on at

Like (0)

Report
Copy link

Link copied!

@v-yamao-msft
Hi, question.. what if i want to set the notification for all the already expired items? What number should I state in the formula? Or is it a complete different one?

Was this reply helpful? Yes No