Power Platform Community Forum Thread Details

Hi Community,

Recently, I created several flows for multiple alerts on a contract due date in relation to timing. There are 4 calculated columns, which auto work out the dates for 3 months, 2 months, 1 month and 2 weeks warnings prior to contract expiry.

I was given the solution in this community, these alerts work and now I would like to enhance these

The emails that are received are generic, I want to specify which vendor is coming up for renewal and cannot figure out how to select the vendor name as a condition to the alert.

Please kindly advise, please find the advice I received and the steps I followed:

Advice given:

1. In SharePoint create calculated columns for each Date check like-3months, 1 month, 2weeks etc.

2. Calculated column provide you exact date for notification.

3. Now Use Scheduled Flow and use condition- Calculated Column eq Today date then send email notification.

4. You can create multiple parallel condition in single flow to check for each calculated column date.

Steps I followed:

Create new Flow

Step 1 - recurrence - "1 min"

Step 2 - get items (sharepoint) - "Sharepoint site AND List" entered here

Step 3 - Condition "control" selected

Step 4 - output "value, sharepoint"

Step 5 - Condition is "contract date calculated columns" equals "today"

Step 6 - IF YES

Step 7 - send "email" to me for now in test environment

Where I indicate to the email receiver, which item it is referring to? Currently the alerts mention this is a 3 month warning for ABC contract to be renewed.

Thank you!!

Categories:

Building flows