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:
Status Team Leader
as New
.Status Team Leader
as Approved
and Status Department Head
as New
.Status Department Head
as Approved
and Status HR
as New
.Team Leader Resignation Request:
Status Team Leader
as Approved
.Status Department Head
as Approved
.Department Head Resignation Request:
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:
Any advice or examples would be greatly appreciated!