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

[@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)

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

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

[@christophmeirich5928]

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

[@WhatIsThis.WhyDoINeedIt]

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

[@ShanesCows]

Thanks John 😀

[@wendymason3263]

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

[@ShanesCows]

Awesome! Thank you!

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

[@fklatecki]

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

[@ShanesCows]

Great to hear Frank!

[@magdeabdullah705]

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

[@lynfinman5551]

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

[@ShanesCows]

Glad it helped!

[@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

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

[@noahsmith518]

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

[@ShanesCows]

You're so welcome!

[@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. 😀

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

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

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

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

[@bunburygaston]

Thank you very much! greetings from Argentina

[@ShanesCows]

Thanks from the US. 🐶

[@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

[@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. 😒

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

[@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?

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

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

[@erickboczar678]

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

[@ShanesCows]

Happy to help. Have a great day. 🐶

[@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)

[@AlbertoAcero]

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?

[@ShanesCows]

I made a whole video just for that. kzbin.info/www/bejne/naTOYmd6YqiMiKc 🤩

[@AlbertoAcero]

@@ShanesCows THANKS!!!! Great

[@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?

[@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

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

[@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

[@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

[@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

[@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

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

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

[@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

[@tvenkatesh81]

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.

[@ShanesCows]

Combobox.Selected.Columnname should work.

[@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

[@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

[@raouleliasmiraglia148]

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

[@raouleliasmiraglia148]

*the excel list has 200 records, not 2000

[@ShanesCows]

I am not sure. I read this a couple of times and I just don’t have anything helpful to add. 🤔

[@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 :)

[@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

[@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?

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

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

[@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

[@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?

[@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

[@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

[@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

[@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 :)

[@galalabouelella9572]

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

[@ShanesCows]

Sorry, but I don't what SharePoint video you mean? Please leave another comment and I will help you find it.

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

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

[@mukeshgarg3283]

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.

[@ShanesCows]

That is the problem. Delegation

[@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

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

[@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?

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

[@_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 😞

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

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

[@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. :(

[@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 🙌🙌

[@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

[@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

[@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?

[@miiihaaas]

I use data source with columns [RN], [Naziv], ... etc. I made combobox: Primary text: RN, Secundary text: Naziv, SearchFeald: RN. when I try to search in combobox existing data, I end up with empty list... do you have any hint what to do?

[@ShanesCows]

No. That sound right. Hmmm

[@miiihaaas]

@@ShanesCows, why I can't search? When I put in items TableName.RN, it is searchable - but then I can't use other columns data (Naziv,... Etc) because data is filtered on RN column...

[@miiihaaas]

Also, there is no secundary text because now we are dealing with one column filtered table...

[@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

[@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

[@Mromartorresmoreno]

Hi Shane, I have one question related to the use of the property "On Change" of a Combobox that is part of an edit form. When I try to save the selection made in the Combobox in a variable (initialized in the property "on change") as follows "Set(_proyecto;JSON(Self.Selected.'projectName'))" the value of the variable doesn't change after selecting an option of the combo box. But when I make it with a Combobox that is outside of the form, it works. Can you help me, please?

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

[@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

[@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”}

[@marie-louisemarshall9618]

This has really helped me, but I still have an issue. I have a detail browse screen, that has an edit button, when I take the edit, I open the new screen and I bring through the items from the detail browse - I can populate all the fields from the browse screen except for my COMBOBOX - I know I put something the DefaultItemsSelected field, but I cannot figure it out - Can you suggest some help please

[@ShanesCows]

You have to return a table or record from the same datasource as your items property. So craft a filter or lookup is usually the answer.

[@marie-louisemarshall9618]

@@ShanesCows Am I correct to assume in the DefaultItemsSelected Field?

[@raphybouss]

hey Shane I have a question : I would like to configure the searchtext value in a combobox. If the combobox reset that I call comboreset is true then searchtext is blank but I don't know how to configure the searchtext.. any ideas ?

[@ShanesCows]

Have you tried the reset function?

[@raphybouss]

@@ShanesCows yes not working for combobox

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

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

[@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 🐶

[@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

[@djstone5518]

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

[@naveench3194]

Thanks for the video. i have a question for you. I have implementd combo box similarly, but required field validation is not working. Can you please help me on this.

[@ShanesCows]

Leave a new comment with your challenge?

[@giuseppe8630]

Excellent video! however i'm having one issue. When using a combo box on my powerapps form which saves the data onto a SharePoint list... the items i selected in the combo box do not appear when i go back into the form however the data appears on the SharePoint list (just not in my form).

[@ShanesCows]

Check your defaultselecteditems property

[@giuseppe8630]

Thanks Shane, I really appreciate your response. Do you know what formula I need to enter into the 'DefaultSelectedItems' I'm quite new to PowerApps and I feel like I've tried everything :( The data source for the combo box is pulled from an excel spreadsheet called 'Colours' from a column named 'Colour Name'. On SharePoint the user selects the 'Colour Name' from the combo box which sends the data to the SharePoint List, however when going back into the same item, it doesn't show the Colour Name that was selected. Thanks and sorry for the long message.

[@kapilg89]

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

[@joywhiting3616]

Thanks Shane! I am successfully passing a comma separated list to a SharePoint list, but now I want to be able to select an entry and edit the values in the combo box. If I had a dropdown, I'd just set the Default to If(EditForm1.Mode = FormMode.Edit, Parent.Default," "), but naturally this doesn't work with comma separated text being passed back to a combobox. What would you do in a situation like this?

[@ShanesCows]

Hey Joy. You have to return records in the DefaultSelectedItems property. So you will need to filter against the items property. another topic for another video. Email me if you don't get it and I will share some formulas.

[@mrbushmills]

@@ShanesCows Hi, I am struggling too with this default topic. Can you send me the suggested formulas? My email is: [e-mail]. Thank you.

[@ziadhamandi3595]

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?

[@ShanesCows]

Combobox.selected.id should be the value?

[@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

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

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

[@sushilbansode5166]

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

[@ShanesCows]

Depends on the data source. SharePoint? No.

[@channyeinttha1641]

Hello Shane, I'd like to ask you one question about combo box. I created Department list in SharePoint and it has DepartmentHead person field. The problem I got is that cannot fetch Department Head person field to combo box in PowerApps. I used DepartmentList.DepartmentHead in combo box items. In combo box Display fields, I changed to ["DisplayName","Department"] but combo box showing blank. :(

[@ShanesCows]

Not sure. I don’t have it in front of me to try. Combo boxes are hard.

[@channyeinttha1641]

Shane Young Anyway Thank you Shane.

[@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

[@marcuskarlsson8317]

Hi I'm greatfull for all your videos, but as soon you think you are just seconds away from getting it, new issues come up. I Just Cant get my combobox to search three fields Searchfields = ["Fordons-ID";"Radionr";"Internnummer"] but Seearch just hits on the first value, the work one by one but not combined.

[@ShanesCows]

Yeah I don’t think combobox can do that. 😑

[@marcuskarlsson8317]

Thats sad sad but somewher you have to make your limitations. I just thought you had 3 search fields in your video.

[@marcuskarlsson8317]

Does anyone knows if you could use if statements for searchfields. I habe a radio control wixh I want to hav differnet searchfields in i combibox. Something lile this if( isblank(radio1.selecred.value);["car"];if(radio1.selected.value;["car;inventory"];["car;communikation"))) But it fails to search

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

[@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?