Unanswered

Displaying calendar view for whole team (e.g. days in office tracker)

Like (0) Share

Report

Posted on 16 Feb 2021 00:32:30 by Community Power Pla...

Hi all,

I'm trying to create an app my team can access to see when the rest of the team will be in the office. I could make an Excel tracker for this, but want to make it more engaging in PowerApps. the data structure is something like as follows:

15/02/2021

16/02/2021

17/02/2021

18/02/2021

19/02/2021

20/02/2021

21/02/2021

22/02/2021

23/02/2021

24/02/2021

25/02/2021

26/02/2021

27/02/2021

28/02/2021

1/03/2021

2/03/2021

3/03/2021

4/03/2021

5/03/2021

Bob Smith

Alex jones

Users would be able to use a date control to update the values for whether in the office or not. Blank = no, 1 = yes, 2 = yes and would like to meet for coffee.

I want users to be able to see the next 2 weeks and can see who is planning to be in the office.

The problem that I'm trying to solve here is how can I then display this in PowerApps? I have tried using a Data table but I cannot dynamically change the fields to calculate if the dates are in the next two weeks.

Does anyone have any advice on how to get to this resultant "tracker" type view for a team?

Thank you

All responses (2)

Answers (0)

Community Power Pla... on 17 Feb 2021 at 23:35:06

Like (0)

Report

Re: Displaying calendar view for whole team (e.g. days in office tracker)

Hi @alrez thanks for your response. I worked out the above in the end!

I was trying to essentially get some sort of pivot table view when from a list of records I wanted to group by employee and then have the dates as columns.

I nested a horizontal gallery in a vertical gallery, using a distinct function on the vertical gallery per employee, then used filters on the horizontal gallery for employees and one that was related to a dropdown for different weeks.
alrezac on 17 Feb 2021 at 17:46:00

Like (0)

Report

Re: Displaying calendar view for whole team (e.g. days in office tracker)

Hi,

Looking through this is looks like you are trying to set up quite the PowerApp. Unfortunately there are quite a few design decisions that need to be made here and I'm honestly not sure how to implement them all. This might be a better question to bring to a Microsoft PFE. I would recommend reaching out to Microsoft on getting a PFE for this.

Regards,

Alex

-------

Community Support Team _ Alex Rezac
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.