Search data in sharepoint list multiple choice type column

(0) Share

Report

Posted on by LCamillo

Does anyone know a formula to search for data entered in multiple choice columns in Sharepoint?

I can fetch data when the column only allows one choice, but for multiple I still couldn't.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

WarrenBelz 156,117 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @LCamillo ,

I assume you mean Filter - this is not Delegable, but you need

Filter( ListName, FieldName in ComboBoxName.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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
LCamillo 4 on at

Like
a
(0)

Report
Copy link

Link copied!
Thanks for the help, but I couldn't solve it. I'll try to explain better... I have a list called 'Weekly schedule' and in it there is a column called 'Type'. This column is of the choice with multiple selections type. I created a Combobox for selection with the formula: Choices('Weekly schedule'.Type) I created a Gallery to view the results and tried your tip, but it doesn't work.

Was this reply helpful? Yes No
WarrenBelz 156,117 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@LCamillo ,

You have a many-to-many relationship - again this is not Delegable

Ungroup( ForAll( ComboBoxName.SelectedItems As aVal, Filter( 'Weekly Schedule', aVal.Value in Type.Value ) ), "Value" )

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
LCamillo 4 on at

Like
a
(0)

Report
Copy link

Link copied!

It still doesn't work...
Maybe I should adjust my list. I thought about changing the column type and putting the choices in the app. Seems more viable, doesn't it?

Was this reply helpful? Yes No
WarrenBelz 156,117 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@LCamillo ,

Totally agree - I do not use Choices columns unless storing multiple items and even then, I either hard-code or get the items with a Filter,

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No