Unanswered

Filter textinputsearch and combox from gallery SharePoint list

(1) Share

Report

Posted on by Jliv

I cant seem to filter (delegable) gallery items (from SharePoint list) from a textinputsearch and combobox(multiple select) . I am able to get the textinput code working but not together with the combobox.

Code:

Filter('Case Management Tracker', StartsWith(Title,TextInputSearch.Text) Or

StartsWith(field_Customer_x0020_First_x0020_Name,TextInputSearch.Text) Or

StartsWith(field_Customer_x0020_Last_x0020_Name,TextInputSearch.Text) Or

Filter('Case Management Tracker', field_Current_x0020_Status = ComboBox1.SelectedItems.Value)

error - incompatible types for comparison record, table

Categories:

Building Power Apps

I have the same question (0)

All responses (18)

Answers (0)

Sort by

poweractivate 11,078 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@Jliv

Filter('Case Management Tracker', StartsWith(Title,TextInputSearch.Text) Or StartsWith(field_Customer_x0020_First_x0020_Name,TextInputSearch.Text) Or StartsWith(field_Customer_x0020_Last_x0020_Name,TextInputSearch.Text) Or field_Current_x0020_Status = ComboBox1.SelectedItems.Value )

Try something like above, because there is no need to start another Filter there, you are even still filtering on the same Data Source too so there is really no need there especially.

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @Jliv,

Do you want to filter gallery based on search box and Combo Box selected items?

Could you please tell me that how you set the Items property of the Combo Box1?

What is your data source?

Not sure how you set the Items property of the Combo Box1, but just modify and take a try as below:

Filter('Case Management Tracker', StartsWith(Title,TextInputSearch.Text) Or StartsWith(field_Customer_x0020_First_x0020_Name,TextInputSearch.Text) Or StartsWith(field_Customer_x0020_Last_x0020_Name,TextInputSearch.Text) Or CountRows(Filter(ForAll(field_Current_x0020_Status.Value,If(Value in ComboBox1.SelectedItems.Value,{t:1},{t:0})),t=1))>=CountRows(ComboBox1.SelectedItems.Value))

I just assume that field_Current_x0020_Status is a Choice column allowing multi select.

In addition, if you want to implement this with delegation, please check the following video from @Reza Dorran :

PowerApps Delegation & Gallery Filtering using multi select Choice and Lookup Columns (Part 4) - YouTube

Was this reply helpful? Yes No
Jliv 42 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @v-qiaqi-msft ,

Do you want to filter gallery based on search box and Combo Box selected items? Yes
Could you please tell me that how you set the Items property of the Combo Box1?
Choices('Case Management Tracker'.field_Current_x0020_Status)
What is your data source? Sharepoint list-
'Case Management Tracker'
I tried the code below and it still gave me an error-
CountRows(Filter(ForAll(field_Current_x0020_Status.Value,If(Value in ComboBox1.SelectedItems.Value,{t:1},{t:0})),t=1))>=CountRows(ComboBox1.SelectedItems.Value)
error-

thank you for your help!

Was this reply helpful? Yes No
Jliv 42 on at

Like
a
(1)

Report
Copy link

Link copied!

Thank you, @poweractivate,

I tried this one as well
Filter('Case Management Tracker', StartsWith(Title,TextInputSearch.Text) Or
StartsWith(field_Customer_x0020_First_x0020_Name,TextInputSearch.Text) Or
StartsWith(field_Customer_x0020_Last_x0020_Name,TextInputSearch.Text) Or
field_Current_x0020_Status = ComboBox1.SelectedItems.Value
)
and it shows the error expected record value.

Was this reply helpful? Yes No
poweractivate 11,078 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
@Jliv

It is not good practice because it probably will give delegation warning, but could you try simply:

field_Current_x0020_Status in ComboBox1.SelectedItems.Value

If this works at all, you can keep it if you want but if you got delegation warning yellow triangle, then the delegation limit (500, can be changed to max 2000 in Settings of the app) means that if the total number of records is greater than that number, the results will be inaccurate and only apply to that number. If that bothers you the above will need to be rewritten - but can you check if even just the above works at all perhaps in case? If the warning is not there in first place - maybe even better!

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Jliv,

Could you please show me a complete screenshot for that yours is to small to view its content.

I have seen that you have something syntax wrong with your formula, you did not refer to your data source!

Have you tried my complete formula?

I have referred to the SP list as below:

Filter('Case Management Tracker',CountRows(Filter(ForAll(field_Current_x0020_Status.Value,If(Value in ComboBox1.SelectedItems.Value,{t:1},{t:0})),t=1))>=CountRows(ComboBox1.SelectedItems.Value))

Was this reply helpful? Yes No
Jliv 42 on at

Like
a
(1)

Report
Copy link

Link copied!

I tried this one, and it didnt give me an error! However, when I tested the choice combo it didnt filter any of the records neither. Maybe I can play around with this more but I also tried it with startswith / = instead of in but no luck. I wonder if I need to do something else with the .value field for it to filter that column in the list or recognize it as a text?

Filter('Case Management Tracker', StartsWith(Title,TextInputSearch.Text) Or
StartsWith(field_Customer_x0020_First_x0020_Name,TextInputSearch.Text) Or
StartsWith(field_Customer_x0020_Last_x0020_Name,TextInputSearch.Text) Or
field_Current_x0020_Status in ComboBox1.SelectedItems.Value
)

Was this reply helpful? Yes No
poweractivate 11,078 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
@Jliv

field_Current_x0020_Status in ComboBox1.SelectedItems

This work better instead or not?

Was this reply helpful? Yes No
Jliv 42 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-qiaqi-msft ,

The code below makes the list disappear, but it doesn't give me an error either. I'm not too sure how to tweak this one since I'm unfamiliar with some of the syntax. I hope you can see the screenshot below-

Was this reply helpful? Yes No
Jliv 42 on at

Like
a
(1)

Report
Copy link

Link copied!

@poweractivate ,

No, it does the same thing. It doesn't make the list disappear, but i don't think it's recognizing it as text or value to filter out. The textinput options still work though.

Was this reply helpful? Yes No