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 | | 1 | 1 | | | | | | 1 | 2 | | | | | | 1 | 1 | | |
| Alex jones | | 1 | | | | | | | 1 | 2 | | | | | | 2 | 2 | | |
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
