Hello everyone, I'm relatively new to Power Apps and I have a project going that seems to be growing as we go.
My business need is that we are wanting to create a sign up for workflows, and within each workflow have four different roles, each with a specific target specific to that workflow. We have 5 cycles of time we want to have available that spans a year.
For example:
| Workflow |
WF expert |
Ops expert |
Trainee |
Ops |
| Order Fulfillment |
2 |
2 |
1 |
10 |
| Inventory Maintenance |
2 |
2 |
1 |
12 |
| Quality Sampling |
1 |
1 |
1 |
5 |
| Field Sanitation |
4 |
3 |
2 |
20 |
| Inventory Packaging |
3 |
2 |
1 |
20 |
I've got a working form that writes to a SharePoint List that is straight data entry with no limits on how many people can sign up for each workflow/role. This is a screenshot of that form:
The desired flow of this app would be that a user selects a workflow, and is then presented the four role options, which decrement as people sign up and become unavailable as options when full.
We don't want people to see other people's options, so a gallery of the list isn't ideal. They have 5 cycles of time to populate desired workflow and role for.
What is the best way to set this up? Ideally a data table is created in sharepoint. I've looked at the leave request template and considered modifying that for this purpose as well, though the additional second step of role signup would need to be added. In my head, I've got conditional dropdowns that have options enabled or disabled based on counting the number of workflow/role combinations already taken. Do I need to make a collection of existing SharePoint list conditions and calculate from there? Delegate to SharePoint? The size of the list will be less than a hundred people (records).
Any tips or guidance to point me in the right direction would be appreciated.
