Answered

Search in multiple choice field

(0) Share

Report

Posted on by Masakichi123

Hello everyone,

I would like to use a text input field as a search field for a multiple choice field in SharePoint. How do I have to set the syntax so that it can be searched?

Thanks in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report
HI @Masakichi123 ,

Something like

Filter( YourList, YourSearchText.Text in YourMultiChoiceField.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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Masakichi123 58 on at

Like (0)

Report

Hi @WarrenBelz ,

Unfortunately I get an error here.
I'm trying to combine it with multiple combo boxes. There are also two text columns in which I would also like to search using the text input.

Unbenannt.PNG

Was this reply helpful? Yes No
Masakichi123 58 on at

Like (0)

Report

If I insert it as described above, the gallery is empty

Was this reply helpful? Yes No
WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report
@Masakichi123 ,

Firstly, please post your code in text (watch spelling on the code below) as it saves re-typing/OCR on this end.

That is not an error - it is a Delegation warning as the in filter is not Delegable. You need to do something like this

With( { _Data: Filter( ’Mitarbeiter-Qualifikationen'; Len(ComboBoxl.Selected.Result) = 0 || Level = ComboBoxl.Selected.Result; Len(ComboBox4.Selected.Result) = 0 || Tit1e = ComboBox4.Selected.Result; Len(ComboBox3.Selected.Result) = 0 || Anbieter = ComboBox3.Selected.Result; (Checkboxl.Value && 'Name Mitarbeiter'.Email = User().Email) || (!Checkboxl.Value && !Checkbox2.Value) || (Checkbox2.Value && || 'Name Mitarbeiter'.Email = User().Email) ) }, Filter( _Data; Txtsuche.Text in Stichwörter.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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Masakichi123 58 on at

Like (0)

Report

@WarrenBelz : Thanks for your help!
Unfortunately I get an error: He finds more arguments than he would like.

Greetings

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report
@Masakichi123 ,

The posed code is valid structure (it should be the code you posted inside the With() statement) - please re-check you have applied it properly and also if the spelling is correct. Another option on connectors is this

With( { _Data: Filter( ’Mitarbeiter-Qualifikationen'; ( Len(ComboBoxl.Selected.Result) = 0 || Level = ComboBoxl.Selected.Result ) && ( Len(ComboBox4.Selected.Result) = 0 || Tit1e = ComboBox4.Selected.Result ) && ( Len(ComboBox3.Selected.Result) = 0 || Anbieter = ComboBox3.Selected.Result ) && ( ( Checkboxl.Value && 'Name Mitarbeiter'.Email = User().Email ) || ( !Checkboxl.Value && !Checkbox2.Value ) || ( Checkbox2.Value && || 'Name Mitarbeiter'.Email = User().Email ) ) ) }, Filter( _Data; Txtsuche.Text in Stichwörter.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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Masakichi123 58 on at

Like (0)

Report

@WarrenBelz: Thanks for your help! 🙂

Was this reply helpful? Yes No