Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

Facing Challenges Power app filtering

(1) ShareShare
ReportReport
Posted on by 2

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:

  1. 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.
  2. 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.
  3. 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:

  1. Is it advisable to use separate status columns for each approval stage, or should I consolidate to a single status column with structured values?
  2. How can I efficiently manage the transition of items between galleries based on approval status?
  3. 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!

Categories:
  • Suggested answer
    Ravindra Jadhav Profile Picture
    Ravindra Jadhav 240 on at
    Facing Challenges Power app filtering
    Check the relationship of your database tables. You are updating many side tables. i think
     
     
     
     
    Please Closed the Question, Mark it Solved 
     
    If my answer helped resolve your issue, please consider marking it as solved to assist others facing the same problem. Additionally, giving it a like would be greatly appreciated and motivates us to keep helping
     
    Thank You
    Ravindra Jadhav

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,422

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,711

Leaderboard