Unanswered

To compute the coming Friday's date

(0) Share

Report

Posted on by kevingeorget

274

Hi Flow Users, I'm working on a Flow that help in a weekly report generation in SharePoint. I would need to append the coming Friday's date to the report name. The report generation can be triggerred on a Monday or a Tuesday. E.g. If a trigger the report generation flow today (29/07/2019), then i need to append a coming Friday's date to the file name, i.e. 02/07/2019. Any help appreciated. Thanks, Kevin

Categories:

Using flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

RezaDorrani 12,143 on at

Like (1)

Report

Hi @kevingeorget

Try this
Since Friday is always going to be the 5th day of the week

We can first do a check to see if todays day is before coming Friday

Condition
sub(5,dayOfWeek( utcNow())) greater than 0

If Yes -
addDays(utcNow(),sub(5,dayOfWeek( utcNow()))) - should give you Friday's date

If No -
addDays(utcNow(),add(sub(5,dayOfWeek( utcNow())),7)) - should give you Friday's date

Regards,
Reza Dorrani

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Was this reply helpful? Yes No
takolota1 4,974 Moderator on at

Like (0)

Report

How to get the date of the next upcoming day of the week.
Choose a day of the week, ex: 5 for Friday, and get the date of the next Friday starting from utcnow().

https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Date-of-Next-Chosen-Day-of-Week/td-p/1466540

I often see requests for timing things a certain time on a certain day of the week and people respond with an expression formula for that person’s requested day of the week and only their requested day of the week. With this, we shouldn’t need to find a different formula for each day.

Was this reply helpful? Yes No