Power Platform Community Forum Thread Details

I’m working on setting up a Power Apps application with multiple approval stages and galleries for different roles (Team Leader, Department Head, and HR). I have a SharePoint list with columns for approval statuses by each role and a Current Stage column to indicate which gallery the item should appear in.

Here's the scenario:

Employee Resignation Request:
- Team Leader Gallery: Displays items with Status Team Leader as New.
- Department Head Gallery: Displays items with Status Team Leader as Approved and Status Department Head as New.
- HR Gallery: Displays items with Status Department Head as Approved and Status HR as New.
Team Leader Resignation Request:
- Team Leader Gallery: This item should not appear here. Approval is automatic.
- Department Head Gallery: Displays items with Status Team Leader as Approved.
- HR Gallery: Displays items with Status Department Head as Approved.
Department Head Resignation Request:
- Team Leader Gallery: This item should not appear here.
- Department Head Gallery: This item should not appear here.
- HR Gallery: Displays items with Status HR as New.

I’m using separate status columns for each approval stage and a Current Stage column to manage gallery visibility. However, I’m concerned about the complexity of managing these statuses and ensuring the correct items appear in the appropriate galleries.

My questions are:

Is it advisable to use separate status columns for each approval stage, or should I consolidate to a single status column with structured values?
How can I efficiently manage the transition of items between galleries based on approval status?
Are there best practices or common pitfalls I should be aware of in setting up such a multi-stage approval process in Power Apps?

Any advice or examples would be greatly appreciated!