58
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!
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
Share
Report
All responses (
Answers (
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
@WarrenBelz : Thanks for your help!
Unfortunately I get an error: He finds more arguments than he would like.
Greetings
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
If I insert it as described above, the gallery is empty
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.
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
#1
WarrenBelz
146,708
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,030
Most Valuable Professional
