Answered

How to check metadata for record that triggered flow 2 days later but only on weekdays

(0) Share

Report

Posted on by virvil45

Hi All,

Here is my requirement. When a user adds or modifies a file, required columns need to be filled out. If they forget to fill out required columns, a reminder email should go out 2 days later (only on weekdays) reminding them that action is still needed on that particular file.

I have explored the Delay, Delay Until and Scheduled Flows for a flow that needs to be ran when a file is added or modified but needs to check if required columns are populated 2 days later (M-F only). None of the options I have mentioned allow me to schedule the delay for 2 days later but only on weekdays so that if a file is added to the library on Thursday or Friday, the flow will not check the required columns until Monday or Tuesdayt instead of Saturday or Sunday. Does anyone know how to do this? I wish Microsoft had the options of clicking the days we want the flow to check the record; similar to the delay options in Outlook.

Thanks!

Categories:

General topics

I have the same question (0)

All responses (8)

Answers (1)

Verified answer

v-jefferni Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @virvil45 ,

You can use a Delay until action for your requirement:

Expression:

addDays(utcNow(),if(equals(dayOfWeek(utcNow()),4),4,if(equals(dayOfWeek(utcNow()),5),3,2)))

Best regards,

Was this reply helpful? Yes No
virvil45 10 on at

Like (0)

Report
Copy link

Link copied!

Thank you for your help. The example of the Delay you've provided is exactly what I'm doing already. The problem is that the delay can end up falling on a weekend, which is what I'm trying to get away from. :))

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @virvil45 ,

What do you mean by it failed on a weekend? Could you please share a failed run history so I can help find what was wrong?

Best regards,

Was this reply helpful? Yes No
virvil45 10 on at

Like (0)

Report
Copy link

Link copied!

Hi,

I used 'falling' not 'failing'. :))

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @virvil45 ,

Sorry, my fault. But if using the expression in my example:

addDays(utcNow(),if(equals(dayOfWeek(utcNow()),4),4,if(equals(dayOfWeek(utcNow()),5),3,2)))

it means delay until Monday if today is Thursday or Friday, otherwise two days later than current time. I don't understand why it could still fall on a weekend. Could you please share this specific situation, when/on which day the flow was triggered and which day the delay until result?

Best regards,

Was this reply helpful? Yes No
virvil45 10 on at

Like (0)

Report
Copy link

Link copied!

Hello,

No problem at all. :)) Here is my flow to show the details. I have not attempted to use the expression you provided. Where would I put that?

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @virvil45 ,

It was 'Delay until' rather 'Delay'. You can write expression in Delay until action but the other one not.

Best regards,

Was this reply helpful? Yes No
virvil45 10 on at

Like (0)

Report
Copy link

Link copied!

Awesome, I will change it to Delay Until and add the expression you provided. Can you please break down the expression for me so that I understand what it's doing? I am in CST.

Thank you so much for your help with this!! 😊

Was this reply helpful? Yes No