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

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Only Approved item sho...
Power Apps
Unanswered

Only Approved item should be shown in PowerApps Gallery Items

(0) ShareShare
ReportReport
Posted on by Community Power Pla... Microsoft Employee

Hi All,

 

I have created powerapp solution for my purchase tool. Where user can submit request for approval.

 

I have created a screen , where through item selected on gallery visible on the basis of created by mail.

Bhavuk1987_0-1618310213177.png

 

Now , I also want to update that gallery with approved columns and once it's approved,  it shouldn't shown in the gallery item for requester.

Categories:
Building Power Apps
I have the same question (0)
  • Pstork1 Profile Picture
    Pstork1 69,653 Most Valuable Professional on at

    What kind of column are you using for Approved column?  All you need to do is add that to the Filter using an and '&&' connector.  Something like this if its a choice column.

    Filter('E-PRF Master data', 'Created By'.Email = varUser.Email && Not(Approved.value = "Approved"))
  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    hi,

    thanks for sharing the info, below are key points for this field

     

    it's "Text" field from SPList.

     

    your given formula is working , but getting delegation warning.. 

     

     

    "The highlighted part of this formula might not work correctly on large data set. The "Not" operation is not supported by this connector 

  • Pstork1 Profile Picture
    Pstork1 69,653 Most Valuable Professional on at

    That is correct.  Not() isn't delegable.  There are two ways to deal with that.

    1) remove the Not() and change that portion of the formula to check for all the acceptable values.  For example,

    Filter('E-PRF Master data', 'Created By'.Email = varUser.Email && (Approved = "Started" || Approved = "Pending"))

    But that may require trying to check for too many cases.

    2) Pre-filter the data source using a delegable filter and put the non-delegable filter on the outside.  If the inner filter returns fewer than the maximum records it won't matter that the outer one isn't delegable

    Filter(Filter('E-PRF Master data', 'Created By'.Email = varUser.Email)Not(Approved.value = "Approved"))

     

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    I

    I have different -2 screen of approvals.. And each level once item is approved with signatory, it should not be shown to the same person screen

    i used the same formulla you suggested , but it's only working on my first screen but not working on next screen.

    can you please suggest

  • Pstork1 Profile Picture
    Pstork1 69,653 Most Valuable Professional on at

    Can you show me the two formulas you are using?

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    hi,

     

    in my first screen, i am using formula as you defined and it is working for me. But, when the same formula , I used in my second screen , it is not working. Can you please help on it.

     

     

    Bhavuk1987_0-1618985544284.png

     

    In the below items, now this is approver screen. I want if the item is already approved , it shouldn't show to the approver side as well.

    "SortByColumns(Filter('E-PRF MASTER DATA', ApproverEmail = varUser.Email), "ID", Descending)"

     

    Bhavuk1987_1-1618985673420.png

     

     

  • Pstork1 Profile Picture
    Pstork1 69,653 Most Valuable Professional on at

    On your second screen you'll need to change the formula to check whether the item has been approved or not.  The formula currently only filters to show you items where you are the designated approver.  What is the field and what type of field are you using to record that the item is approved?

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    hi,

     

    i changed the formula

     

    Filter('E-PRF MASTER DATA', FinanceApprovalEmail= varUser.Email && Not(Approval1="Approved"))

     

    but it's not showing me any unapproved request. I am using text column for financeapprovalemail

     

    Bhavuk1987_0-1619074523677.png

     

  • Pstork1 Profile Picture
    Pstork1 69,653 Most Valuable Professional on at

    What kind of field is Approval1?  If its a choice field then you need to use 

    Not(Approval1.Value="Approved")
  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    This is "Text" field in SP list

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

News and Announcements

Welcome to the Power Platform Communities

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

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 358 Most Valuable Professional

#2
11manish Profile Picture

11manish 207 Super User 2026 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 150 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans