Expiry Notification

[Anonymous]

Hi,

I want to use flow to send email notification to users notifying that contract is going to expire before say 30 days of contarct expiry date.

There is Expiry date column in the list.

Is there any way to implement this?

Thanks

Anand

[v-xida-msft]

Hi @Anonymous,

Do you create your contract in a SharePoint list?

Could you please share a bit more about your SharePoint list?

Further, do you want to send a notificaiton to users before 30 days of contract expiry date?

I assume that you create the contract in your SharePoint list, I have created a Contract list on my SharePoint and the data structure of it as below:

Note: ContractName column is a Single line of text type column, Owner column is a Person or group type column and Expiry date column is a Date and Time type column.

I have made a test on my side and please take a try with the following workaround:

• Add a proper trigger, here I use Flow Button trigger.
• Add a "Get items" action, specify Site Address and List Name.
• Add a "Apply to each" aciton, input parameter set to output of the "Get items" action.
• Within "Apply to each", add a Condition, click "Edit in advanced mode", type the following formula:

@equals(utcNow('MM/dd/yyyy'), formatDateTime(addDays(items('Apply_to_each')?['Expiry_x0020_date'], -30), 'MM/dd/yyyy'))

Within "If/yes" branch of Condition, add a "Send an email" aciton.

Image reference:

The flow works successfully as below:

Best regards,

Kris

[Anonymous]

Hi Kris,

Thanks for the solution. I will check it in my environment and will let you know more about the results.

Thanks

Anand

[anhthuch4ng]

Hi @Anonymous,

Thanks for posting to the Flow Forums!

Have you had a chance to apply @v-xida-msft's recommendations to adapt your Flow?

If yes and you found that solution to be satisfactory, please go ahead and mark @v-xida-msft's response as the "Accepted Solution". 🙂

Happy Flowing,

-AT (Community Admin)

[v-xida-msft]

Hi @Anonymous,

Do you need any help?

Best regards,

Kris

[Anonymous]

Hi there,

I am trying out this as a solution as well but I am running into the following error and was wondering if you could advise me as to where I am going wrong?

I am using a library instead of a list for the contracts so not sure if this changes anything with the expression used.

Below the error and screenshots of my flow:

InvalidTemplate. Unable to process template language expressions for action 'Condition' at line '1' and column '2512': 'The template language function 'addDays' expects its first parameter to be a string that contains the time. The provided value is of type 'Null'. Please see https://aka.ms/logicexpressions#adddays for usage details.'.

Thanks,

Angela