Answered

Flow to send email to specific email address stored in a item column after certain days.

(0) Share

Report

Posted on by lohaninarayan

Hi All,

I need to build a flow to send am email to the email address stored in one of the item column after 90 days of item creation if no one reviewed it. I am new in this field and I am struggling a lot to implement it. It will be a great help if someone can help me.

Basically, I will have 3 column for each item in SharePoint list. 'CreationDate', 'Status', and 'EmailAddress'. First column stores the date of item creation, Status column will have two status (Open and Reviewed) and the last column have email address of the person to review.

I need a flow which runs everyday and check every item first and if status is open it again check whether the item age has crossed 90 days since creation or not and if if the age is 90 or more it send an email notification to the email address as reminder to review it.

I searched a lot and try to join few different solutions for similar scenarios but I am not being able get it right.

Thanks in advance!

Categories:

Business Process Flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-yujincui-msft on at

Like (0)

Report
Re: Flow to send email to specific email address stored in a item column after certain days.

Hi @lohaninarayan ,

Do you want to find records with a creation date greater than 90 days and a value of "Open" in the status column and send an email to the corresponding email address?

I have made a test for your reference.
1. Here is my SharePoint list.
2. Here is my Flow.
addDays(item()?['Created'],90)
utcNow()

Best Regards,
Charlie Choi

Was this reply helpful? Yes No
lohaninarayan on at

Like (0)

Report

Re: Flow to send email to specific email address stored in a item column after certain days.

Hi Charlie,
Thanks for taking time to look for the solution. I will try this and comment back with my experience.
Thanks
Narayan

Was this reply helpful? Yes No
v-yujincui-msft on at

Like (0)

Report

Re: Flow to send email to specific email address stored in a item column after certain days.

Hi @lohaninarayan ,

Is your problem solved? Is my answer helpful to you?

Best Regards,
Charlie Choi

Was this reply helpful? Yes No