PowerApps Combobox - Search, Filter, Default values, and more 

I have no specific question, I just want to thank you for all the effort you put into recording these videos. You're giving a lot of value !

dude .. just want to say thanks a million , I was given one week to learn powerapps and develop a solution your videos have been a fountain of gold.

You are like powerapps encyclopedia... search for the topic and at least one video from your channel pops up in search results ! Just for the change I thought let me check how other channels describe the same topic ... watched 3-4 but didnt get clear answer ! Watched only 11 minutes of this video and got the answer I was looking for !! Thank you very much Shane for all your efforts !!

After binge-watching your videos i have noticed how my modest projects have grown because of the "that would be so cool!"-factor. -"Do we really need barcodes on everyting?" - Now we do! -"Could we not use a Post-it note?" -No! We need SharePoint-lists with attachments-capabilities and record of altitude and acceleration during posting. Thank you Shane!

I have just finished 2 apps for a school in Saudi Arabia using only combo boxes, Now I can all SPO list fields text, No more lookups. YaaY! Thanks Shane, I learned a lot from your videos. Now I'm freelancing PowerApps.

You are a legend. I have been looking for this all over the web but could not find. THANKS A LOT!!

Am from kuwait 2022/February and i watch all your power apps video so really thx 🙏 alot

Thx so much !!!!! Handling comboboxes was a bit tricky... very helpfull... greetings from germany Christoph 👏 👏 👏 👏 👏

Shane, you are a genius! You just solved my issue for the millionth time!

Much appreciate putting the Combo box back into my tool belt. Best.

Hey Shane, I'm working my way through all your videos. I'm learning so much. You rock!

Super helpful. I was struggling with DefaultSelectedItems, this made the setup very clear. Thank you!

YOU ARE THE MAN!! Thank you so much for this video! KUDOS

Shane, you are amazing. Keep going please please!

A note on DefaultSelectedItems - you can show one of the items that populate your combobox as a default using the following method: Filter(Choices(Table.Column),Value="Enter default value here")

Thank you very much! greetings from Argentina

Also, thank you so much for all of these videos they have been so helpful!

Thank for you brilliant explication!!

I've been looking for this for a whole week. Thank you for the video. It helped me a lot.

Shane, great videos. i really appreciate the real world examples. one of the things with using SharePoint lists with Choice Columns (that creates a combobox in powerapps), is how to display a dropdown based on one of the selected items in the combobox(although labeled as a Data CardValue) in PowerApps. from your examples, i pulled out the script, " If("Other" in DataCardValue23.SelectedItems.Value,true,false)" that i can use in a Visible property of a following pulldown I want to show only if "Other" is picked in the previous combobox. Just posting here for others.

Thanks, keep up good work!

YOU ROCK!!!!!!!!

Shane, I'm looking to place data from a collection to a combobox. Arrrrgggghhhh!!!! Is that in a different video.... I need a RU-vid Channel subliminal version so I can view your videos under my pillow during a power nap to absorb all of the good information that you put out there. A million thanks!

Great explanation of a convoluted topic! I'm looking forward to the SharePoint-only version of combo boxes.

Fantastic! Always something to learn in your Videos!! Thanks!! :D

Shane, your videos have demystified powerapps to the point where we are getting ready to finish our first pilot of using powerapps in our business! I’ve wanted to ask a non-PA question: what programs do you use to record and edit your videos?

Very helpful. Thanks Shane. Like you have explained above for single-select combobox, can you also explain how to use multiselect with combobox? We have "Item ID: and "Item Name" coming from a "Item-Master" table. We would like this to be shown in the "main-transaction-table" as a multi-select. This multi-select would show "Item Name" as value to the user. On user selecting the "Item Name", the "Item Code" gets saved into the "main-transaction-table".

Good job Shane.

Super helpful! Anxious for "part 2" as I am working with a combo selection back to SharePoint list and struggling with the update formula. Also, I was hoping for input on customize form vs. app when it comes to connecting with SharePoint data. If I am needing to manage the list and extract the data from SharePoint to feed into another reporting system would you advise to simply customize my form to meet the user need? I'm curious if per another video you did I could simply lock/change the available fields from a 'new' view vs. 'edit view' Any suggestions would be appreciated!

Hi Shane, first I'd like to thank you for the clear explanation. I do have a couple of questions for you to see if these are possibilities and how I'd go about implementing it. 1. I received feedback from a PowerApps form that the users are not happy with the typed input remaining on the screen after selecting the appropriate item (this happened to you as well @ 22:22 in your video). You have to "X" out to clear the input before you begin typing the new item. Anyway to get this removed in the ComboBox after selection? 2. Anyway to pull the user details and automatically add them as the default user? Thanks for all your help and great work!

Thanks for all these tutorials Shane. Did you ever make another video that shows combo-boxes with regards to Sharepoint lists? All I'm trying to do is set a default value. SP list field is set up as "Choice" with two options but for the life of me cannot get the form to populate a default.

Hi Shane, I am currently creating a new app in PowerApps for Teams (Datasource :Excel Online from OneDrive for Business). When wanting to insert a DropDown Control with the function: Datasource.Column it only shows me numbers (like 1,2,3,4-2000, etc in exact order) instead of the text values that are stored in this column. I then figured out, that: when changing the Items property in the ComboBox from Datasource.Column to Datasource, it works. (Because then it shows the unique identifier, which is the column that I want to show in the dropdown.) Afterwards, when wanting to search for specific items in the dropdown it doesn't work properly... Example: an item in the column is named : 2021- House. When typing in: House, it does not find any data, when typing in 2021-House then the combobox finds it...Any idea how to solve these issues? Is it maybe a Powerapps for Teams Problem? Greetings from Switzerland

Thank you Shane!

Great video Shane. Pls add mobile navigation power app tutorial.

Great, thanks a lot but where is the SharePoint video?

Shane - Thank you for your awesome videos. Did you do that Part 2 you mentioned at 1:40 focusing on Comboboxes and SharePoint?

Hi Shane I was really struggling to get the default value in the ComboBox. Thanks for the ingenious solution Can you suggest on using if in the default value Also can you please tell us on how to filter unique values in ComboBox

Awesome content as always! and good jokes hahahhaha Hello from mexico

Hi Shane. I think you miss an important aspect: How do you save data in sharepoint once you choose several records in a combo box?

Thank you for all your efforts Shane! Its like a everyday routine to watch your videos now ot learn powerapps. I have one small query, in the basic canvas phone layout i use one combobox. So, when i click on one record in BrowseScreen1, i go to DetailForm1. It shows me the respective items i had added in combobox1 for that record. But when i click on the edit button and go to EditForm1, it does not let me de-select the records i saw in DetailForm. I am not able to cancel/remove out the auto-filled items from my previous screen in Combobox in EditForm1. I can see the items from DetailForm1 in my EditForm because in DefaultSelectedItems - [Parent.Default] DisplayFields - ["Value'] DisplayMode - Edit I have manually added the Items [" ","abc","xyz"] All settings are Default. Thank you very much!

Thanks Shane for teaching about Combobox. I created an app that saves the data into a Sharepoint List. I am able to get the Combobox field to write correctly into the Sharepoint list column. However, what I want now is that when I'm editing this record, I want the Combobox to default the values as selected values. Can't seem to figure this part out.

Hi Shane,I am a beginner in power Apps and you are helping me alot.. I want to add multiple selected items from a combo box(people picker) to a collection as one (This combo box is in gallery ) and then this to a sharepoint...Is there any way

Hi Shane! Thank you for all these amazing videos. I just started learning power apps to help create structure for my business and i used a lot of your videos to build the apps. I did have a question i was hoping you can help me with on this topic. I i set an error when i start searching in my combo box when i put a filter on my combobox. (Exactly what you did in your video till 17:07) If i select the item everything works fine. But the second i try searching i get a long error message. This is the example of my formula "Filter(Table1, CategoryName = "Vodka")" Everything populates fine. The error i am getting is this: "Error when trying to retrieve data from the network: Invalid filter clause: unsupported operation. Only single 'eq', 'ne' 'contains', 'startswith' or 'endswith' is currently supported." The data is coming from an excel file located in Onedrive. Im not sure if this makes a difference or not? Any help would be greatly appreciated!

As always, great video Shane. One thing I struggle with is how to pass an ID of one table to a related new record in a related table... example; we have a client with sales order CaseID 1456 (unique is) and I need to add a record with input information that ties to that specific sales order or case... I would like to pass CaseID 1456 to the new record. How can I effectively accomplish this?

Hi shane , I have a question regarding combobox ....I have sharepoint table with product and price, and now i need to add multiple options of products and once i select those products it should filter me the price related to each product in the field . ....for example if i am selecting 3 options of products , it should show me the price of the 3 options of products selected .....can you tell me how can i do that ???It would be of a great help since I am actually struggling with that ....

Hi Shane, any tips on how I can use a combo box inside a form, but pulling data from another data source? TKS!

Thanks Shane , being a Newby to PowerApps I have learned quite a bit from your amazingly useful video tutorials. On this one about Combo boxes it seems to be done in Display Mode = 'New'. How will this behave when the mode is Edit? Will the multiple items selected populate the Combobox as it would have been when the form was saved?? Many thanks .

Really good video to help understand, even if i'm french it was easy to follow ;-) Do you have video that gives informations to transfert Selected combobox item to onedraive excel table ?

Hi Shane, great videos (the ones i've watched so far). Quite new to SharePoint Custom Forms using PowerApps, but your stuff is definitely really helpful. One thing i'd love to know - is there a way I can make a 'People Picker' field automatically enter the current users name into the dropdown when the form is opened? That would be really helpful. I've made quite a few SP lists so far to automate a lot of processes for work, and most of them should 'default' to the current user, but there should still be the option on some of them to select a different user from my organisation. Hope that makes sense!

Hi! Can you please do a video on combo box relationships? So I have 2 combo boxes, one that I would like have disabled if a certain selection is made on the first combo box, is this possible? Love the videos btw! Super helpful!!!

Shane, the property Virtualkeyboard for textbox is causing an error when it's set to 'numeric'. The numeric keyboard on my Samsung phone doesn't show the comma (,) that is the decimal separator in my language (pt-BR). The numeric keyboard only shows the dot (.) And the numbers, of course. But I have always set virtualkeyboard to text when the textbox is in FormatMode = Numeric. There's any solution for this case? I think this could be an issue for a lot of people in Brazil. Thanks in advance Shane

I have a combo box set as a people picker for Office 365, and it searches great. I would like to add and "Other" in the search list or as a selected item. There may be names outside our organization that I would like to have user type in. And I can do that if the combo box said Other. Can I add additional items to the list other than the Office365 users?

Have a problem with combobox. When selected, the size expands. After I have selected something and come out of the combobox, the screen is still expanded. The app is made and runs on a mobile phone. Wondering if there are any settings I have not performed?

Very good

Hi Shane, First of all, thanks a lot for the videos! They are very helpful. I have a issue with search in my combobox. I’m working with SP in an Excel file. I have a Lis of mobile devices with two fields, IMEI and SERIAL When I set the search to a single field, [“IMEI”] or [“SERIAL”] it works fine even [“IMEI”] being numeric. But when I set SearchFields to [“IMEI”;”SERIAL”] it searches only in the first column. When I type characters to search in SERIAL column, the search box does not return any result. Would you have any suggestion to solve this issue?

Hello Shane, Thank you for teaching me so much about PowerApps, you videos are super clear and helpful. Question for you on sorting comboboxes that displaying fields referring to what is used to be Option Sets, now called a Choice field. I am having no issues sorting combo boxes when displaying LookUp fields with the following formula Sort(Choices([@TABLE].LOOKUPFIELD), FIELDNAMETOSORTON, Ascending) However when I try to do similar for sorting Combo boxes that are looking at Choice fields, the sorting does not happen. The default Items formulae both end up with the same unsorted result Choices(TABLE) Sort(Choices(TABLE), Ascending) I imagine CDS must be storing the Choice items in a table but we cant see what the system generated field name of the Items column is in order to be able to sort on it. I thought about rebuilding my Choice list in CDS itself however I have so much data in the database I am reluctant to remove and re-add them. This also wouldn't help me if I haver to add new Choices at a later date. It also doesn't seem like the right answer, there must be a way to sort these types of fields. Please can you help me!

Hello Shane, I have a question that I'm not seeing answers to for combo box use. What about updating a record? Example: I have a powerApps app showing details of software in use in my company and there is a field of location of use. I have azure SQL with the main table and another table containing the combo box options. How would I get the existing data (csv list in text field) make the combo box show pre-selected item based on that list, then update the actual record?

I have a combobox with items to search, however, it's acting like a dropbox. There's no search for the items. How do you correct this?

Thanks Shane, your videos are really good and I have learned heaps. Do you have any videos reference for searching table records inside a gallery! 😊

Hi Shane, Is there a workaround for the 20 item limit of a managed metadata combo box? I have a termset that contains around 50 entries. I want the default selected item to display the department of the user. I have set DefaultSelectedItems to lookup the department of a user and it works if the department is one of the initial 20 terms. The departments are listed alphabetically, therefore once you get past "M" the column is left blank. The user can search all terms, which is a fallback, but it's frustrating that this will partially work.

Shane, thank you for all the helpful videos! I have learned a lot about PowerApps. I was wondering though is there a way to easily enhance the search ability for a combo box? I have a combo box that searches on 2 different fields and a lot of my results are similar so is there a way that if I just type in Apple I can get Apple at the top of the results list and anything else containing Apple ( Apple seed, Apple pie, applesauce, etc.) would be at the bottom of the search results?

Hi Shane, I find the user experience with the combo box a little sticky as you need to click on the selection then click off the form and click on the next field to continue populating a form. Is there no way to set the selection by hitting the TAB or Enter key to make the selection in the combo box and similtaneously transition to the next field in the form?

Hi legend!!! you are a genius... just keep it up... I hope you don't mind answering me a small question... I have a combo box with these items SharePointList.Title. it's showing me a delegation warning 😫😫😫😫😫😫 any idea why?

I have a question: I have a combobox in a card for a form and when I go to search (specifically when I start typing) the options disappear rather than filter them out. I am new to powerapps and not sure what to do.

Hi Shane, two things: 1) You missed a "r" in the video´s title. 2) How can I do so when I remove all the filters, all items show up?

Hi Shane. Love your videos. You mentioned a follow up video for SharePoint Lists. Just wondering if you ever did this video. I am struggling with setting a default person for my combobox. Thanks.

Well explained video. Thanks shan. Is it possible to default the selected item as logged in user,using user() function

SearchFields for multiple fields doesn't work for me. It awalys keep looking in just one field. My data is on SharePoint. I tried ["Department";"FirstName"] in SearchFields. I tried with a collection of the data as well, but doesn't work either.

Thanks a bunch for great & helpful videos! I've got an issue with combo box and SQL connection with a column with int values. No problem displaying the int values in the combo box. Until I start using an int column in the search field, then it's not valid. Every time the value is replace with some other VarChar value. How is this best solved in PowerApps? Thanks again for excellent help & knowledge!

Shane, I have Employee Name and Employee ID in List. I have used Combo box control to search the Employee Name. If I select Employee Name in Combo box, the corresponding Employee ID should be visible in Label. How do I do that. Please help.. I have searching this piece info and could find suitable result.

Hi Shane, thanks for your Video, I am trying same example using share point , for me its not working , can you help on that

Hi Shane, did something change on combobox, suddenly mines stopped working meaning its not pulling my values from excel table stored in one drive for business and shows no error. Item property : Sort(Distinct(Table_vwTravelGLs, Office),Result) and primary text only give me Result. Thank you

Hello sir thanks for the tutorials. It is very easy to understand all concepts. Can you please provide PDF about the PowerApps, Nintex, Sharepoint Framework like tutorial point.

Uhm i have a Question. I recently started working with Powerapps and ComboBoxes in particular and i just cannot figure out how to do this. Example: Jose is a Great Guy I want to be able to Input "Jose Great Guy" and still get the "Jose is a Great Guy" suggested. I have a similar way of searching in a TextInputField but the Code i use there is not working with Comboboxes in the slightest. The Logic of my Attempt: I try to Split the Search Text in one-Word-Strings and Match them all. If the Result is true for every one-Word-String the Data is shown if not it is not shown. But as i stated before i couldn´t get this to work.

What if I want to type in the items rather than using the data from data source. How can I set the default items property? Also, can I set the default selections as the selected items under a specific name? i.e. the selected items under name A. Thank you

I have cascading choice fields (multi-select) in a SharePoint list and my choices come from another SharePoint list. I'm having issues saving back to the original SharePoint list. I've been researching for what seems like months but everything I've found doesn't seem to work. The Items property of my first combobox is Sort(Distinct(SPList, Title),Result). Do you have a video that could get me pointed in the right direction?

Hi Shane, Another great video. Lots of tips in this one. Best for me: .Selected returns a value v. .SelectedItems returns a table (recordset). Question: Is there a PowerApps constant like vbCrLf in VBA that inserts a carriage return? In your example, you concatenated (CONCAT) a multi-value selection to a text string with “, “ separators. Is it possible to concatenation the .SelectedItems with a vbCrLf-like separator so that each value is displayed in the label on a separate line? If not a PowerApps constant, is there a different technique to accomplish this? Thanks! (Happy Thanksgiving (very belated). Loved your horse costume. Thanks for sharing the pic. You’re a courageous lad!)

Hi Shane, Thanks for this! I have the ComboBox set and the Label reading my multiple selection. Within the Parent Form (to get the wanted output to be written to the parent table, what do I need to write for "Update"?? This is the step in your video where you pointed the data card to your new dropdown. But since I want multiple selections.. how do I tell it to take my Label and apply these selections instead? Thanks!!

Hi Shane, I am looking for help on how to build a cascading COMBO dropdowns in the power Apps where the users can select multiple selections at each level, each depended on the various selections done in the previous dropdown.. Is there any video or material that you can guide me to? I have my source data in the Excel for these building these cascading dropdowns

Love your videos, definitely saved me hours! It seems that Comboboxes want to do a StartsWith search by default, is there anyway to have it search throughout instead? (Searches for "A-1" bring up "A-1 Contracting LLC" but searches for "Contracting" bring up nothing.) I've tried a couple things (filtering the choice list - broke the combo box, no error but no items; using search on the items - worked, but only searched the first 400 items, etc.). Do you have any suggested resources? Thanks again and keep up the good work!

Hello Shane! I'm using a List Sharepoint as a database and PowerApps for data entry and changes. It is possible to perform this insertion and changes in the List by PowerApps without allowing direct access to List, or, some routine in PowerApps that can allow this access so that only tasks are performed by PowerApps.

Combo Box allows multi select option. But I am interested only in first 2 user selections. We can concatenate all selected values and patch that to a one column. But my need is to get FIRST 2 selections only and patch that to 2 separate columns. Request you to guide me please.

Thanks for the video. Thanks to your earlier videos, I was already using Concat. Now, I am using combobox inside a gallery (repeating table). And displaying the selected items in a label and later saving/patching it. The moement I add a new row the new rows (inside the gallery) is still showing the contents of selected items from the combobox from the previous row. The selections made in the combobox are kind of sticky. When I go back to a previous row and try to edit - the section is gone, BUT the label still has it, even the collection for the Gallery has the right selections previously made. Would appreciate a view with handling combobox inside a repeating table.

Shane, how do you get the combobox to set value from one Datasource and list from another Datasource this is for the edit. this is from a SharePoint Datasource is a single line of text and on the form, it's a Combobox from a different SharePoint

Thanks for the video. Can we use combo box o filter gallery? I have tried to filter gallery two combo box and one has numeric value, it giving delegation error mentioning "Cannot evaluate formula because value being compared in the formula aren't same type"

Hi Shane, Thank you for the video it was a big help. I do have one question. The combo box i made is pulling its data from an Excel table from one drive. The Excel table has about 941 rows, but the combo box only sees to row 501. When the data table was added to the app it did put the power apps numbers for the entire table. My question is how do i get the combo box to see all the rows in the data table?

Hi Shane, I have managed to do a combo box search on a data table, however, I would like to use a text box search as well and not having any luck. So to use a value in a combo box OR a value in a text input box

Nice video, great explanation. (You've misspelled the title - PoweApps)

Hi Shane, I'm trying to use the combobox selecteditems to save on SharePoint, each item on a row, using Patch, but I'm unable to make it run perfectly, I'm using ForAll(DataBase; If(ComboBox1.SelectedItems = Title; Patch(...))) but I can't use this because it's a table, how to solve it?

Hi Shane, combo is returning multiple same values, i want it to return distinct values, items = Distinct(USER,CLIENT) is not returning the distinct values, thanks for your help

@Shane Young Having a question, How to clear the search text within the combobox after you search a text and selected the item option

!!! My combobox is showing a list of options to choose from, but all are blank. Using the textbox on the screen (as suggested) shows that data is indeed getting selected, but the combobox choices is pulling an invisible man act. I could use some help.

Hi Shane, I have a combo box that when I search it doesnt search the whole text of each field. Is there a specific thing to allow the search to do this? For example The Group tornado exchange The calvary exchange Calvary tornado exchange Tornado twister exchange If I search tornado, I would like it to return all the fields with tornado somewhere in the field name. Not just fields that start with tornado.

Hi Shane. I have been an avid fan of your videos and i have created a few apps already using your techniques. however, i stumbled upon a delegation warning issue when i am filtering a gallery where the parameter is if the logged in user is part of the list of people allowed to view the item. Here is the code i used but i am getting a delegation warning. Search('Approval Ticketing System', varUser.Email, "VA_x0020_email") The VA Email is a multiline text field i built in sharepoint but the default value is concat of the emails extracted from the multiple people picker. How do i get around the delegation warning?

Thank you!, all your videos has been very helpful, I have a question how can u use that same combox to filter a gallery, but applying that multi-selection on the filter. Right now I have this code on the Gallery Filter(IsBlank(ComboBox1.SelectedItems.Value) || IsEmpty(ComboBox1.SelectedItems) || Status.Value = ComboBox1.Selected.Value) But it only filter the las selection on the combobox

Shane, Thanks for the Video ! I have created a Canvas and used Gallery options for the questions. I have created a dropdown for the enduser to give the answers for the question, my patch function is working fine but after few seconds the answers/dropdown value is going to default value after few seconds. Instead the answer/value selected by the enduser from the drop down should remain same. How can I do this ?

Hi Shane. I anm getting a weird behaviour in combobox. While searching in a combobox some items does not appear while they are present in the sharepoint list field. I have also cheked for the search field, It was right. I am stuck. Could not figure out what went wrong. My sharepoint list contains more than 2000 items with two columns. Please Help. Thanks in advance.

Really Appreciated Shane , but you missed the below one. when a record submitted, it`s updating fine, But When edit that record every field shows submitted/selected value, but not this combo, the combo box shows empty. how can we get submitted value into this Combobox?

How to get passed the 500 limit? We need a simplified way of retrieving data after the 500th record! Shane we count on you to solve this :)

Hi Shane, Does Search in combobox work with list containing more than 8000 Records?