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

[@christophmeirich5928]

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

[@fathimasamrinp2743]

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

[@ShanesCows]

This video has some ideas. kzbin.info/www/bejne/naTOYmd6YqiMiKc

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

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

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

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

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

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

[@noahsmith518]

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

[@ShanesCows]

That is weird, I have never seen that before. Hmmm

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

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

[@sushilbansode5166]

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

[@ShanesCows]

Depends on the data source. SharePoint? No.

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

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

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

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

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

[@erickboczar678]

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

[@ShanesCows]

Happy to help. Have a great day. 🐶

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

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

[@bhanuprakash1416]

How to avoid allowing duplicate selection in ComboBox powerapps in edit item

[@ShanesCows]

I talk about Duplicates in this video kzbin.info/www/bejne/d6GWkHiXbq1rmJI

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

[@karlajoselynmunozsilos5907]

Hello, why I can't use parent.defaul in a combo box?

[@ShanesCows]

Because combobox doesn’t have a parent. Only galleries and forms

[@slayermago8146]

How can I filter a combobox according to the selection in another combobox?

[@ShanesCows]

Try this concept kzbin.info/www/bejne/ppy9eGWYpLNqoLM

[@johanynavarro8065]

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

[@ShanesCows]

You have IsSearchable set to true. The search function is never delegable with SharePoint so boo. Turn off search and the issue will go away.

[@johanynavarro8065]

@@ShanesCows 🤩🤩as I wrote you are a genius... another question 🙄 after a simple Patch() function Power Apps takes about 10 seconds to navigate to the screen and checking the Monitor I got more than 4k rows I 've been trying to fix it however no idea even what can be the issue

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

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

[@blaschkesita]

Combobox is driving me crazy, I don't know how many times I have modified the "fields" and they always back to the "default" values, is there anything I can do? Display Mode and Search properties also go back to whatever it considers are the right values. It seems there is an elf on my laptop... any suggestions?

[@ShanesCows]

That is why Combobox is so annoying. 😎 If it will not take your fields there is usually a reason, maybe complex fields?

[@blaschkesita]

@@ShanesCows I took your comment very seriously. I did a view (SQL) with just the two columns related to the combobox... it starts working since then... Thanks... big fan of your work :)

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

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

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

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

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

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

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

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

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

[@franknielsen3219]

YOU ROCK!!!!!!!!

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

[@wendymason3263]

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

[@ShanesCows]

Awesome! Thank you!

[@jjayceeb]

how to search 2 items with distinct .. i use search(distinct(datasource,items),item1,item2)) but shows error

[@ShanesCows]

Distinct only return one column called Result. There isn’t 2 columns to search.

[@jjayceeb]

@@ShanesCows do we have other option? As we need to get 2 columns.

[@fabianvillegas6313]

Thank for you brilliant explication!!

[@ShanesCows]

You're very welcome!

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

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

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

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

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

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

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

[@matthewgilbert8273]

Great video, but could do without all the adds cutting in

[@ShanesCows]

We are looking at a paid option that would have no ads. Check out www.powerapps911.com or email me for more information.

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

[@LapaConsult_Ex_Macraris]

Great Shane! I was able to follow through by installing a sample SalesLT DB on Azure. How do I make it possible to manually insert a value that I want to enter once but do not want to have in the source for the ComboBox? Any clues on Why Reset(Combobox) work on a pc and not on Android mobile?

[@ShanesCows]

If you want to add an option to the combo box you need to create functionality to update the data source for the combo box. Sorry. No magic tricks. here. :(

[@Paterson31]

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

[@Paterson31]

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

[@Paterson31]

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

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

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

[@sundarun]

Hi Shane, How do I search part of a string in a dropdown for a SharePoint look-up column that looks up another SharePoint list within the site? Thanks in advance

[@ShanesCows]

Column.Value is what you are searching. Probably going to run into delegation issues though. Why not just search the list directly instead of the lookup column

[@sundarun]

@@ShanesCows Hi Shane, I have not phrased my request properly. My apologies. I have a couple of look up columns in my SP list. Those columns lookup to another SP list in the same site. In my PowerApp, I want my user to select a value from the dropdown / combobox* by entering some text that may be contained within anywhere in the lookup list items. Currently when the user types in a few characters the list gets shortlisted, however it shortlists only from the starting set of characters. Is there a way I can facilitate typing in a set of characters that may be anywhere in the choice values? *Note:I am not sure, what Powerapp created by default, when I designed the form from within SharePoint list

[@julireid9574]

@@sundarun You would need to filter with the 'in' such as Filter(ABC, TextInputSearchBox.Text in XYZ) I seems like you are using StartsWith.

[@djstone5518]

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

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

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

[@Flick2025]

"But as that terrible movie quote that's used all the time" TERRIBLE? I can't believe my ears... BUT MOVIE QUOTE?!

[@ShanesCows]

😂

[@TheMariesoleillaport]

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

[@ShanesCows]

This is the closest thing that I have. I hope it helps. kzbin.info/www/bejne/n57Lqaxph6qajsU

[@hanapatros6996]

how to get distinct data in a combobox ?

[@ShanesCows]

Distinct function kzbin.info/www/bejne/jJ_ElX6NnsueqJo

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

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

[@lauramay1494]

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

[@ShanesCows]

I would try putting your choices in a collection. This will let you see how the data is structured. Then you can figure out sorting. Then the same logic should work directly on the choices output

[@andersiskov8630]

Hi Shane, thanks for the amazing videos, they help me a lot in learning! If I want to use combobox's instead of dropdowns in my Editform I cannot seem to connect it to my Detailform as it only shows the last chosen value. ie if I have [1,2,3,4] and chose 2,3,4 then it will only show "4" in my table and the Detailform. Do you have a way to get around that?

[@ShanesCows]

You are using combobox.selected instead you need combobox.selecteditems and maybe the Concat function

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

[@corinal73]

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

[@ShanesCows]

DisplayMode of ComboBox2 something like If(combobox1.selected.field = "Chewy", DisplayMode.Disable, DisplayMode.Edit)

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

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

[@billierey]

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

[@ShanesCows]

Hola and gracias 😎

[@stevekjenstad8807]

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

[@ShanesCows]

I think it is this one. PowerApps SharePoint Complex Columns - Patch person, choice, and lookup fields kzbin.info/www/bejne/naTOYmd6YqiMiKc

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

[@Charango123quena]

can you make the combo list unique ??

[@ShanesCows]

Use the Distinct function. 😀

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

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

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

[@dylan.m.murphy]

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

[@ShanesCows]

What is your datasource? SharePoint? I have never seen this behavior I would have told you con would have worked. I know it does in sql

[@codeklaudia9696]

Is there a way of limiting the combobox selection to only 3 items?

[@ShanesCows]

NOpe. You would just have to check your validation they chose 3 or less before letting them continue. kzbin.info/www/bejne/qWmYmmuLjNxlh68

[@codeklaudia9696]

Thank you very much! I did that, and it worked !! :)

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

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

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

[@mariaeugeniaferraro9040]

Hi Shane! Thank you so much for your dedication! I have a very great trouble with the combo and perhaps you can help me. In my app i have a screen where i store, in a unique record, OfficeUsers in a column named "Nombres" by concatenation of all the selected items of multiselect combo. I have another screen where i can see or edit values associated to some record, so if i want to edit "Nombres" adding another user in my column with a new multiselect combo, i want the combo to keep the stored values as DefaultSelectedItems and add the new one. Well, the problem is that i can see the values in the combo, but when i get the values of the control, all the defaults are blanck values and the new aggregate is correct. Can you help me please? DefaultSelectedItems =ForAll(RenameColumns(Filter(Distinct(Sort(Trim(Split(First(Filter(Table;ID=id)).Nombres;"|"));Result);Result);IsBlank(Result)=false);"Result";"DisplayName");DisplayName) DisplayFields = ["DisplayName"] SearchField = ["DisplayName"] Items = UsuariosdeOffice365.SearchUser({searchTerm:cmb.SearchText})

[@ShanesCows]

Yikes. Not sure. Try going back to basics and see if you can get to work in simple then add complexity