Hi all. With Canvas apps, does anyone know of a way to display a wide month-view calendar with a column for each day and a row for each record for the month (e.g. for a team work roster, or leave roster), and with forward/back buttons to move between months in the view? I've seen examples of this with 7 columns in a gallery for a week view, but haven't found a way to make a 28-31 column gallery for the month view.
I wondered about using a horizontal gallery, with the current date as the default selection, so users would see the next X days on screen, or can scroll left to see previous days. I don't think it would be a good idea to add/remove columns from the database as people come and go, so I'd need to generate a collection for this view, I think. We have several of these types of tables in Excel, and a couple of them would have a vastly improved data-entry experience if I could turn them into Power Apps. I'd like to display the data in a similar format to the Excel sheet if possible, hence this question.
Also, any tips on database design for this type of data? I've used SharePoint Lists for most of my apps, but have recently been using Dataverse for Teams. My concern is that with daily entries for every employee we'd reach the Dataverse for Teams row limit before long. I might be able to justify per-user/app pricing for premium connectors if that would help.
thanks
Geoff
