You’re offline. This is a read only version of the page.
33
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.
To make sure we're talking about the same thing, is this the calendar screen you are referring to? Calendar-screen template in canvas apps - Power Apps | Microsoft Learn
How would I change the data source for that kind of calendar to reference a table outside of the Outlook calendars that are available to the end user?
Thanks for the suggestion, but I think that going from a grid where each row is a record to a grid where you have multiple records on each row as in a calendar is too complicated for me to program.
You need to change data source and filter according to table or list dates.
I think that calendar tool will display a user's Outlook calendar within a Power App. How could I use it to enter data into a field in Dataverse or SharePoint?
I believe you can adapt the default Power Apps calendar screen to your needs. What do you think?
#1
WarrenBelz
146,605
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,946
Most Valuable Professional
Share
Report
All responses (
Answers (
