cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Oskarkuus
Post Prodigy
Post Prodigy

Help Filtering combobox that starts with....

I have a gallery.

In my gallery i have a combobox with the value from my datasource (sharepoint list).

Then i have a textfield outside of my gallery

 

I want to filter my gallery based on what i type in my textbox.

This works fine with textbox to textbox filter. But i cant get it to work with the textbox to combobox.

 

I guess i need to convert the data from a record (combobox) to text/string (textbox).

 

But how?

This is my filter formula, the bold text is what i have problems with. The rest works fine.

SortBSortByColumns(Filter('EKAN Informerar';
If(Checkbox2.Value=false;true; Rutin = Checkbox2.Value);
If(Checkbox2_1.Value=false;true; Info = Checkbox2_1.Value);
If(Checkbox2_2.Value=false;true; System = Checkbox2_2.Value);
If(Checkbox2_3.Value=false;true; Tips = Checkbox2_3.Value);
If(Checkbox2_4.Value=false;true; Ovrigt = Checkbox2_4.Value);
TextInput2.Text in 'Ange Rubrik på ditt meddelande';TextInput2_1.Text in 'Skriv ditt meddelande';
TextInput1.Text in ValjTeam.Value);"Created";Descending)yColumns(Filter('EKAN Informerar';
If(Checkbox2.Value=false;true; Rutin = Checkbox2.Value);
If(Checkbox2_1.Value=false;true; Info = Checkbox2_1.Value);
If(Checkbox2_2.Value=false;true; System = Checkbox2_2.Value);
If(Checkbox2_3.Value=false;true; Tips = Checkbox2_3.Value);
If(Checkbox2_4.Value=false;true; Ovrigt = Checkbox2_4.Value);
TextInput2.Text in 'Ange Rubrik på ditt meddelande';TextInput2_1.Text in 'Skriv ditt meddelande';
TextInput1.Text in ValjTeam.Value);"Created";Descending)

ValjTeam.Value = my column in my datasource that populate my gallery.

TextInput1 = the datafield outside of the gallery where i want to filter the gallery based on what i type.

 

If i type ABC i want all values in the combobox that starts with ABC or contain ABC. This works with textfields but not the combobox. Now i need to type exactly the value of the selection in the combobox.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

@Oskarkuus 

Ah the power of troubleshooting!!

Your Column is defined as "Checkboxes (allow multiple selections)"

 

First question is, do you need it to really have multiple selections?  If not, easy answer, change the column to not allow multiple selections and your formula will then work fine.

 

If you need the multi-selections in the column, then you'll need to go back to our add columns, but now our formula will be this:

SortByColumns(
         Filter(
                 AddColumns('EKAN Informerar'; "txtValjTeam"; Concat(ValjTeam; Value & ";"));
                  If(Checkbox2.Value=false;true; Rutin = Checkbox2.Value);
                  If(Checkbox2_1.Value=false;true; Info = Checkbox2_1.Value);
                  If(Checkbox2_2.Value=false;true; System = Checkbox2_2.Value);
                  If(Checkbox2_3.Value=false;true; Tips = Checkbox2_3.Value);
                  If(Checkbox2_4.Value=false;true; Ovrigt = Checkbox2_4.Value);
                  TextInput2.Text in 'Ange Rubrik på ditt meddelande';
                  TextInput2_1.Text in 'Skriv ditt meddelande';
                  TextInput1.Text in txtValjTeam
                 );
 "Created";Descending)

This should give you the capablity you want on the multi-select column.

 

 

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

View solution in original post

6 REPLIES 6
RandyHayes
Super User III
Super User III

@Oskarkuus 

What you need to do is to pull the values in the column into something that you can apply that filter to.  In this case, using the AddColumns function will be helpful for you.  Consider the following:

SortByColumns(
         Filter(
                 AddColumns('EKAN Informerar'; "txtValjTeam"; ValjTeam.Value);
                  If(Checkbox2.Value=false;true; Rutin = Checkbox2.Value);
                  If(Checkbox2_1.Value=false;true; Info = Checkbox2_1.Value);
                  If(Checkbox2_2.Value=false;true; System = Checkbox2_2.Value);
                  If(Checkbox2_3.Value=false;true; Tips = Checkbox2_3.Value);
                  If(Checkbox2_4.Value=false;true; Ovrigt = Checkbox2_4.Value);
                  TextInput2.Text in 'Ange Rubrik på ditt meddelande';
                  TextInput2_1.Text in 'Skriv ditt meddelande';
                  TextInput1.Text in txtValjTeam
                 );
 "Created";Descending)

This will create a usable column that you can apply your filter logic to.

 

I hope this is helpful for you.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

I am using your code.  I get no errors....

But nothing happens....

 

What more should i do to make this work?

@Oskarkuus 

Okay, so not so helpful then.   This was a shot based on what might have been the type of column you had.

 

Let's do a little troubleshooting...

First, change your formula to the following:

SortByColumns(
         Filter(
                 'EKAN Informerar';
                  If(Checkbox2.Value=false;true; Rutin = Checkbox2.Value);
                  If(Checkbox2_1.Value=false;true; Info = Checkbox2_1.Value);
                  If(Checkbox2_2.Value=false;true; System = Checkbox2_2.Value);
                  If(Checkbox2_3.Value=false;true; Tips = Checkbox2_3.Value);
                  If(Checkbox2_4.Value=false;true; Ovrigt = Checkbox2_4.Value);
                  TextInput2.Text in 'Ange Rubrik på ditt meddelande';
                  TextInput2_1.Text in 'Skriv ditt meddelande'
                 );
 "Created";Descending)

We've removed the reference to the ValjTeam in this scenario.  Do you get results as expected (minus the ValjTeam aspect)?

 

Next, change your formula to the following:

SortByColumns(
         Filter(
                 'EKAN Informerar';
                  TextInput1.Text in ValjTeam.Value
                 );
 "Created";Descending)

We've now focused JUST on the ValjTeam column.  Do you get the results you expect from that?

 

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Code 1.

It works, i get the everything without any working filter to ValjTeam column.

 

Code 2.

I get no results in my gallery. In my textinput1 i Type a few letters that i know are part of choices in ValjTeam column.

The gallery goes empty direct unless i type the full string of one choice in ValjTeam column.

@Oskarkuus 

Ah the power of troubleshooting!!

Your Column is defined as "Checkboxes (allow multiple selections)"

 

First question is, do you need it to really have multiple selections?  If not, easy answer, change the column to not allow multiple selections and your formula will then work fine.

 

If you need the multi-selections in the column, then you'll need to go back to our add columns, but now our formula will be this:

SortByColumns(
         Filter(
                 AddColumns('EKAN Informerar'; "txtValjTeam"; Concat(ValjTeam; Value & ";"));
                  If(Checkbox2.Value=false;true; Rutin = Checkbox2.Value);
                  If(Checkbox2_1.Value=false;true; Info = Checkbox2_1.Value);
                  If(Checkbox2_2.Value=false;true; System = Checkbox2_2.Value);
                  If(Checkbox2_3.Value=false;true; Tips = Checkbox2_3.Value);
                  If(Checkbox2_4.Value=false;true; Ovrigt = Checkbox2_4.Value);
                  TextInput2.Text in 'Ange Rubrik på ditt meddelande';
                  TextInput2_1.Text in 'Skriv ditt meddelande';
                  TextInput1.Text in txtValjTeam
                 );
 "Created";Descending)

This should give you the capablity you want on the multi-select column.

 

 

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

View solution in original post

Awesome. That works!

 

Thank you very much!!

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Carousel April Dunnam Updated 768x460.jpg

Urdu Hindi D365 Bootcamp

Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.

Top Solution Authors
Top Kudoed Authors
Users online (1,903)