cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pityman
Helper III
Helper III

Get all date for the week of the selected month

Hi, 
Any way to get all dates for the week of the selected month?

For example. I would like to know all the date for week 1 in February?

1 ACCEPTED SOLUTION

Accepted Solutions
v-bofeng-msft
Community Support
Community Support

Hi @pityman ,

 

I've made a test for your reference:

My flow:

vbofengmsft_0-1664441815963.png

1\

dayOfWeek(last(variables('DataArray'))['Date'])
2\
addDays(last(variables('DataArray'))['Date'],1)
 

Result:

vbofengmsft_1-1664441875833.png

 

Best Regards,

Bof

 

View solution in original post

3 REPLIES 3
v-bofeng-msft
Community Support
Community Support

Hi @pityman ,

 

I've made a test for your reference:

My flow:

vbofengmsft_0-1664441815963.png

1\

dayOfWeek(last(variables('DataArray'))['Date'])
2\
addDays(last(variables('DataArray'))['Date'],1)
 

Result:

vbofengmsft_1-1664441875833.png

 

Best Regards,

Bof

 

Brilliant!! Can i know if we can filter by no. of week as well? for example we only get the dates for week 1 

Hi @pityman ,

 

There is no such an OOB weeknum function in power automate. But you can get weeknum by dividing dayOfYear by 7.

 

Best Regards,

Bof

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (4,323)