Drop-down box to filter gallery from SharePoint choice column

(0) Share

Report

Posted on by Stephenp88

Hello,

I have a SharePoint list that has a choice field column with the ‘can select multiple’ option enabled.

I have an app with a gallery that displays the items in said SharePoint list. I would like to use a drop-down from aforementioned choice column to display all items where one of the options are mentioned in the column.

So for example, if I select option 1, all entries on the SharePoint list with ‘option 1’ in the choice column are shown regardless of other choices mentioned. Option 1 could have 5 entries, 4 of which ‘Option 1’ is the only selection but 1 of the entries has ‘Option 1, ‘Option 2’ & ‘Option 3’ selected also which need to be displayed.

I currently have a search box and a toggle on the gallery which I would like to keep - it’s formula is:

Search(Filter(‘SHAREPOINTLIST’,!Toggle1.Value || Status.Value = “Open”),TextSearchBox1.Text,”Title”)

Any assistance would be greatly appreciated!

Categories:

Building Power Apps

I have the same question (0)

All responses (26)

Answers (1)

Rajkumar_M 3,747 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi

Plz try this formula it may help you

Search( Filter( 'SHAREPOINTLIST', !Toggle1.Value || Status.Value = "Open",
Dropdown1.Selected.Value in ChoicesColumnName.Value ), TextSearchBox1.Text, "Title" )

Thanks!

Please click Accept as solution & Give a Thumps Up if my post helped you solve your issue.

Was this reply helpful? Yes No
Stephenp88 94 on at

Like (0)

Report
Copy link

Link copied!

Hi Rajkumar,

Thank you for your time. I’ve tried the suggested formula but unfortunately it doesn’t work.

it doesn’t like the ‘.value’ after Dropdown1.Selected

Was this reply helpful? Yes No
Stephenp88 94 on at

Like (0)

Report
Copy link

Link copied!

@Amik
do you have any ideas on a solution?

Was this reply helpful? Yes No
Talha_Dar 870 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @Stephenp88,

Here is a formula that might help resolve the problem you are attempting to solve.

Search( AddColumns( Filter( 'YourListName', Toggle1.Value = false, TextSearchBox1.Text = Title ), "newNameForChoicesColumn", Concat( 'currentNameOfChoicesColumn', Value, " " ) ), Dropdown1.Selected.Value, "newNameForChoicesColumn" )

Liked My Solution? Click on the Thumbs Up below.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

Like (1)

Report
Copy link

Link copied!
@Stephenp88 ,

Assuming your dropdown control is a Combo Box:

Search( Filter( 'Your Data', !Toggle1.Value || 'Status' in YourComboBox.SelectedItems ), TextSearchBox1.Text, "Title" )

@Rajkumar_404 - you had the right idea but there is no need for ".value".

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

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.

Was this reply helpful? Yes No
Stephenp88 94 on at

Like (0)

Report
Copy link

Link copied!

Hi Amik,

Thanks for your help!
unfortunately this didn’t work. Also, I’m having an issue where the field I wish to use isn’t displaying as an option within the combo box itself, which I think might be because it’s a choice type in SharePoint lists.

Was this reply helpful? Yes No
Talha_Dar 870 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @Stephenp88,

Are you currently using the following formula to render the choices column in your combo box? If not, I suggest giving it a try.

Choices(Reference to your SharePoint Choices Column)

Was this reply helpful? Yes No
Stephenp88 94 on at

Like (0)

Report
Copy link

Link copied!

Hi Talha,

sorry I’m still learning PowerApps, where would I put that formula?

Was this reply helpful? Yes No
Talha_Dar 870 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

on the items property of your Combo Box

Was this reply helpful? Yes No
Stephenp88 94 on at

Like (0)

Report
Copy link

Link copied!

When I add that formula I get the below error:
“The function ‘Choices’ has some invalid arguments”

Was this reply helpful? Yes No