How to stop sending sending reminders when a reply is received?

(0) Share

Report

Posted on by yashm

Hey all,

So I have been trying to create a flow which should achieve the following:

1. Get list of email addresses maintained in a SP list.

2. Send daily reminders to those email addresses for sending a work document

3. Once an email (reply) is received from them, stop sending reminders to those email addresses.

The first part - sending reminders to a list of emails can be achieved. Though I am having trouble in setting a condition for the flow to stop sending reminders once a reply with attachment is received from the said email address.

I tried using 'when a new email arrives' but you can't use that within a flow or as an additional trigger. Any ideas on how can I achieve the above?

Thanks!

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

VIDIT 666 on at

Like (0)

Report
Copy link

Link copied!

hi @yashm may be you can put a Yes or no Flag in your list and when the document is received put the flag as yes
so now the flow will send reminders to only those emails with flags set to No

Was this reply helpful? Yes No
yashm 92 on at

Like (0)

Report
Copy link

Link copied!

Hey Vidit, yes I was trying something around those lines. I've a Status column which is of choice type - Pending and Recieved.

How will you update it to Received automatically when a new email arrives with an attachment?

I mean the even if I create a seperate flow which has these steps of updating SharePoint item when a new email arrives, there is no direct link between the exact row which I want to update and the sender of the email.

I hope I'm not confusing you 😅. Please let me know if I should explain it some other way.

Was this reply helpful? Yes No
Verified answer

yashm 92 on at

Like (0)

Report
Copy link

Link copied!

Hey @ViditGholam and all,
So I figured it out after a bit of exploration of templates on the Flow website 😅

So whenever a new email arrives with an attachment, I used filter query to check whether sender's email address is equal to the email in the SP list. If yes, update the item to Received.
I have another separate flow, which has a condition to stop sending reminders if the status of the item in the list is Received.

Here's the flow for updating to Received:

Result:
P.S. - I think you can skip the Initialize Variable part. The dynamic content 'From' works as well for the filter query.

Was this reply helpful? Yes No
VIDIT 666 on at

Like (0)

Report
Copy link

Link copied!

Hi @yashm Glad to hear your issue got resolved

Thanks and regards
Vidit

Was this reply helpful? Yes No