I'm trying to build a capacity management application that allows employees to indicate how many hours they have available on any given day. Managers would then be able to view data in a chart that shows all employee data. The table would end up looking like this:
| Employee | Date | Hours Available |
| John Doe | 5/4/23 | 4.0 |
| Jane Roe | 5/4/23 | 7.5 |
| John Doe | 5/5/23 | 0.0 |
| Jane Roe | 5/5/23 | 6.5 |
I want the employees to be able to view / enter / edit their own availability without seeing their colleagues' data -- not for security/privacy reasons, but to avoid screen clutter. And I want the data entry form to use a monthly calendar layout, so it would look something like this for John Doe:
MAY
| Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |
| | 1 8.0 | 2 6.5 | 3 5.5 | 4 4.0 | 5 0 | 6 0 |
7 0 | 8 0 | 9 0 | 10 8.0 | 11 8.0 | 12 8.0 | 13 0 |
| 14 | 15 | 16 | 17 | 18 | 19 | 20 |
| 21 | 22 | 23 | 24 | 25 | 26 | 27 |
| 28 | 29 | 30 | 31 | | | |
The data could be stored in Dataverse or a SharePoint list or even an Excel spreadsheet in OneDrive -- whatever makes data entry easiest. The important thing is that the user's identity has to be captured automatically based on login credentials and the data has to be accessible to Power BI.
Is there anything already built for the Power Platform or Microsoft 365 that has this type of data entry form? I don't have the programming skills to design one from scratch.
