Unanswered

Calendar View Showing Count of records specific to a date

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Good evening and Happy Holidays. I created a calendar view attached to a sharepoint list. I made a version into a vacation request based on a few videos I saw. Now I want to use this same calendar to visual the total number of requests made for that day. My table is simple....

Request Type

Start Date

End Date

What I am looking to do is not visualize the individual records within that date in the calendar, but the total # of requests made for that particular day. I tried throwing in a text box with a count, but it shows each individual record as "1." I just want one number in that calendar square that shows the total requests.

If anything else needed please let me know.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

cha_cha 4,932 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hello @Anonymous

Is this just within SharePoint and not Power Apps? If this is just SharePoint, this would probably be the most appropriate place to get your answer:
https://techcommunity.microsoft.com/t5/sharepoint/ct-p/SharePoint

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

Like (0)

Report
Copy link

Link copied!

It is a Power App. I use a list to house the requests made within the power app via a form. I just would like to know how to visualize the sum of requests within the calendar visual for each day. I’ve used it to show each record via a nested gallery, but can’t figure out how to just visualize the sum of requests.

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

Like (0)

Report
Copy link

Link copied!

My assumption is maybe a for all function that loops through the data and counts and sums the instances on those particular dates within the calendar. Just a very amateur guess. Considering I have to find the dates between the start and end date I am not sure how to do this. As stated, watching a few videos I was able to create the filter to display individual instances within the gallery between the dates just not the full roll ups of counts within a gallery in that specific date in that Calendar. If there are 4 requests I don’t want four text boxes for example showing a count of 1 for each. I want one box showing the 4 requests for that particular day.

Was this reply helpful? Yes No
cha_cha 4,932 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hello @Anonymous

Apologies that I couldn't visually get your explanation. If you can send illustrations/screenshots, to get us right to what you are working on quicker.

Here's my tentative answer to your case:
Given that this is your record:
And this is the report you want
RemoveColumns( AddColumns( GroupBy( Filter('LeaveRecords', StartDate <= DatePicker.SelectedDate, EndDate >= DatePicker.SelectedDate) ) ,"Request Type" ,"All Leaves" ) ,"Count" ,CountRows('All Leaves') ) ) ,"All Leaves" );

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

Like (0)

Report
Copy link

Link copied!

Below is where I want to visualize the count of the requests made for that particular day. This calendar is taken from the calendar built into the new screen. Credit to Reza Dorrani video as I used his formula ,
Filter(
'Vacation Request',
DateAdd(
_firstDayInView,
ThisItem.Value,
Days
) >= 'Start Date' && DateAdd(
_firstDayInView,
ThisItem.Value,
Days
) <= 'End Date'
),
in the items property of my nested gallery within the MonthGallery to attach the requests across all days from Start Date to End Date. Now I want to place a label in that Nested gallery to show the sum of the requests rather than individual requests in the text property.

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

Like (0)

Report
Copy link

Link copied!

ALso the type does not matter in the total number I want to show. I just want say a "4" to show in the label.

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

Like (0)

Report
Copy link

Link copied!

I think I figured it out.. At least on surface. I removed the nested gallery so I can reference "ThisItem.Value" in the parent gallery in my countrows formula which is,
CountRows(Filter(
'Vacation Request',
DateAdd(
_firstDayInView,
ThisItem.Value,
Days
) >= 'Start Date' && DateAdd(
_firstDayInView,
ThisItem.Value,
Days
) <= 'End Date'
)).

Thoughts?

Was this reply helpful? Yes No