Answered

Displaying only the Weeks of the current month

(1) Share

Report

Posted on by DevadathanK

Hi eveyone!

I have a doubt in PowerApps.

I am trying to create a PowerApp to record the working hours per week of a person.
So in the powerapp, it is supposed to show only the weeks of that particular month.

ex. If i open the powerapp now (in March)
It should display the weeks in March.

Week 10 ______
Week 11 ______
Week 12 ______
Week 13 ______
Week 14 ______

The remaining of the 52/53 weeks must be hidden/disabled.

Now the problem is that each year the week numbers change and the number of days differ in each week.

1) Is there a way to track the exact week numbers in PowerApps?

2) Storing this data in a sharepoint List would require me to make 52/53 columns. Is there an easier alternative?

Can you please help me out?

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (1)

Sort by

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Check this post
https://powerusers.microsoft.com/t5/Building-Power-Apps/How-to-calculate-week-number/td-p/20161

Was this reply helpful? Yes No
Verified answer

v-yutliu-msft Microsoft Employee on at

Like
a
(4)

Report
Copy link

Link copied!
Hi @DevadathanK ,

Do you want to get the weeks in current month?

I think you do not need to manually create a list with 52/53 columns, you just need to use some formulas to calculate in powerapps directly.

Could you tell me what is your week's start day? Based on the data that you provided, I think it is Sunday.

I use Sunday as the start day below.

The issue that he posted is very good @eka24 .

Many solutions there could help you a lot to calculate about week.

By referring this, I figure out the solution to get the week list that you want:

1)set the Screen's OnVisible:

ClearCollect(a,[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,.....,52,53]); ClearCollect(b,AddColumns(a,"weeknum",Concatenate("Week ",Text(Value)))); //b is a collection with all the week num value Set(startweek,If(RoundDown((Date(Year(Today()),Month(Today()),1)- Date(Year(Today()), 1, 1) + (Weekday(Date(Year(Today()), 1, 1) - 1, Sunday))) / 7, 0) = 0,52,RoundDown((Date(Year(Today()),Month(Today()),1) - Date(Year(Today()), 1, 1) + (Weekday(Date(Year(Today()), 1, 1) - 1, Sunday))) / 7, 0))+1); Set(endweek,If(RoundDown((DateAdd(Date(Year(Today()),Month(Today()),1),DateDiff(Date(Year(Today()),Month(Today()),1),Date(Year(Today()),Month(Today())+1,1))-1)- Date(Year(Today()), 1, 1) + (Weekday(Date(Year(Today()), 1, 1) - 1, Sunday))) / 7, 0) = 0,52,RoundDown((DateAdd(Date(Year(Today()),Month(Today()),1),DateDiff(Date(Year(Today()),Month(Today()),1),Date(Year(Today()),Month(Today())+1,1))-1) - Date(Year(Today()), 1, 1) + (Weekday(Date(Year(Today()), 1, 1) - 1, Sunday))) / 7, 0))+1 ) //the variable startweek is current month's start week the variable endweek is current month's end week

2) insert a list box to display the week list that you want

set the list box's Items:

Filter(b,Value>=startweek,Value<=endweek)

set the list box's Value:

weeknum

Then the list box will display the value that you want:

Now, let me explain about the formulas that I use to calculate week.

1)How to calculate today's week:

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

If you use other day as startday, replace Sunday in my formula.

2)How to get the first day in current month:

Date(Year(Today()),Month(Today()),1)

3)How to get the last day in current month:

DateAdd(Date(Year(Today()),Month(Today()),1),DateDiff(Date(Year(Today()),Month(Today()),1),Date(Year(Today()),Month(Today())+1,1))-1)

Based on the first formula, if you want to get the first week in current month, you just need to replace Today() with the second formula.

If you want to get the last week in current month, you just need to replace Today() with the third formula.

Best regards,

Was this reply helpful? Yes No
Marlin-A 269 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-yutliu-msft

Thank you for your wonderful answer it's so easy to understand, I just wanted to ask some question about this, this is because I created like this one with your reference and what I did is I based the display of weeks base on selected month on my dropdown but unfortunately the problem here is that if it is january the weeks are not appearing on my gallery.

let me know if I need to create a new thread for this problem, will post it right away.

Thank you. hope to hear good from you.

Was this reply helpful? Yes No
Ronak83garg 117 on at

Like
a
(0)

Report
Copy link

Link copied!

I am also facing the same issue, because for January month weekly overview Start week number(for eg. 52) is greater than end week number(for eg. 5)
I am able to get the week displayed from Week 1 to Week 5, but currently facing some issues on displaying Week 52 in gallery.

If you figured it out to display that, please do share it.

Was this reply helpful? Yes No
meeranair91 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, I am developing very similar to your timesheet app. Could you share the app?Thanks

Was this reply helpful? Yes No
Ronak83garg 117 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi Meera,

I was able to make the view the following view in the power app, when you click on next button the week changes accordingly based on the month it is...

If this fits your business case I can share the snippet of code.
Have a good day 😊

Was this reply helpful? Yes No
meeranair91 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Ronak83garg
Yes this is exactly what I am looking into.
Please share the code.
Thanks in advance.

Was this reply helpful? Yes No
Ronak83garg 117 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi,

Please find below snippet of code :-

1) When navigating to next month.
//First Day Of the Next Month (Adding 1 to Month)
Set(varCurrentDate, Date(Year(varCurrentDate),Month(varCurrentDate)+1,1));
//Last Day Of the Next Month (based on varCurrentDate which is the next months first day date)
Set(varMonthLastDate,DateAdd(Date(Year(varCurrentDate),Month(varCurrentDate),1),DateDiff(Date(Year(varCurrentDate),Month(varCurrentDate),1),Date(Year(varCurrentDate),Month(varCurrentDate)+1,1))-1));

2) When navigating to previous Month
//First Day Of the Previous Month (Adding 1 to Month)
Set(varCurrentDate, Date(Year(varCurrentDate),Month(varCurrentDate)-1,1));
//Last Day Of the Previous Month (based on varCurrentDate which is the next months first day date)
Set(varMonthLastDate,DateAdd(Date(Year(varCurrentDate),Month(varCurrentDate),1),DateDiff(Date(Year(varCurrentDate),Month(varCurrentDate),1),Date(Year(varCurrentDate),Month(varCurrentDate)+1,1))-1));

You can also refer the below video for more details :-
(134) PowerApps Dynamic Calendar - Gallery view to Calendar view #PowerApps #Calendar #PowerAppsGallery - YouTube

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

So you developed the whole things as a gallery? So where are the Project details filled?
I have developed something different but with the same concept.I have built single gallery which includes the project details and the hours per week details.Now I am stuck when it came to patch. As per the screenshot,
I want to patch the weeks in one particular column and not a column for each week.Could you please help me on this

Was this reply helpful? Yes No
imastur 7 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for Sharing!

Was this reply helpful? Yes No