Gallery filter: Two filters using single select choice column of SharePoint list and one filter with multiple choice column

(0) Share

Report

Posted on by Aditya1728

I have a SharePoint list with many columns and I ma using gallery to show the data.

I want to apply three filters in Gallery.

1. Filter 1 : For Column "Status". The combo box items are coming directly from Status column value via Choice function and it works fine when I select a value from dropdown.

2. Filter 2 : For Column "Location". The combo box items are coming directly from Location column value via Choice function and it works fine when I select a value from dropdown.

3. Filter 3: This is where I am stuck. The column name is "" but it is a multiselect choice field in the list. Now the combo box for this filter shows value correctly using choice field but I have tried most of the blogs and not be to find a solution.

I want user to have all three filter and whatever they select , gallery should show data accordingly.

If I only have fist tow filters, it works fine. But I cannot get the third filter working.

This is my Items code for the Gallery:

Filter('Request Form','Created By'.Email=User().Email && (IsBlank(Statuscombobox.Selected.Value) Or IsEmpty(Statuscombobox.SelectedItems) Or ('Process Status'.Value=Statuscombobox.Selected.Value)) && (IsBlank(LocationCombobox.Selected.Value) Or IsEmpty(LocationCombobox.SelectedItems) Or ('Plant Location'.Value=LocationComboboxSelected.Value)) && (IsBlank(domaincombobox.Selected.Value) Or IsEmpty(domaincombobox.SelectedItems) Or (<Not sure what to put here as it is a multiselect column>) ))))

I am not looking to select filter options in this thirds filter, only one option in filter 3 at a time.

Appreciate your suggestions.

Thanks,

Aditya

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@Aditya1728 - If I understand this correctly, you want to add an additional Filter to the Gallery using a Combo Box set to Single Choice against a Multi-Choice SharePoint field.

If that is correct, try:

Filter( 'Request Form', 'Created By'.Email = User().Email, Len(Statuscombobox.Selected.Value) = 0 || 'Process Status'.Value = Statuscombobox.Selected.Value, Len(LocationCombobox.Selected.Value) = 0 || 'Plant Location'.Value = LocationCombobox.Selected.Value, Len(domaincombobox.Selected.Value) = 0 || domaincombobox.Selected.Value in Concat( 'Your Multi Choice Field', ThisRecord.Value & "," ) )

Note the function above is not delegable.

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Imran-Ami Khan

Was this reply helpful? Yes No
Aditya1728 97 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Imran,

Thanks for the help.
Not being delegable is a problem but that is for another day, for the time being I can live with this solution.

Regards,
Aditya

Was this reply helpful? Yes No
Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Aditya1728 - the in function is not delegable with SharePoint. If you have Dataverse (premium), consider switching to that data source instead (where in is delegable on Complex field types).

https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/connections/connection-common-data-service#power-apps-delegable-functions-and-operations-for-dataverse

Was this reply helpful? Yes No