Share
Report
27Hi 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!!
All responses (
Answers (
