web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Help Needed: Building ...
Power Apps
Unanswered

Help Needed: Building a PowerApps Solution with Multiple SharePoint Lists for Personnel and Duties Management

(0) ShareShare
ReportReport
Posted on by 100

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:

  1. Personnel: List containing personnel details.
  2. Positions: List containing position details.
  3. Duties: List containing duties associated with each position.
  4. Special Duties: List containing special duties assigned to individuals.
  5. Sub Duties: List containing sub duties associated with each main duty.
  6. 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:

  1. Galleries/Forms: How should I structure galleries and forms to handle the relationships between personnel, positions, and duties?
  2. Data Management: What is the best way to manage and display the assignment of duties and sub-duties to personnel?
  3. 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!)

Categories:

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 248 Super User 2026 Season 2

#2
WarrenBelz Profile Picture

WarrenBelz 192 Most Valuable Professional

#3
Mohsin Ali Profile Picture

Mohsin Ali 135

Last 30 days Overall leaderboard