Showing results for 
Search instead for 
Did you mean: 

Addition of Week Number function in Powerapps

Currently, we don't have any direct way to calculate week number of the particular Date.

It would be better to have a function which displays the weeknumber for example: WeekNum("26-10-2017") = 43 to avoid usage of other source for this information and then retrieving back to Powerapps application.


Status: Under Review

Updating status and adding @GregLi

Regular Visitor


i'd expect the basic excel formula library to be available in powerapps.

Not applicable

I support the request of having a Weeknumber function available in PowerApps.

Regular Visitor

I looking for a formula thats support this function aswell, weeknum would be rally nice

Helper I

Same for me

Helper II

No news about this request?

New Member

I can'r beleive this hasn't been addressed yet !!!!


Responsive Resident

The only way that I'm able to do it is using a sharepoint list for my tables with a calculated column. This is retuned to me in my collection.

New Member

Thanks nickduxfield  I have managed to get it working using the following formula posted earlier in the thread by using a label and then editing the label by removing the "text" part and replacing it by the following. My week starts on a Monday so you can replace Monday with your choice of start.

If(RoundDown((Today() - Date(Year(Today()), 1, 1) + (Weekday(Date(Year(Today()), 1, 1) - 1, Monday))) / 7, 0) = 0, 52,RoundDown((Today() - Date(Year(Today()), 1, 1) + (Weekday(Date(Year(Today()), 1, 1) - 1, Monday))) / 7, 0))

Responsive Resident

Thanks @mickg, If i can get htis working thats one last hurdle I need to cross for now. However, because I work primarly with Sharepoint lists, bringin it back from a sharepoint list is part of my normal routine. It works because I need to bring it in for my collecions any how.

There is almost no way for me to avoid arranging information in Weeks.

I found however, that i needed to have a simple number column of 'Week" to interact with Flow.


Power Apps
Status changed to: Under Review

Updating status and adding @GregLi