Answered

filter gallery 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 requestor and Approver for requested items, I want to Filter this gallery to show only the entries of the current user logged in in the system.

ill have try this:

Filter(

ColDMAT,

IsBlank(ComboboxCanvas2.Selected.Value) || IsEmpty(ComboboxCanvas2.SelectedItems) || 'Request Status' in (ComboboxCanvas2.SelectedItems),

Requestor.email = varUser.email || Approver.email = varUser.Email

)

and also this.

Filter(

ColDMAT,

'Created By'.Email in varUser.Email || 'Modified By.Email in varUser.Email && (IsBlank(ComboboxCanvas2.Selected.Value) || IsEmpty(ComboboxCanvas2.SelectedItems) || ComboboxCanvas2.Selected.Value in "All" || 'Request Status' in ComboboxCanvas2.SelectedItems)

)

result still the same. "App don't find any data".

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

WarrenBelz 156,419 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Khairul_Amri ,

Assuming Requestor and Approver are both Person fields, then your issue may be Delegation with the in Filter - try this - note the top filter needs to return record numbers under your Data Row Limit.

With( { _Data: Filter( ColDMAT, Requestor.Email = User().Email || Approver.Email = User().Email ) }, Filter( _Data, Len(ComboboxCanvas2.Selected.Value) = 0 || 'Request Status' in ComboboxCanvas2.SelectedItems ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Khairul_Amri 39 on at

Like
a
(0)

Report
Copy link

Link copied!

appreciated for your reply, I don't know, delegation warning doesn't appear, my syntax seems good, no error or delegation sign. but apps can't find any data.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 156,419 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@Khairul_Amri ,

The idea was not to have a Delegation warning, hence the pre-filter. So breaking it down to its elements, does this return data (I assume you have records where you are he Requestor or Approver)

Filter( ColDMAT, Requestor.Email = User().Email || Approver.Email = User().Email )

Was this reply helpful? Yes No