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

[@JeffNoel]

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 !

[@ShanesCows]

Thanks. Glad it is helping. :)

[@ehrro]

@@ShanesCows Thanks for all the help that you have brought to the community.

[@Thor_Underdunk_Caballerial]

Shane Young, the gift that keeps giving. Long live Shane Young!

[@Charango123quena]

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.

[@ShanesCows]

Glad to help. 😀

[@hemantrathod6235]

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 !!

[@ShanesCows]

Awesome. Thanks for your support.

[@tordsonander]

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!

[@ShanesCows]

Love it!!!! ❤️

[@Youffy23]

Hey Tord, I really laughed.... and I realized I am doing very much the same as you now.... Now when my colleagues are telling me "we need one Excel file", I answer "no, you need one PowerApps, 6 flows, and some collections and variables will do the work" (and even worst, I enjoy it)

[@christophmeirich5928]

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

[@FadyAnwarS]

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.

[@ShanesCows]

Very cool. Congrats

[@techienomadiso8970]

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

[@ShanesCows]

Glad I could help!

[@hudsonquay]

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")

[@ShanesCows]

Cool. I usually use LookUp in a similar way.

[@wendymason3263]

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

[@ShanesCows]

Awesome! Thank you!

[@WhatIsThis.WhyDoINeedIt]

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

[@ShanesCows]

Thanks John 😀

[@lynfinman5551]

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

[@ShanesCows]

Glad it helped!

[@magdeabdullah705]

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

[@fklatecki]

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

[@ShanesCows]

Great to hear Frank!

[@lalithkanala]

Hey @Shane, at 3:54 Once you select the item from the dropdown, is there anyway to clear the search term. Now you have to click on the X to clear it, but is there any other way where we can clear it up once you select the item

[@rubikarubi441]

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

[@TJPaterson85]

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

[@ShanesCows]

Not sure. Sorry

[@TJPaterson85]

@@ShanesCows thank you. I tried to do something else with in my IsBlank statemt that controls the combo box search

[@TJPaterson85]

@@ShanesCows I would like to thank you for all the videos as I have gone from Novice to building a semi complex app for my company within a space of two months. Shame I can not show you

[@sconsalter]

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

[@ShanesCows]

Not sure. Sorry

[@katielux357]

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!!

[@ShanesCows]

You should be able to reference the same formula form the label in the update of the card.

[@katielux357]

@@ShanesCows Thanks this worked! It seems I also had to change the column type in the SharePoint list to single line of text.. didnt work when set as a lookup

[@djstone5518]

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

[@rhcovington]

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?

[@ShanesCows]

Put the names in a collection first then you can append the collection with additional values.

[@rakikuruba8651]

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 ?

[@ShanesCows]

Set the DefaultSelectedItems property of the combobox to the value you just patched.

[@robertsawyer5872]

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.

[@ShanesCows]

Not sure Robert. I have never ran into that or used the MM column in Power Apps

[@VagnerKogikoskiJunior]

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

[@ShanesCows]

It should just work. What are you having issues with

[@joshuaharlow1275]

Hey Shane, I was wondering if you knew how to have the combo box be populated from another field? I'm trying to get the attachment field to populate the combo box when an attachment is added.

[@ShanesCows]

You have to find a way to filter the items from the Dropdown by the value of the attachment controls. Probably possible but not simple.

[@MsFrostb]

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!

[@ShanesCows]

I need to do part 2. Combo box is annoying for sure.

[@teaners26]

@@ShanesCows Looking forward to this also!! I cannot get my app to share back anything but the last selection made (they are 365 users) back to SharePoint. Its frustrating!

[@papithasekar9567]

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"

[@ShanesCows]

Should be possible. Sounds like maybe you are trying to compare text to number?

[@danielrumbak2530]

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?

[@ShanesCows]

Combobox is a bit annoying in how it works. 😒

[@vinodprasanth6106]

Shane, Thanks for this video. One question on combobox, how to display two table values when i click on combobox? say for example, in the opportunity combobox lookup, i have opportunity name displayed already but how to show account name as well? i used concat but only getting the account guid and not display name of the account. thanks Shane.

[@bobvonilten2874]

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?

[@ShanesCows]

You need to put something that returns the record in DefaultSelectedItems.

[@perthsteve5032]

Hi Shane, I just cannot get the DefaultSelectedItems to do what I want it to do... I have a combo box connected to a sharepoint managed metadata column called "site" (a managed list of specific site name identifiers). Using the combo box to find the site name works fine, however... What I'd like to do is have a scannable QR code at those sites with the parameter embedded in the URL, which is then passed to the combo box as the default item. I can get this to work fine for a drop-down box... but I cannot get my parameter variable "varSite" to populate the combo box. I've tried the filter, but it didn't work. I have a test label (as you suggested for troubleshooting) which shows the parameter is collected as "varSite" and displays as expected.

[@perthsteve5032]

Hmm there's more to this problem with combo boxes - I managed to populate the field with my URL using "DefaultSelectedItems = First([varSite])" but this doesn't seem to translate to an actual selection in that combo box. The form won't let me submit even though I know the text in the box matches the metadata Label field. I also got it to work using "DefaultSelectedItems = Filter(Choices(SiteLog.'Site').Label,varSite in Label)" but only with a handful of Labels. It seems the Filter function only returns about 20 of the available term set (which contains about 700 items), so if the URL parameter contains one of those 20 then it will work, but otherwise it will not.

[@ShanesCows]

Glad you got it working.

[@perthsteve5032]

@@ShanesCows I didn’t really! But I think what I discovered is that it’s a limitation of the current powerapps release. I just don’t know any other way to have a searchable managed list data that can have default selected items from URL?

[@kearley8792]

!!! 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.

[@givanildosilvadeamorim326]

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.

[@ShanesCows]

Try this video on how to change the permission in SharePoint. kzbin.info/www/bejne/lYLRq2ePmq2mm9U

[@givanildosilvadeamorim326]

@@ShanesCows Hi Shane! Once again, thank you very much for your cooperation and attention.

[@ericyungfleisch801]

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?

[@ShanesCows]

Not sure you can. You can try increasing the delegation limit and see if it helps. Do you really want your users to browse 1000 items?

[@_guzheng7585]

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

[@ShanesCows]

[“a”,”b”,”c”] in items should work.

[@_guzheng7585]

Thank you so much for your response. I have "a", "b","c" in items, but when I want to edit it, the records won't be selected as default. Just like you said in the video, I should not need to re-select everthing again when I edit. For example: In my entry, company A has "Item A", "Item B". If I want to add "Item C " to the entry, I should only need to select "Item C" in the combobox on the Editing page. "Item A" and "Item B" should be selected as default in the combobox. I think the logic should be : Name = Company Name, combobox select items = items in the record of the company.

[@_guzheng7585]

However, I don't know how should I transfer the logic into the coding 😞

[@gouthamreddykotha1767]

How to auto populate combobox values based on another combobox selected value. Please help me. I have two lookup fields.for example, If we select A in lookup1 then lookup2 should auto populate whith apple which is one of the option in lookup 2 .

[@jeffteeter7502]

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.

[@ShanesCows]

Thanks for sharing 🐶

[@craighalstead680]

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.

[@sachin1905]

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

[@ShanesCows]

Replies to other comment

[@alamzukhodabukus3838]

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

[@ShanesCows]

Distinct should. What are you seeing when you use that for Items?

[@alamzukhodabukus3838]

@@ShanesCows got it man, there was a space in one of the client name, its why it was appearing twice, thanks again

[@michelhegeraat5430]

Hi Shane, thank you for this video. I notice I can include the picture of the person in the combo-box when using the person layout. But only when I point the items to a SharePoint person field! Do you know how to get this functionality in the combo-box when using e.g. O365.SearchUser? The image and picture options are grayed out when I change the items data source. :-/ I know I can use a gallery but I want to understand why it work on a SharePoint but not on O365.SearchUser

[@ShanesCows]

I am not sure. I have noticed the same

[@michelhegeraat5430]

@@ShanesCows Glad it is not just me seeing this. :-) But still strange as both sources give the picture when you use a gallery.

[@fabi2816]

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.

[@ShanesCows]

Yikes. I haven’t tried that before. 😀

[@Sebask15]

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

[@chillndill]

Shane, you are amazing. Keep going please please!

[@ShanesCows]

Will do. This video might be helpful, some more details after the one you just watched. kzbin.info/www/bejne/d4mkk6Cvbt-Mirc

[@mukeshsomvanshi6657]

hey hi shane, i have a question in that i have single column to search and multiple records to be selected. to save multiple record i have used concat(). but when i want to show default values which are stored in database i want back to combobox as selected.

[@ShanesCows]

Have to come up with a way to turn the text back into a table. Maybe Split function 😀

[@mukeshsomvanshi6657]

@@ShanesCows Thank you Shane. sorry for bothering you It solved...it was my power apps that was showing an error....once i restarted Powerapp it worked fine as mentioned in ur video 👍👍👍

[@mukeshsomvanshi6657]

@@ShanesCows Thank you Man, really appreciate your Hard work 🙌🙌

[@kathymurphy6625]

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?

[@ShanesCows]

Did you see this video? kzbin.info/www/bejne/naTOYmd6YqiMiKc It talks about those complex column types.

[@omtschand3432]

Hos can i concatenate and display valves already in sharepoint list & values selected in current edit form before it is saved.

[@ShanesCows]

Use LookUp to get the current data out of SHarePoint.

[@omtschand3432]

@@ShanesCows thank you Worked for me

[@nizamahmed9599]

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.

[@ShanesCows]

Make sure the default property is set properly for the control is my first guess

[@nizamahmed9599]

@@ShanesCows I changed the design. I update the list of selected issues from combobox after Save is clicked. And patched the list in the collection after "Save" or "Update". It works fine. By the way, this was a daily timesheet app I made for my team, completely based on what I learned from your videos. Thanks a lot for explaining the nitty-gritty of all the topics you pick. I am not a programmer. I used to do my staffs in Excel. Now i do them in PowerApps - thanks to you.

[@frodesellevoll]

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?

[@ShanesCows]

Not that I know of. Never seen that before.

[@phamvanhoang2907]

I have Dynamic combobox that list content of column from column name. After i select any item of combobox. I and not able to get selected value of combobox to text

[@ShanesCows]

Sorry, I am not sure why. I have another video about combo boxes that might help kzbin.info/www/bejne/d4mkk6Cvbt-Mirc

[@asimrehan73]

Hi Shane, please help … Any idea how to filter people picker…. Like show only people from certain department ?

[@thorsteneybe6223]

I can not get the combobox items to update, the SelectedItems throw an error that it has to be a data entity record. What do I have to write in Update to get the selected items saved to CDS?

[@ShanesCows]

What is your items property for the combobox and what is the field type that you are trying to update in CDs? Leave a new comment not a reply with this info and I can try to help

[@mknaresh]

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

[@ShanesCows]

What isn’t working. Maybe post a new comment with more details and I can try

[@laccco1990]

Hi Shane, I have a table1 which contains a lookup column from table2. I want to choose the lookup column as primary text and seach field but it does not show the lookup field as option. Is there a way to get past this? I prefer to not use the original table1 since I also want to filter on values in table2.

[@17avskadoo]

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.

[@sheosanjaykumarsingh7440]

Hi Shane, can we get people names in combobox( in powerApps form) from another sharepoint list where people names are stored?

[@ShanesCows]

Maybe look here for an idea kzbin.info/www/bejne/amTInJ1rgtGBgLc

[@Oopsiedaisy861]

Hello Shane! Question for you -- I'm trying to create a form that includes a multiselect combo box which will create multiple records with all of the same information in the other fields, but with a new line for each item selected in the combo box. I'm having a tough time even getting started with trying to pull each selected item out of the combo box into a Label for display. This is what I currently have, and it is not displaying anything in the label: Concat(TSO_ComboBox.SelectedItems, TSO_ComboBox.Selected.Value, ", ") Ultimately, can you give me some guidance on how I would implement the rest? I figure I would do a ForAll on the items in the Combo Box and then do a patch to grab all of the other values in the form and then the current item in the loop? Thanks for making this content it's all very helpful to understand PowerApps.

[@ShanesCows]

Yeah ForAll sound like what you need. Remember Combobox.selecteditems is a table you feed into ForAll

[@elliotcarter9693]

Hey! I'm having trouble changing the text colour of NoSelectionText and InputTextPlaceholder. Is there any way to code the colour value within the same field where I find the NoSelectionText for example?

[@ShanesCows]

I don’t think you can distinguish color between the two. 🤔

[@elliotcarter9693]

@@ShanesCows Do you mean that i cant make them separate values from each other or that i cant change them at all? BR Elliot :)

[@josemariasomozagarcia1614]

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?

[@ShanesCows]

Leave a new comment with your whole formula so I can see it.

[@anu1krishna]

Hello , I have a question that my combo box shows data correct but I have it in gallery control and I am saving that data in a collection . That also works fine but as soon as I save and control changed to view mode , it lost its value, would you please help me what am I doing wrong?

[@scarletkurenei]

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?

[@ShanesCows]

The search function is never delegable to SharePoint. :(

[@iainscott-brown2411]

Shane I have used a combo as l need its functionality. I have disabled the multiple selection. When I use the browse screen the combo box is empty. I have tried This Item. As default but scope not supported. Any pointers?

[@ShanesCows]

You have to use DefaultSelectedItems. Default doesn't work :(

[@iainscott-brown2411]

Shane Young thanks I did dirty fix as I call them. When in edit view I sit an non visible text box over the top of the combo box and when in view mode the visibilities are swapped over. It worked!

[@robertoorellana38]

hi, how do I filter a combobox to show me only values that are not already stored in another table?

[@ShanesCows]

Try this kzbin.info/www/bejne/b5WWg2Zpa95goJo

[@toddmartin763]

Shane, I'm looking to place data from a collection to a combobox. Arrrrgggghhhh!!!! Is that in a different video.... I need a KZbin 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!

[@ShanesCows]

A collection is valid for a combo box items? What isn’t working?

[@noahsmith518]

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

[@ShanesCows]

You're so welcome!

[@ruthannvaldivia291]

Hi, Shane, I changed a field from a standard lookup table to defined metadata and now my comboboxes are not working. the field "category" is showing up as a table. When I try to do the concat, and filter, etc as you have shown, nothing is working. Could this be a limitation with using metadata?

[@ShanesCows]

Not sure. I have not tried to use a managed metadata column. I should

[@NathanielGonzalez7]

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!

[@jmrewa]

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.

[@ShanesCows]

I haven’t but I’d I remember tomorrow I will grab the syntax for you.

[@evenblindern9300]

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!

[@ShanesCows]

Search only works on string fields 😑

[@evenblindern9300]

@@ShanesCows Thanks for your kind reply. Sorry to see this is an issue. I have made a short term fix with an input field, The user inserts the numbers as text. Below I created a list for all the valid numbers from a SQL view. The list will filter the input while the user is typing the number (using StartsWith). It looks A-ok. The issue here is large data sets. Doh. For a permanent solution I believe I will have to make a new TSQL View where the number is VarChar. Then the ComboBox may do as it is supposed to. Eternal gratefull for your demo & input! It really makes a major difference. Best regards; Hal.

[@PranjitTech]

Hey Shane. How filter gallery record using two multiselect combobox in powerapp. The both field is multiselect checkboxes in SharePoint list.

[@ShanesCows]

That is a complex one. You have to use the Concat function and the in operator. One of these days I need to do a video on that.

[@PranjitTech]

I know Shane this is complex. I used both concatenation with in operator it work with one combobox when we combine both combobox with and operator the expected results not getting. Please do video on that as soon as possible. Thanks

[@ghuerren]

HI @Shane! Tx for the great video. Im using the combo box mostly for its inline search capability. The user can select only one value at once in my app. But i can't get the combobox to load the store value when editing a record. it always comes blank. Tried to use the code: If(EditForm1_9.Mode = FormMode.Edit, Dropdown6.SelectedText.Value, "") in the default value. but it didn't solve the problem. any guesses? ts a lot!

[@ShanesCows]

Your DefaultSelectedItems has to be set to a lookup or filter. You cannot pass it text.

[@ghuerren]

Shane Young thanks!

[@danieldickinson147]

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

[@ShanesCows]

I go deeper into DefaultSelectedItems in this video. Maybe it will help you have that light bulb moment. kzbin.info/www/bejne/d4mkk6Cvbt-Mirc

[@mikelomax4509]

I also watched your video on DropDowns and decided to go with ComboBoxes for the search feature. From the Dropdown video I was also interested in Disabling ComboBoxes and found that works here as well. The idea is that the user selects a value for the first ComboBox and then the second ComboBox moves from Disabled to Edit. After the second ComboBox has a value, the third Combobox becomes editable, etc. That works great when you first access the App. To clear all the fields, I setup a Reset Button. When pressed I have it doing a Reset of each ComboBox. The values are removed but the ComboBoxes don't move back to Disabled, like when we first accessed the App. I did try this same design with Dropdown boxes and the Reset button moves the Dropdown boxes to Disabled. Just doesn't work for the ComboBoxes. Any ideas on how to make this work?

[@mikelomax4509]

Ahhhh... Let me change a little of what I said. When you come into the app fresh, the ComboBoxes reflect the Edit/Disabled state they were in when in last. Actually the only way I have found to get them back to their DisplayMode Disabled setting is to select value for all the fields and then, starting at the last field, back out deselecting the value in the previous Combo Box. I should add as well, that the last field is not a ComboBox but rather is a TextInput and it is behaving the same way. Does not Disable on Reset.

[@ShanesCows]

Interesting I haven’t ran into this. I will have to look into it a bit b

[@hongwuu1216]

Hi Shane, the barcode scan info can send into combo box? how can I do it?

[@ShanesCows]

YOu need to set the DefaultSelectedItems property of the combobox. kzbin.info/www/bejne/d4mkk6Cvbt-Mirc You can use the scan info as part of your formula there. :)

[@sushilbansode5166]

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

[@ShanesCows]

Depends on the data source. SharePoint? No.

[@hudsonquay]

Would this technique work for displaying managed metadata terms from a list in a text box within a gallery? I get the same error message about PowerApps expecting text values but table values supplied.

[@ShanesCows]

Not sure. Never tried Managed Metadata. Sorry.

[@marjoriefialek9160]

Shane - How do I write back to the sharepoint list from a combo box? Everything I try doesn't seem to work. Any help is appreciated!

[@ShanesCows]

This video kzbin.info/www/bejne/naTOYmd6YqiMiKc

[@emmanuelmaceda2475]

Hi Shane! Great Vid! I wanted to use the combobox for a column with over 1000 rows, not multi-select but allows search. I set the Items property to filter combined with the StartsWith function so that as a user types text in the search field, a value is returned. I don't encounter a delegation warning but the data returned is always limited to 500 rows. I've tried to connect directly to my data source as well as try a collection to no avail. I'm guessing my Items property formula is wrong? Or is it a limitation of comboboxes and I should just use text input as search? Thanks for your vids and sharing your knowledge!

[@ShanesCows]

Emmanuel last time I had to do something like that I found it was easier to use a gallery to select the item instead of a combobox. That got rid of all of my issues. The combo box is... picky about how it works. Galleries are much more polite.

[@BegeNCSU]

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?

[@ShanesCows]

Camtasia. Amazing stuff. Highly recommend.

[@vikasumapathy5056]

Hi Shane! Could you please advise how can we include a select all option for the combo box items? i.e When I click select all check box all the items in combo box gets selected.

[@ShanesCows]

I don't know how to do that. :(

[@jeffreycjose]

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".

[@ShanesCows]

With a multi-select combo box you need to use Concat function to get the data out of combobox.SelectedItems which is a table.

[@anjalikapartiwar6808]

I have a SharePoint list containing 50,000 items with one of the column is Lookup ie. "Area". I need to retrieve items with an ID between 1 to 50000 based on the OnChange property of a multi-select ComboBox (Area column values are given in Item property) in Power Apps. But I don't want to use Collection for 50000 SP List items. How can I accomplish this?

[@agentedecompra]

Hello Shane, I am trying to use a combobox to filter a gallery, the combobox items are from the ID data in a SharePoint list. I am using nameofmydatasource.ID as my item's property, but when I preview the app the combobox does not have any items to select and I am not getting an error sign from PowerApps. I image it's something simple, but I dont know what else to try. Thank you very much in advance, any help is appreciated.

[@ShanesCows]

This should help. kzbin.info/www/bejne/d4mkk6Cvbt-Mirc

[@manuelarriaga6266]

Once I submit the form there is no hyperlink on Sharepoint browser to the previous lists as we have with Sharepoint standard "Lookup (information already on this site)". Can we do this?

[@ShanesCows]

Sure add a button with Launch and the SharePoint url

[@nanmajoseph6392]

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 ....

[@ShanesCows]

I think you are asking for cascading dropdowns? I show them here kzbin.info/www/bejne/iXywqJSvm8SWq68 I am using a dropdown not combobox but the cascade part would be the same.

[@alyssonfilipe2049]

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?

[@ShanesCows]

ForAll(Comobox1.SelectedItems, Patch(database, ....) I think you just have your thinking backwards.

[@judbaldock6733]

Great video. One question--I'm using a combo to list vendors in order to submit a PO. If a vendor does not exist in the current SP list (thus, no combobox.selected.item) how can I pass the text entered into the combo box to the vendor datacardvalue field of my form?

[@ShanesCows]

YOu cannot. :( YOu would have to come up with a separate control for adding a new value.

[@leferhashi]

@@ShanesCows Could you work on this item in the next video? I have the same problem

[@DavideGalloni]

Hi Shane, thanks for another Top Video! Just a question: I use a ComboBox called cmbSuppliers linked to a sharepoint list called "Suppliers" that contains a single field called SupplierName. The value selected on this combobox is stored into another sharepoint list called "MainTable". If I create the record for the first time, the value selected in ComboBox is successfully strored into field of my maintable, but when I recall the record from my maintable, I can see the text in my combobox but I cannot use that value because the value of "cmbSuppliers.selected.supplier" is empty. If I try to select another supplier from the combobox, the value of "cmbSuppliers.selected.supplier" succesfully change. Where am I doing wrong?? Thanks in advance and hope the problem il clear.

[@ShanesCows]

I think you need to revisit your logic for DefaultSelectedItems to account for both scenarios

[@DavideGalloni]

@@ShanesCows I did it. I fill into DefaultSelectedItems the string: "Filter(Suppliers; Supplier = Parent.Default)" and seems that work properly but.... when I open the form in View mode, sometimes some combobox does not display his value. If I change form mode from view to edit, the value in combobox appears. I saw that a combobox has the "reset" property but I don't know how can be used.

[@mtamitolanga]

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

[@ShanesCows]

Distinct returns a single column table called Result. That is why. Try it without distinct and you will get all the records.

[@ptchow1]

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.

[@ShanesCows]

If it is multiple values I think you need to use concat to make them a comma separated list.

[@ShanesCows]

Concat is the key.

[@dreamweaver9962]

Hi Peter do you get a solution for this?

[@ptchow1]

@@dreamweaver9962 Yes. For writing, I did use CONCAT. When reading back, this was the formula for DefaultSelectedItems property: Filter(., in Filter(Split(Parent.Default,", "), Result in .))

[@dreamweaver9962]

@@ptchow1 Thanks mate :) That did the magic. (y)

[@Shastri53]

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 .

[@ShanesCows]

Yes, you will need to get the DefaultSelectedItems property set correctly to your table but then it will work as you want.

[@amandapenicks1186]

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?

[@ShanesCows]

There is a property for the combobox called IsSearchable set it to true

[@sconsalter]

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.

[@ShanesCows]

Interesting it is never not worked for me unless one of those is not a text column l?

[@julireid9574]

Shouldn't that be a comma between "Department" and "FirstName"? It looks like you have a semi-colon there, could that be your issue?

[@imanebenhaddou5609]

Hi Shane ! Thanks a lot for the video. I have one question about the default value in the combobox. In your video you just write a text, but currently I'm working on an app and when I add a text variable in the default (or any text) it doesn't accept it, apparently a record is needed. How can I do to convert my text variable into a record ? Do you have any idea ? Thanks a lot !

[@ShanesCows]

Depends on your data set and what is the column name {columnName: “Chewy”}

[@kmuralikrishna1582]

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?

[@ShanesCows]

Comboboxes show you the table of data from their items property. So you would need to work on getting the correct formula in the items property.

[@piyushlamba1134]

Thank you Shane for another amazing video, but I am struggling with setting the default values as per the text box you have added. When you edit any item it should show already selected items, I tried Split function but no luck...any help on that please

[@ShanesCows]

Concentrate on getting your record that matches the items of the combobox

[@hemantrathod6235]

Hi Shane, I have a combo-box based on sharepoint list, that list has 2233 records, When I search for the project number it does not show project number in the filtered results, when I change the source from sharepoint to excel with same rows (2233) and I search for the project number it does show up in the combo-box results. (so for example when I search for project number 18400, it shows in combobox when source is excel file but does not show when I change source to sharepoint), Any suggestion please ?

[@ShanesCows]

Delegation is the issue 😐 kzbin.info/www/bejne/i5KlnomLht2SfM0

[@hemantrathod6235]

@@ShanesCows thank you Shane :) i used Title instead of column name sort(tablename, Title, ascending) and it worked. Your powerapps videos are Powerapps-bible for me :) Thank you again :)

[@hemantrathod6235]

@@ShanesCows Thank you Shane for reply (I got your mean look for the yellow triangle lol) , I created couple of collections and then created final collection by fetching data from col1 and col2 and it worked :)

[@MeisterCrashFM]

Hi Shane, thanks for this great video. I have some trouble with my combobox, i want to use that as a "advanced lookupfield" at a sharepoint list, but I can't search for more than one colume. When I type ["abc","dfg"] in searchfields he search only for the first colume. I try also to set this field with this "ComboBox1.SearchText = ["abc","dfg"]" without any result. Could you help me?

[@ShanesCows]

Are both text fields and are you using the system name of both? If you only do 1 at a time do both work? This is how you should start troubleshooting it.

[@MeisterCrashFM]

@@ShanesCows Thanks for the answer. Yes they are the system name of both. I have 5 different colums and all of them are searchable, if I only use one. On Microsoft help they told me this function: ComboBox1.SearchText = ["MyFirstColumn", "MySecondColumn"] but it also doesn't work. I can't understand why. I use for items=ShowColumns(Test_abc,"abc","def") cause i have much more than 2000 items. I tried also the Filter function, but its the same problem. Displayfields=["abc","def"], searchfields same.

[@bryanchaves2677]

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?

[@ShanesCows]

Just reference the datasource directly

[@kearneyfoss1084]

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?

[@ShanesCows]

Nope. 😢 I got nothing

[@developersharepoint6658]

Hi I have a sharepoint list that has Plant (single line text) and PlantHead (Single person)... In my powerapp I want to show the PlantHead(auto populated) based on the selected Plant (Plant - dropdown control). How to do that?

[@ShanesCows]

I did a video on Sharepoint lookup columns. In that video I show exactly that. 😀

[@developersharepoint6658]

@@ShanesCows can you share the link?