Due Date Last Friday of Month

[ZPS13]

I am trying to figure out how to set the due date for a monthly recurring task in Planner to be the Last Friday of the Month or the First Friday of the Month.  

[v-alzhan-msft]

Hi @ZPS13 ,

Do you want to create a recurring task in planner with Microsoft flow?

I have made a test on my side and I'm afraid that we couldn't create a recurring task in Microsoft flow currently, the function to create a recurring take in planner is not supported in microsoft flow currently.

If you would like this feature to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

Best regards,

Alice       

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ZPS13]

Thanks @v-alzhan-msft,

I know there are ways to get the last day of the month or only send out an email on the last day as long as it's not a weekend.  I just wasn't sure if it was possible to use a formula in Power Automate to find the Last Friday of a Month, regardless of whether it is a recurring task in Planner.  

[v-alzhan-msft · Accepted solution]

Hi @ZPS13 ,

If you want to send an email on the last Friday every month, you could refer to screenshot below to create the flow:

The first expression in the Condition:

formatDateTime(utcNow(),'MM')

The second expression in the condition:

formatDateTime(addDays(utcNow(),7),'MM')

Best regards,

Alice       

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.