Answered

Stacking filters

(0) Share

Report

Posted on by Hokus

Hi, I am new in Power Apps, and I have weird problem. I have code for gallery and few filters but how to add to this filter for actual user? I tried to mix it up but with no result.

I have:

Set(varUserEmail, User().Email);


Filter(
Filter('SharePoint List', 'Created By'.Email = var_UserProfile),
Nazwa_Search.Text in 'Column 2')


Filter([@'SharePoint List'],
And(
Or(
IsBlank(CB_KB_Filter.SelectedItems),
IsEmpty(CB_KB_Filter.SelectedItems),
'Column 1' in CB_KB_Filter.SelectedItems),
Name_Search.Text in 'Column 2'),
And (
Or(
IsBlank(StartDateDatePickerMB.SelectedDate),

'Data' >= StartDateDatePickerMB.SelectedDate && 'Data'<= EndDateDatePickerMB.SelectedDate)
))

Thanks for any help,

@Hokus

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

timl 36,863 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @Hokus

I'm not sure what you're trying to do but if you want to combine the conditions in the calls to Filter, the syntax would look like this:

Filter( [@'SharePoint List'], 'Created By'.Email = var_UserProfile), Nazwa_Search.Text in 'Column 2', And( Or( IsBlank(CB_KB_Filter.SelectedItems), IsEmpty(CB_KB_Filter.SelectedItems), 'Column 1' in CB_KB_Filter.SelectedItems ), Name_Search.Text in 'Column 2' ), And ( Or( IsBlank(StartDateDatePickerMB.SelectedDate), 'Data' >= StartDateDatePickerMB.SelectedDate && 'Data'<= EndDateDatePickerMB.SelectedDate ) ) )

Was this reply helpful? Yes No
Hokus 12 on at

Like (0)

Report
Copy link

Link copied!

Hi @timl,
Thank you for your response, but your code also isnt working.
First I wanna filter gallery that it show only files Created By on going user of the app, then to filter further with textinput, dates and combobox.

Was this reply helpful? Yes No
Verified answer

Hokus 12 on at

Like (0)

Report
Copy link

Link copied!
@timl I did it 😀,
this is working:
Filter( Filter('SharePoint List', 'Created By'.Email = var_UserProfile), And( Or( IsBlank(CB_KB_Filter.SelectedItems), IsEmpty(CB_KB_Filter.SelectedItems), 'Column 2' in CB_KB_Filter.SelectedItems), Name_Search.Text in 'Column 1'), And( Or( IsBlank(StartDateDatePickerMB.SelectedDate), 'Data' >= StartDateDatePickerMB.SelectedDate && 'Data'<= EndDateDatePickerMB.SelectedDate) ))

Was this reply helpful? Yes No