Skip to main content

Notifications

Power Automate - Using Connectors
Answered

Flow - Schedule email on Sunday after a trigger occurs

(0) ShareShare
ReportReport
Posted on by 2

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

 

  • v-bacao-msft Profile Picture
    v-bacao-msft on at
    Re: Flow - Schedule email on Sunday after a trigger occurs

    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,

  • Verified answer
    v-bacao-msft Profile Picture
    v-bacao-msft on at
    Re: Flow - Schedule email on Sunday after a trigger occurs

    Hi @dylan_boucher ,

     

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

    1. 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.
    2. If it is not equal to 0, then you need to add extra days until Sunday to move the file.
    3. Use the mod() function to get the remainder of 7 and dayOfWeek(utcNow()). This value is the difference between the current date and Sunday.
    4. 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:

    16.PNG

    Please take a try.

     

    Best Regards,

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,526

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard

Featured topics