Answered

Flow - Schedule email on Sunday after a trigger occurs

(0) Share

Report

Posted on by dylan_boucher

I have a use case where I am waiting for a file to be modified. Once it is modified, I need to wait until Sunday and move the file.

Workflow:

File is modified (triggers workflow) - sometimes occurs on Tuesday or Wednesday
Wait until Sunday
Move the modified file to a new folder

The main issue I am having is that I can't set it to a specific day of the week. The reccuring trigger will not work because I need the workflow to know what file I want to move. Any advise would be greatly appreciated

Categories:

Using connectors

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-bacao-msft on at

Like (0)

Report
Copy link

Link copied!
Hi @dylan_boucher ,

I did a test on my side, you could try the following method to determine the date of moving file.

Use the dayofWeek() function to determine if today is Sunday. If it is equal to 0, it means that today is Sunday, so you can move the file directly today.

If it is not equal to 0, then you need to add extra days until Sunday to move the file.

Use the mod() function to get the remainder of 7 and dayOfWeek(utcNow()). This value is the difference between the current date and Sunday.

Configure the addDays() function to add the remainder to the date you got today, which is the date of the Sunday. Configure this date in Delay Until action until the day you are able to execute the Move file action.

Image reference:

Please take a try.

Best Regards,

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

Like (0)

Report
Copy link

Link copied!

Hi @dylan_boucher ,

Sorry, there may be a problem with the method I provided. I don't know if you have tested it.

Please use sub() function to replace mod() function, and nothing else needs to be changed.

I am so sorry for my mistake again.

Best Regards,

Was this reply helpful? Yes No