Unanswered

filter screen based on Logged in User

(0) Share

Report

Posted on by Khairul_Amri

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

mmbr1606 14,605 Super User 2025 Season 2 on at

Like (1)

Report
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

Was this reply helpful? Yes No
Khairul_Amri 39 on at

Like (0)

Report

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

Was this reply helpful? Yes No