Hello PowerApps Community,
I'm seeking guidance on building a PowerApps application for my workplace that integrates with six SharePoint lists. Here's the setup I'm working with:
- Personnel: List containing personnel details.
- Positions: List containing position details.
- Duties: List containing duties associated with each position.
- Special Duties: List containing special duties assigned to individuals.
- Sub Duties: List containing sub duties associated with each main duty.
- Sub Special Duties: List containing sub special duties for special duties.
Requirements and Structure:
- One person can only have one position, but each position can be filled by multiple people (e.g., overlapping during transitions).
- Special duties are tied to Personnel ID.
- Duties are tied to Position ID.
- Each person (Personnel) is tied to a Position ID.
- Sub-duties are tied to Duty ID.
Progress So Far:
- Main Page: Includes links to other pages.
- Personnel Page: Add/Edit/Delete personnel.
- Positions Page: Manage all positions.
- Duties Page: Manage duties.
Assistance Needed:
I'm looking for the best approach to:
- Manage and add duties to personnel.
- Assign each person to a duty.
- Efficiently use 365 profiles/person columns, choice columns, text/number fields, and lookup fields (if advised).
Specific Questions:
- Galleries/Forms: How should I structure galleries and forms to handle the relationships between personnel, positions, and duties?
- Data Management: What is the best way to manage and display the assignment of duties and sub-duties to personnel?
- Lookups and Data Fields: Any advice on utilizing lookup fields or other column types to streamline the app?
Any examples, templates, or detailed instructions would be greatly appreciated. Thank you in advance for your help! (would pay if this is a service that can be completed ha!)

Report
All responses (
Answers (