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.

All responses (2)

Answers (0)

Khairul_Amri 39 on at

Like (0)

Report

Re: filter screen based on Logged in User

hi @mmbr1606
the apps still can't fine any data. could it be some setting at data source need to be change?
mmbr1606 12,108 Super User 2025 Season 1 on at

Like (1)

Report
Re: filter screen based on Logged in User

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