Automatic Email Sending Based on 2 Factors

[Ryan59]

Hello, I have been trying this for hours and I just cant seem to figure it out. I have an excel spreadsheet that I will use for checking out and in tooling. I would like an email sent if a tool is in status check out after 2 days from the check out date. How is this done?

Tool Name	Borrower Email	Date	Check In/Out
Screw driver	Email	15/01/2023 10:06	Check out
Socket	Email 2	22/01/2023 10:30	Check out
DMM	Email 3	21/01/2023 12:06	Check in

[v-chengfen-msft · Accepted solution]

Hi @Ryan59 ,

Do you want to send emails to people who don't return tools after two days of loaning them out?

I made a template for your reference:

【Recurrence】Triggered every day, check the excel table

【Filter array 2】 Filter the records whose date is two days ago
On the basis of the above, [Filter array] filters the records marked as Check out

Check whether the length of the filtered record is greater than 0, if it is greater than 0, it means that someone has borrowed the tool for two days and has not returned it, then send an email to this person

Best Regards

Cheng Feng

[Ryan59]

@v-chengfen-msft Thank you so much for this! It seems like exactly what I was trying to do. I will build it out and see. Is it possible to easily add in a rule that omit this from running on weekends?

[Ryan59]

@v-chengfen-msft I built it out and ran into a couple issues. The first one is when i try to populate the send email command power automate automatically adds another 'apply to each' on its own. I tried it several times and it always adds another 'apply to each'.

The second issue I am having is that when this runs it always sends emails for every tool regardless of time and check out status. I updated to spreadsheet to reflect that only 1 tool is out longer than 2 days and i receive 5 emails.

Please help.

[v-chengfen-msft · Accepted solution]

Hi @Ryan59 ,

From your screenshot, you are using the value returned by [List rows present in a table], so you may automatically create an Apply to each to traverse to obtain the value.

We use [Filter array] to filter the results, and we need to get the value from the result of [Filter array], so we need to use the formula to get it dynamically.

Like this:

Best Regards

Cheng Feng

[Ryan59]

@v-chengfen-msft that was it! thank you :-). Works great now, but is it easy to add one more rule? is it possible to ignore running this on weekends?