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!
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)
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 !!
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.
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")
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?
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 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!
Shane, thank you for all the helpful videos! I have learned a lot about PowerApps. I was wondering though is there a way to easily enhance the search ability for a combo box? I have a combo box that searches on 2 different fields and a lot of my results are similar so is there a way that if I just type in Apple I can get Apple at the top of the results list and anything else containing Apple ( Apple seed, Apple pie, applesauce, etc.) would be at the bottom of the search results?
Hi Shane, 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!
Hi Shane, Thank you for the video it was a big help. I do have one question. The combo box i made is pulling its data from an Excel table from one drive. The Excel table has about 941 rows, but the combo box only sees to row 501. When the data table was added to the app it did put the power apps numbers for the entire table. My question is how do i get the combo box to see all the rows in the data table?
Hi Shane, 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 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
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 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.
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.
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 .
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!
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.
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"
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?
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?
Shane, Thanks for the Video ! I have created a Canvas and used Gallery options for the questions. I have created a dropdown for the enduser to give the answers for the question, my patch function is working fine but after few seconds the answers/dropdown value is going to default value after few seconds. Instead the answer/value selected by the enduser from the drop down should remain same. How can I do this ?
Hi Shane, I 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?
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.
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 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
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.
Shane, I'm looking to place data from a collection to a combobox. Arrrrgggghhhh!!!! Is that in a different video.... I need a UA-cam 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!
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.
@@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 .))
Yes. The key is you have to have a formula in DefaultSelectedItems that returns a record that matches the Items property of the control. Maybe SearchUser from Office365 in this case?
Hi shane this video was really helpful Just one question: i want to use distict function in my combobox and my combobox is also linked to other dropdowns in my app. Basically i am unable to use distinct in combobox and i have cascading dropdown and combobox in my app
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?
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
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?
Hi Shane - Thanks once again for your magical videos. Sorry If I missed this in the video but what data type is your combo box field? Does it need to be specific type like choice? Thanks :)
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.
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.
Excellent Videos thank you! One question, in the comobox we display the value description/text to the user but usually, we want to write to the SQL table the values IDs of the selected items. You added a label that shows the values but that's just for debugging, right? how can I pass the IDs from the combox directly to SQL? Thanks!
The way I did it in the video showing the value in the label is the same value you would write to the data source. I think I show more of what you are looking for in this video. ua-cam.com/video/jmh8eeQVAIc/v-deo.html
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 ....
I think you are asking for cascading dropdowns? I show them here ua-cam.com/video/SKMwayf_cuM/v-deo.html I am using a dropdown not combobox but the cascade part would be the same.
Hi Shane, Another great video. Lots of tips in this one. Best for me: .Selected returns a value v. .SelectedItems returns a table (recordset). Question: Is there a PowerApps constant like vbCrLf in VBA that inserts a carriage return? In your example, you concatenated (CONCAT) a multi-value selection to a text string with “, “ separators. Is it possible to concatenation the .SelectedItems with a vbCrLf-like separator so that each value is displayed in the label on a separate line? If not a PowerApps constant, is there a different technique to accomplish this? Thanks! (Happy Thanksgiving (very belated). Loved your horse costume. Thanks for sharing the pic. You’re a courageous lad!)
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".
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
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 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.
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
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!
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
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 !
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.
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 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?
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
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
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.
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
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.
Thank you for all your efforts Shane! Its like a everyday routine to watch your videos now ot learn powerapps. I have one small query, in the basic canvas phone layout i use one combobox. So, when i click on one record in BrowseScreen1, i go to DetailForm1. It shows me the respective items i had added in combobox1 for that record. But when i click on the edit button and go to EditForm1, it does not let me de-select the records i saw in DetailForm. I am not able to cancel/remove out the auto-filled items from my previous screen in Combobox in EditForm1. I can see the items from DetailForm1 in my EditForm because in DefaultSelectedItems - [Parent.Default] DisplayFields - ["Value'] DisplayMode - Edit I have manually added the Items [" ","abc","xyz"] All settings are Default. Thank you very much!
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
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 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 👍👍👍
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?
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.
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.
I have cascading choice fields (multi-select) in a SharePoint list and my choices come from another SharePoint list. I'm having issues saving back to the original SharePoint list. I've been researching for what seems like months but everything I've found doesn't seem to work. The Items property of my first combobox is Sort(Distinct(SPList, Title),Result). Do you have a video that could get me pointed in the right direction?
Hi! 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!!!
Hi Shane! Thank you for all these amazing videos. I just started learning power apps to help create structure for my business and i used a lot of your videos to build the apps. I did have a question i was hoping you can help me with on this topic. I i set an error when i start searching in my combo box when i put a filter on my combobox. (Exactly what you did in your video till 17:07) If i select the item everything works fine. But the second i try searching i get a long error message. This is the example of my formula "Filter(Table1, CategoryName = "Vodka")" Everything populates fine. The error i am getting is this: "Error when trying to retrieve data from the network: Invalid filter clause: unsupported operation. Only single 'eq', 'ne' 'contains', 'startswith' or 'endswith' is currently supported." The data is coming from an excel file located in Onedrive. Im not sure if this makes a difference or not? Any help would be greatly appreciated!
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?
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?
Hi Shane, great videos (the ones i've watched so far). Quite new to SharePoint Custom Forms using PowerApps, but your stuff is definitely really helpful. One thing i'd love to know - is there a way I can make a 'People Picker' field automatically enter the current users name into the dropdown when the form is opened? That would be really helpful. I've made quite a few SP lists so far to automate a lot of processes for work, and most of them should 'default' to the current user, but there should still be the option on some of them to select a different user from my organisation. Hope that makes sense!
@@ShanesCows yep, tried that (with the builtin, and the Office365 Connector), but I just get the same 'The property expects Record values....' error.... :( Will watch the video again to see if I missed anything....
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?
Hi Shane, thanks for this great video. I have some trouble with my combobox, i want to use that as a "advanced lookupfield" at a sharepoint list, but I can't search for more than one colume. When I type ["abc","dfg"] in searchfields he search only for the first colume. I try also to set this field with this "ComboBox1.SearchText = ["abc","dfg"]" without any result. Could you help me?
Are both text fields and are you using the system name of both? If you only do 1 at a time do both work? This is how you should start troubleshooting it.
@@ShanesCows Thanks for the answer. Yes they are the system name of both. I have 5 different colums and all of them are searchable, if I only use one. On Microsoft help they told me this function: ComboBox1.SearchText = ["MyFirstColumn", "MySecondColumn"] but it also doesn't work. I can't understand why. I use for items=ShowColumns(Test_abc,"abc","def") cause i have much more than 2000 items. I tried also the Filter function, but its the same problem. Displayfields=["abc","def"], searchfields same.
Shane, Thanks for this video. One question on combobox, how to display two table values when i click on combobox? say for example, in the opportunity combobox lookup, i have opportunity name displayed already but how to show account name as well? i used concat but only getting the account guid and not display name of the account. thanks Shane.
@shane: thank you so much for your videos, they have been so helpful. I had a question, if we have a combobox connected to a SharePoint list and the no. Of items exceeds 500, how do we display all the option in the combobox?
I also watched your video on DropDowns and decided to go with ComboBoxes for the search feature. From the Dropdown video I was also interested in Disabling ComboBoxes and found that works here as well. The idea is that the user selects a value for the first ComboBox and then the second ComboBox moves from Disabled to Edit. After the second ComboBox has a value, the third Combobox becomes editable, etc. That works great when you first access the App. To clear all the fields, I setup a Reset Button. When pressed I have it doing a Reset of each ComboBox. The values are removed but the ComboBoxes don't move back to Disabled, like when we first accessed the App. I did try this same design with Dropdown boxes and the Reset button moves the Dropdown boxes to Disabled. Just doesn't work for the ComboBoxes. Any ideas on how to make this work?
Ahhhh... Let me change a little of what I said. When you come into the app fresh, the ComboBoxes reflect the Edit/Disabled state they were in when in last. Actually the only way I have found to get them back to their DisplayMode Disabled setting is to select value for all the fields and then, starting at the last field, back out deselecting the value in the previous Combo Box. I should add as well, that the last field is not a ComboBox but rather is a TextInput and it is behaving the same way. Does not Disable on Reset.
HI @Shane! Tx for the great video. Im using the combo box mostly for its inline search capability. The user can select only one value at once in my app. But i can't get the combobox to load the store value when editing a record. it always comes blank. Tried to use the code: If(EditForm1_9.Mode = FormMode.Edit, Dropdown6.SelectedText.Value, "") in the default value. but it didn't solve the problem. any guesses? ts a lot!
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 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.
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?
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?
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?
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!
Thank you!, all your videos has been very helpful, I have a question how can u use that same combox to filter a gallery, but applying that multi-selection on the filter. Right now I have this code on the Gallery Filter(IsBlank(ComboBox1.SelectedItems.Value) || IsEmpty(ComboBox1.SelectedItems) || Status.Value = ComboBox1.Selected.Value) But it only filter the las selection on the combobox
Great Video! I have one question regarding the combo box. How about if it's the other way around the combo box depends on the label. I always get an error that says the value should be expecting a table but the label is a text. Thanks in advance for your response! :)
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.
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
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
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
@@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
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
I know Shane this is complex. I used both concatenation with in operator it work with one combobox when we combine both combobox with and operator the expected results not getting. Please do video on that as soon as possible. Thanks
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
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!
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?
![Lp. Сердце Вселенной #60 РОЖДЕНИЕ ЛОЛОЛОШКИ [Финал] • Майнкрафт](http://i.ytimg.com/vi/YoR0pAV9FVQ/mqdefault.jpg)
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 !
Thanks. Glad it is helping. :)
@@ShanesCows Thanks for all the help that you have brought to the community.
Shane Young, the gift that keeps giving. Long live Shane Young!
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.
Glad to help. 😀
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!
Love it!!!! ❤️
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)
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 !!
Awesome. Thanks for your support.
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.
Very cool. Congrats
Thx so much !!!!! Handling comboboxes was a bit tricky... very helpfull... greetings from germany Christoph 👏 👏 👏 👏 👏
You are a legend. I have been looking for this all over the web but could not find. THANKS A LOT!!
Glad I could help!
Hey Shane, I'm working my way through all your videos. I'm learning so much. You rock!
Awesome! Thank you!
Shane, you are a genius! You just solved my issue for the millionth time!
Thanks John 😀
Am from kuwait 2022/February and i watch all your power apps video so really thx 🙏 alot
Much appreciate putting the Combo box back into my tool belt. Best.
Great to hear Frank!
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")
Cool. I usually use LookUp in a similar way.
Super helpful. I was struggling with DefaultSelectedItems, this made the setup very clear. Thank you!
Glad it helped!
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?
Camtasia. Amazing stuff. Highly recommend.
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!
I need to do part 2. Combo box is annoying for sure.
@@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!
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?
Nope. 😢 I got nothing
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!
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?
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?
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!!
You should be able to reference the same formula form the label in the update of the card.
@@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
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!
Search only works on string fields 😑
@@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.
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.
I haven’t but I’d I remember tomorrow I will grab the syntax for you.
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 .
Yes, you will need to get the DefaultSelectedItems property set correctly to your table but then it will work as you want.
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!
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.
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"
Should be possible. Sounds like maybe you are trying to compare text to number?
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?
You need to put something that returns the record in DefaultSelectedItems.
Hi Shane, any tips on how I can use a combo box inside a form, but pulling data from another data source? TKS!
It should just work. What are you having issues with
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?
Leave a new comment with your whole formula so I can see it.
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 ?
Set the DefaultSelectedItems property of the combobox to the value you just patched.
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?
Combobox is a bit annoying in how it works. 😒
Also, thank you so much for all of these videos they have been so helpful!
You're so welcome!
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.
Try this video on how to change the permission in SharePoint. ua-cam.com/video/_Qnz4YeHses/v-deo.html
@@ShanesCows Hi Shane!
Once again, thank you very much for your cooperation and attention.
Shane - Thank you for your awesome videos. Did you do that Part 2 you mentioned at 1:40 focusing on Comboboxes and SharePoint?
Hi Shane, I 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
Not sure. Sorry
@@ShanesCows thank you. I tried to do something else with in my IsBlank statemt that controls the combo box search
@@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
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.
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.
Shane, I'm looking to place data from a collection to a combobox. Arrrrgggghhhh!!!! Is that in a different video.... I need a UA-cam 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!
A collection is valid for a combo box items? What isn’t working?
Shane, you are amazing. Keep going please please!
Will do. This video might be helpful, some more details after the one you just watched. ua-cam.com/video/AXAbmy9zYTU/v-deo.html
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.
If it is multiple values I think you need to use concat to make them a comma separated list.
Concat is the key.
Hi Peter do you get a solution for this?
@@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 .))
@@ptchow1 Thanks mate :) That did the magic. (y)
Well explained video. Thanks shan. Is it possible to default the selected item as logged in user,using user() function
Yes. The key is you have to have a formula in DefaultSelectedItems that returns a record that matches the Items property of the control. Maybe SearchUser from Office365 in this case?
@@ShanesCows Thank you, I shall give a try
Hi shane this video was really helpful
Just one question: i want to use distict function in my combobox and my combobox is also linked to other dropdowns in my app.
Basically i am unable to use distinct in combobox and i have cascading dropdown and combobox in my app
Yeah because Distinct doesn't return all of the columns. You will have to put in Lookups to get the data based on the Distinct choice.
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?
I don’t think you can distinguish color between the two. 🤔
@@ShanesCows Do you mean that i cant make them separate values from each other or that i cant change them at all? BR Elliot :)
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
I am not sure. I have noticed the same
@@ShanesCows Glad it is not just me seeing this. :-) But still strange as both sources give the picture when you use a gallery.
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?
YOu cannot. :( YOu would have to come up with a separate control for adding a new value.
@@ShanesCows Could you work on this item in the next video? I have the same problem
Hi Shane - Thanks once again for your magical videos. Sorry If I missed this in the video but what data type is your combo box field? Does it need to be specific type like choice? Thanks :)
The items property has to be a table.
@@ShanesCows Gotcha! Thanks!
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.
Yeah ForAll sound like what you need. Remember Combobox.selecteditems is a table you feed into ForAll
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.
Not sure Robert. I have never ran into that or used the MM column in Power Apps
Excellent Videos thank you! One question, in the comobox we display the value description/text to the user but usually, we want to write to the SQL table the values IDs of the selected items. You added a label that shows the values but that's just for debugging, right? how can I pass the IDs from the combox directly to SQL? Thanks!
The way I did it in the video showing the value in the label is the same value you would write to the data source. I think I show more of what you are looking for in this video. ua-cam.com/video/jmh8eeQVAIc/v-deo.html
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 ....
I think you are asking for cascading dropdowns? I show them here ua-cam.com/video/SKMwayf_cuM/v-deo.html I am using a dropdown not combobox but the cascade part would be the same.
Hi Shane,
Another great video. Lots of tips in this one. Best for me: .Selected returns a value v. .SelectedItems returns a table (recordset).
Question: Is there a PowerApps constant like vbCrLf in VBA that inserts a carriage return? In your example, you concatenated (CONCAT) a multi-value selection to a text string with “, “ separators. Is it possible to concatenation the .SelectedItems with a vbCrLf-like separator so that each value is displayed in the label on a separate line? If not a PowerApps constant, is there a different technique to accomplish this? Thanks!
(Happy Thanksgiving (very belated). Loved your horse costume. Thanks for sharing the pic. You’re a courageous lad!)
Char(13) is what you need 😍
Great! Thanks, Shane
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".
With a multi-select combo box you need to use Concat function to get the data out of combobox.SelectedItems which is a table.
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
Concentrate on getting your record that matches the items of the combobox
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.
Make sure the default property is set properly for the control is my first guess
@@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.
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
Distinct should. What are you seeing when you use that for Items?
@@ShanesCows got it man, there was a space in one of the client name, its why it was appearing twice, thanks again
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!
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
I've been looking for this for a whole week. Thank you for the video. It helped me a lot.
Glad to help. 😀
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 !
Depends on your data set and what is the column name {columnName: “Chewy”}
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.
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.
Glad you got it working.
@@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?
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
This video has some ideas. ua-cam.com/video/gsk14D-CYRE/v-deo.html
Hi Shane, thanks for your Video, I am trying same example using share point , for me its not working , can you help on that
What isn’t working. Maybe post a new comment with more details and I can try
YOU ARE THE MAN!! Thank you so much for this video! KUDOS
Happy to help. Have a great day. 🐶
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
[“a”,”b”,”c”] in items should work.
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.
However, I don't know how should I transfer the logic into the coding 😞
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
Replies to other comment
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.
Yikes. I haven’t tried that before. 😀
Thank you for all your efforts Shane! Its like a everyday routine to watch your videos now ot learn powerapps.
I have one small query, in the basic canvas phone layout i use one combobox. So, when i click on one record in BrowseScreen1, i go to DetailForm1. It shows me the respective items i had added in combobox1 for that record. But when i click on the edit button and go to EditForm1, it does not let me de-select the records i saw in DetailForm. I am not able to cancel/remove out the auto-filled items from my previous screen in Combobox in EditForm1.
I can see the items from DetailForm1 in my EditForm because in DefaultSelectedItems - [Parent.Default]
DisplayFields - ["Value']
DisplayMode - Edit
I have manually added the Items [" ","abc","xyz"]
All settings are Default.
Thank you very much!
Maybe try Reset(yourControl)
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
Not sure. Sorry
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.
Have to come up with a way to turn the text back into a table. Maybe Split function 😀
@@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 👍👍👍
@@ShanesCows Thank you Man, really appreciate your Hard work 🙌🙌
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?
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.
@@ShanesCows Hi, I am struggling too with this default topic. Can you send me the suggested formulas?
My email is: MrBushmills@gmail.com. Thank you.
Shane, great videos. i really appreciate the real world examples. one of the things with using SharePoint lists with Choice Columns (that creates a combobox in powerapps), is how to display a dropdown based on one of the selected items in the combobox(although labeled as a Data CardValue) in PowerApps. from your examples, i pulled out the script, "
If("Other" in DataCardValue23.SelectedItems.Value,true,false)" that i can use in a Visible property of a following pulldown I want to show only if "Other" is picked in the previous combobox. Just posting here for others.
Thanks for sharing 🐶
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?
Did you see this video? ua-cam.com/video/gsk14D-CYRE/v-deo.html It talks about those complex column types.
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!!!
DisplayMode of ComboBox2 something like If(combobox1.selected.field = "Chewy", DisplayMode.Disable, DisplayMode.Edit)
Hi Shane! Thank you for all these amazing videos. I just started learning power apps to help create structure for my business and i used a lot of your videos to build the apps. I did have a question i was hoping you can help me with on this topic.
I i set an error when i start searching in my combo box when i put a filter on my combobox. (Exactly what you did in your video till 17:07) If i select the item everything works fine. But the second i try searching i get a long error message. This is the example of my formula "Filter(Table1, CategoryName = "Vodka")" Everything populates fine.
The error i am getting is this: "Error when trying to retrieve data from the network: Invalid filter clause: unsupported operation. Only single 'eq', 'ne' 'contains', 'startswith' or 'endswith' is currently supported." The data is coming from an excel file located in Onedrive. Im not sure if this makes a difference or not? Any help would be greatly appreciated!
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?
Not sure. I have not tried to use a managed metadata column. I should
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?
Put the names in a collection first then you can append the collection with additional values.
Hi Shane, great videos (the ones i've watched so far). Quite new to SharePoint Custom Forms using PowerApps, but your stuff is definitely really helpful.
One thing i'd love to know - is there a way I can make a 'People Picker' field automatically enter the current users name into the dropdown when the form is opened? That would be really helpful.
I've made quite a few SP lists so far to automate a lot of processes for work, and most of them should 'default' to the current user, but there should still be the option on some of them to select a different user from my organisation.
Hope that makes sense!
Look at the User().Displayname function. I think I explain it in a video call audit logging.
@@ShanesCows yep, tried that (with the builtin, and the Office365 Connector), but I just get the same 'The property expects Record values....' error.... :(
Will watch the video again to see if I missed anything....
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?
I made a whole video just for that. ua-cam.com/video/gsk14D-CYRE/v-deo.html 🤩
@@ShanesCows THANKS!!!! Great
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?
You are using combobox.selected instead you need combobox.selecteditems and maybe the Concat function
Hi Shane, Does Search in combobox work with list containing more than 8000 Records?
Depends on the data source. SharePoint? No.
Hi Shane, thanks for this great video. I have some trouble with my combobox, i want to use that as a "advanced lookupfield" at a sharepoint list, but I can't search for more than one colume. When I type ["abc","dfg"] in searchfields he search only for the first colume. I try also to set this field with this "ComboBox1.SearchText = ["abc","dfg"]" without any result. Could you help me?
Are both text fields and are you using the system name of both? If you only do 1 at a time do both work? This is how you should start troubleshooting it.
@@ShanesCows Thanks for the answer. Yes they are the system name of both. I have 5 different colums and all of them are searchable, if I only use one. On Microsoft help they told me this function: ComboBox1.SearchText = ["MyFirstColumn", "MySecondColumn"] but it also doesn't work. I can't understand why.
I use for items=ShowColumns(Test_abc,"abc","def") cause i have much more than 2000 items. I tried also the Filter function, but its the same problem.
Displayfields=["abc","def"], searchfields same.
Shane, Thanks for this video. One question on combobox, how to display two table values when i click on combobox? say for example, in the opportunity combobox lookup, i have opportunity name displayed already but how to show account name as well? i used concat but only getting the account guid and not display name of the account. thanks Shane.
@shane: thank you so much for your videos, they have been so helpful. I had a question, if we have a combobox connected to a SharePoint list and the no. Of items exceeds 500, how do we display all the option in the combobox?
I have increased the delegation to 2000 as well. But it doesn't work. :(
I also watched your video on DropDowns and decided to go with ComboBoxes for the search feature. From the Dropdown video I was also interested in Disabling ComboBoxes and found that works here as well. The idea is that the user selects a value for the first ComboBox and then the second ComboBox moves from Disabled to Edit. After the second ComboBox has a value, the third Combobox becomes editable, etc. That works great when you first access the App.
To clear all the fields, I setup a Reset Button. When pressed I have it doing a Reset of each ComboBox. The values are removed but the ComboBoxes don't move back to Disabled, like when we first accessed the App.
I did try this same design with Dropdown boxes and the Reset button moves the Dropdown boxes to Disabled. Just doesn't work for the ComboBoxes. Any ideas on how to make this work?
Ahhhh... Let me change a little of what I said. When you come into the app fresh, the ComboBoxes reflect the Edit/Disabled state they were in when in last. Actually the only way I have found to get them back to their DisplayMode Disabled setting is to select value for all the fields and then, starting at the last field, back out deselecting the value in the previous Combo Box. I should add as well, that the last field is not a ComboBox but rather is a TextInput and it is behaving the same way. Does not Disable on Reset.
Interesting I haven’t ran into this. I will have to look into it a bit b
HI @Shane! Tx for the great video. Im using the combo box mostly for its inline search capability. The user can select only one value at once in my app. But i can't get the combobox to load the store value when editing a record. it always comes blank. Tried to use the code: If(EditForm1_9.Mode = FormMode.Edit, Dropdown6.SelectedText.Value, "") in the default value. but it didn't solve the problem. any guesses? ts a lot!
Your DefaultSelectedItems has to be set to a lookup or filter. You cannot pass it text.
Shane Young thanks!
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.
I think you need to revisit your logic for DefaultSelectedItems to account for both scenarios
@@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.
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?
Not that I know of. Never seen that before.
Thank you very much! greetings from Argentina
Thanks from the US. 🐶
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?
Combobox.selected.id should be the value?
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?
You have to use DefaultSelectedItems. Default doesn't work :(
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!
Thank you!, all your videos has been very helpful, I have a question how can u use that same combox to filter a gallery, but applying that multi-selection on the filter.
Right now I have this code on the Gallery
Filter(IsBlank(ComboBox1.SelectedItems.Value) || IsEmpty(ComboBox1.SelectedItems) || Status.Value = ComboBox1.Selected.Value)
But it only filter the las selection on the combobox
Hos can i concatenate and display valves already in sharepoint list & values selected in current edit form before it is saved.
Use LookUp to get the current data out of SHarePoint.
@@ShanesCows thank you
Worked for me
Great Video! I have one question regarding the combo box. How about if it's the other way around the combo box depends on the label. I always get an error that says the value should be expecting a table but the label is a text. Thanks in advance for your response! :)
Yeah have to convert it to a record that matches the items property of the combobox. {column: label.text} should get you in the ball park
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.
Leave a new comment with your challenge?
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
I go deeper into DefaultSelectedItems in this video. Maybe it will help you have that light bulb moment. ua-cam.com/video/AXAbmy9zYTU/v-deo.html
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
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
@@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
@@sundarun You would need to filter with the 'in' such as Filter(ABC, TextInputSearchBox.Text in XYZ) I seems like you are using StartsWith.
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
Is there a way of limiting the combobox selection to only 3 items?
NOpe. You would just have to check your validation they chose 3 or less before letting them continue. ua-cam.com/video/s85i8UWw2QM/v-deo.html
Thank you very much! I did that, and it worked !! :)
Hey Shane. How filter gallery record using two multiselect combobox in powerapp. The both field is multiselect checkboxes in SharePoint list.
That is a complex one. You have to use the Concat function and the in operator. One of these days I need to do a video on that.
I know Shane this is complex. I used both concatenation with in operator it work with one combobox when we combine both combobox with and operator the expected results not getting. Please do video on that as soon as possible. Thanks
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
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.
@@ShanesCows Am I correct to assume in the DefaultItemsSelected Field?
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!
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
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?
The search function is never delegable to SharePoint. :(
Hi Shane, can we get people names in combobox( in powerApps form) from another sharepoint list where people names are stored?
Maybe look here for an idea ua-cam.com/video/43ekj5MlNJU/v-deo.html
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?
Just reference the datasource directly