How to make one flow check if another flow ran recently

(0) Share

Report

Posted on by flowrookie

I have built 3 flows as follows that send emails:

1.) Appointment Confirmation: This uses the trigger "When a new event is created"

2.) Appointment Reminder: This uses the trigger "When an upcoming event is starting soon" and looks ahead 1 day.

3.) Appointment Reminder: This uses the trigger "When an upcoming event is starting soon" and looks ahead 1 week.

The issue I am running into is that if an event is created 1 day before, all three flows run and send 3 emails at the same time. I don't want the appointment reminder flows to run if the appointment confirmation flow ran in the past 3 days.

Thanks for all the help!

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

v-yuazh-msft on at

Like (0)

Report

Re: How to make one flow check if another flow ran recently

Hi @flowrookie,

There is no any function in microsoft flow could create a flow check if another flow ran recently,so if you want the appointment reminder flows to run if the appointment confirmation flow ran in the past 3 days, there is no any way to achieve your needs.

An workaround is save the event created date in an item in sharepoint list, when the Confirmation flow runs, and in the Reminder flow you could add a Condition to compare the current date with the created date in the sharepoint list item, and if the appointment created date in the past 3 days of the current date, do nothing in the appointment reminder flows in the if yes branch of the Condition, if else that mean the appointment created date more than 3 days before the current date, send the email in the if no branch of the Condition.

Best regards,

Alice

Was this reply helpful? Yes No
flowrookie 12 on at

Like (0)

Report

Re: How to make one flow check if another flow ran recently

Hi @v-yuazh-msft,

Thank you for your response. I was able to successfully write to a list in sharepoint. So when the Appointment Confirmation Flow runs, it writes to this list.

What I need help with is for the Appointment Reminder flows to look at this list, match the Customer Name with the name from the event, verify if the Date Sent was within 3 days or if was more than 3 days ago, and send an email only if Date Sent was more than 3 days ago.
Can you show me an example of how to set that up?

Thank you for all your help!!

Was this reply helpful? Yes No
Verified answer

v-yuazh-msft on at

Like (0)

Report
Re: How to make one flow check if another flow ran recently

Hi @flowrookie,

Please take a try with screenshot below:

The expression in the Condition 2 as below:

@less(addDays(items('Apply_to_each')?['Date_x0020_Sent'], 3), utcNow())

Please make your Condition to check for the same name in sharepoint item and the event would work fine.

Best regards,

Alice

Was this reply helpful? Yes No