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 / filter screen based on...
Power Apps
Unanswered

filter screen based on Logged in User

(0) ShareShare
ReportReport
Posted on by 39

Hi everyone,

I am trying to create a screen where there's a gallery connected to a SharePoint List, In this SharePoint List, there's a column that lists who created the entries, I want to Filter this gallery to show only the entries of the current user logged in in the system, also the user can add another filter either to show only pending for approval, approve, or show all records under his name.

ill also have try this:

Filter(
    ColDMAT,
    IsBlank(ComboboxCanvas2.Selected.Value) || IsEmpty(ComboboxCanvas2.SelectedItems) || 'Request Status' in (ComboboxCanvas2.SelectedItems),
     'Created By'.Email = varUser.email || 'Modified By'.email = varUser.Email
)
result still the same.

 

Khairul_Amri_0-1710145290838.png

 

Categories:
I have the same question (0)
  • mmbr1606 Profile Picture
    14,629 Super User 2026 Season 1 on at

    hey @Khairul_Amri 

     

    try this:

    Filter(
     ColDMAT,
     ('Created By'.Email = varUser.email || 'Modified By'.Email = varUser.Email) &&
     (
     IsBlank(ComboboxCanvas2.Selected.Value) || 
     IsEmpty(ComboboxCanvas2.SelectedItems) || 
     ComboboxCanvas2.Selected.Value = "All" || 
     'Request Status' = ComboboxCanvas2.Selected.Value
     )
    )
    

     

    Let me know if my answer helped solving your issue.

    If it did please accept as solution and give it a thumbs up so we can help others in the community.



    Greetings

  • Khairul_Amri Profile Picture
    39 on at

     

    hi @mmbr1606  

    the apps still can't fine any data. could it be some setting at data source need to be change?

    Khairul_Amri_0-1710297736776.png

     

     

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

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 325 Most Valuable Professional

#2
11manish Profile Picture

11manish 165

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 88 Super User 2026 Season 1

Last 30 days Overall leaderboard