Create Gallery using a table as a filter

[Boppersnr]

I want to create a Gallery filter based on a table in a SharePoint library.

I have a SharePoint document library and I want to use PowerApps for a front end GUI to show the documents in the library.

Trouble I am having is that a field (Process) I want to use as a search field is a choice column that allows multiple selections. Any idea of what code I need to put in to the gallery to filter by the Process ComboBox selection?

[StalinPonnusamy]

Hi @Boppersnr 

Set the Items Property of Gallery to

With (
    {_item: 'Quality and Training Library'},
    Filter(
        _item,
       IsEmpty(ProcessComboBox.SelectedItems) || Process.Value in ProcessComboBox.SelectedItems.Value
    )
)

Thanks,
Stalin - Learn To Illuminate

[Boppersnr]

Thanks for the code. I am getting this error though

[Boppersnr]

I assume it because the Process column is a Choice (allowing multiple selections)

[StalinPonnusamy]

Thanks for the info. Let me get the code updated and send to you.

[StalinPonnusamy · Accepted solution]

Hi @Boppersnr 

With (
    {_item: 'Quality and Training Library'},
    Filter(
        _item,
        IsEmpty(ProcessComboBox.SelectedItems) || (Concat(
            ProcessComboBox.SelectedItems,
            Value & ","
        ) in Concat(
            Process,
            Value & ","
        ))
    )
)

Are you expecting in PowerApps to also do MultiSelect?

[Boppersnr]

That work a treat ! Genius.

Yes, I would love to have the option to be able to multiselect in the gallery filter. Do you think that is possible? Not a show stopper if its not possible. but nice to have the option.

[Boppersnr]

I also have a need to filter a gallery by person/group (again with multiple selections enabled). I can see that choice will not work , so what command do you use for people/groups. there is no error in the code, its just that the drop down is blank.

[StalinPonnusamy]

Hi @Boppersnr 

Insert combo box and set the Items property to

Office365Users.SearchUser({searchTerm: ""})

Set DisplayFields property to

["DisplayName"]

Set SearchFields property to

["DisplayName"]

Set IsSearchable property to

true

Result

Thanks,
Stalin - Learn To Illuminate

[Boppersnr]

that's great and that lists all users available in the Office365Users tenant. but how can I link that to a user that appears is in the 'Training Required by Individual' field in my Quality and Training Document Library . I want to search for all users that are in this 'Training Required by Individual' field. So I would be happy to use the Office365Users but need it to then for the gallery to show the users entries that appear in the 'Training Required by Individual' column. so something like search Office365Users and display in gallery if they exist in 'Training Required by Individual' field. Tricky?