Power Apps Combo Box DefaultSelectedItems

[@aarondeimund9511]

Hours of looking on Microsoft's documentation and you salved my problem in 5 minutes. Well done!

[@ShanesCows]

Awesome 😎

[@danilogamut]

Saved my life on that comma-delimited source... Appreciate your videos man! Life saver!

[@BriJ19]

Life saving video! 40 minutes from a meeting with clients and couldn't get my repeating tables with combo boxes to keep their values!!! THANK YOU!

[@ShanesCows]

Glad you got it. 😊

[@junbecks]

Although Ive watched these videos before, rewatching them and realizing its so much easier to follow when Ive gained more experience is satisfying. Loved when you renamed columns from result to value, its like telling powerapps “look at me, Im the captain now”

[@PowerUpPowerApps]

This is awesome! I fall into the category that needed to watch well beyond the 5-minute mark. Great video, this answers EXACTLY what I was needing to know.

[@ShanesCows]

Awesome! Thank you!

[@user-vi1ww4xh1t]

I thank you from the bottom of my heart good sir. Your video gave me my confidence back, after spending 2h30 banging my head against a wall, trying to manage a combobox through its default property.

[@ShanesCows]

Glad I could help, I hope your head doesn't hurt too bad. :)

[@sylvainscharlet1897]

Hi Shane ! Thanks a lot for this tip I get more and more skilled with powerapps but I have to admit that you are my true master, I learnt powerapps and lanched a compagny thanks to your vidéos, out of this everything changed in my life as a total freelance now, when I will be richer I swear I'll propose you and family a plane ticket for holidays in Marseille and pay you a the best bouillabaisse on the vieux port ... I assume in one year or two ... thx

[@ShanesCows]

Congrats on the success Sylvain. You did all of the hard work of learning and applying. No holiday required. Use your hard work and good fortune to take care of your family. That is all I want. 😊

[@anirudsaichenna3158]

Great Explanation Shane, appreciate sharing your knowledge, I caught up into a problem with Combo box and almost spent a day trying to resolve, but had no luck, and I started looking for help over internet and came across your video which helped in solving my problem in less than 30mins. thank you very much

[@mdhabeeb4696]

Ohhh my godd.. Thanks alot I was searching for setting the default value of a combo box from a text box since 3hrs. You just explained it in an excellent way. Thanks alot. Keep doing more videos like this😍

[@ShanesCows]

Glad I could help

[@TracyWork]

3 yrs later you solved my issue! Thank you for your videos!

[@ShanesCows]

Great to hear!

[@Mr_Poppea]

Looking under the hood like this is always expands my understanding. Thank you.

[@ShanesCows]

That was my hope. 😍

[@spumon]

Amazing. Here are some that I had a hard time discovering and some that I couldn't. Learning from this video made my app even better.

[@ShanesCows]

That is awesome 😎

[@georgeflefel504]

After hours spent trying to figure out why the default selected item was displaying blank this finally cleared it up for me! (The mismatch of Result and Value column names) You're my hero!!

[@jhhatcher1885]

Shane - I am truly a fan... I was in the same boat as another commenter - nothing seemed to work. But then I re-watched and applied the {Value: "ItemName"} method you used in the hard coded section for my issue - and it worked like a charm. Whoo Hoo, THANKS!

[@ShanesCows]

Awesome!

[@athenadepper4597]

When I have an issue I almost always end up at your videos! I just need to start coming here first :)

[@ShanesCows]

You do. 😜 Glad to help.

[@optimisesocialmedia]

Shane! I love you!!!!!!! I have been baching my head against a wall for days on this problem and you come up trumps again. Thank you !

[@KrystalHawkins-c6w]

I have referred back to this video so many times. Thank you for continuing to make useful content!

[@puddin32]

THANK YOU. You helped me solve my immediate problem, and you helped me to better understand some of the fundamentals MUCH better than I did 15 minutes ago!!!!

[@olivaadak]

seriously you are a life saver! this turorial gave the idea how I should go with this defaultSelectedItems. thanks!

[@ShanesCows]

Awesome! 🐶

[@GerlofKasma]

Yes! That tutorial gave me the right inputs to get my combobox working (had this in the items "Choices([@'Project Reporting'].Customer)" and could not get it to select (and remember) the item from the gallery that was selected. Now it's done through this in the defaultselecteditems box: "LookUp(Choices([@'Project Reporting'].Customer), Value = glr_Reports.Selected.Title)"

[@richardberriman]

After all this time, these still do my head in, plus I had to clear out a table again and again and have the items column renamed to value from a more logical name...but it finally worked. Thank you!

[@GwenJones-mx9vl]

Thank you for going the extra mile! Those are the videos that help! Anyone can be basic!

[@ShanesCows]

You are so welcome!

[@jimhoeger5232]

Excellent video. Concise, yet thorough, as usual.

[@ShanesCows]

Much appreciated!

[@jonathanmora9116]

I was struggling to get a comboBox to work with a default value from a Sharepoint item. This helped me a lot, thank you!😁

[@ShanesCows]

Glad you got it, combo boxes are so frustrating.

[@PowerAutomator]

Still valid in 2024. Help me save so much time figuring this out by myself. Real guru

[@ShanesCows]

Awesome, glad to help. DefaultSelectedItems is one of the hardest concepts in Power Apps.

[@PowerAutomator]

@@ShanesCows thank you Master

[@franknielsen7713]

F..... awesom with the solution with renaming columns. Have saved me hours of work if I had just taken my time to watch the whole video. THX again Shane 🤦‍♂️🤦‍♂️🤦‍♂️

[@ShanesCows]

Glad to help Frank.

[@ssccservlearn]

Saved the day for me today! Was beating my head against the way trying to figure out how to show previously selected values from a hard-coded dropdown list.

[@ShanesCows]

Awesome, glad to help. 😎

[@POng-lq6yj]

Hello Shane, I have a question. I have a timesheet app. So I created a gallery that includes a combo box then it will be stored in a collection. As I add another row in the gallery, the defaultselecteditems in row1 is deleted. How can I retrieve the last record of my collection? Can you help me? Thank you

[@ShanesCows]

In your DefaultSelectedItems ThisItem should be in there someway. Depending on how you stored it in the collection will determine how you put it in. Reminder, ThisItem represents the current record in the collection.

[@POng-lq6yj]

@@ShanesCows I am thinking if I create a variable to get the last record of my collection and put this variable in the defaultselecteditems property filter(collection, projectname = variable) of my combobox inside the gallery. Do you think it will work?

[@POng-lq6yj]

My only question is.. how can I get the last record of my collection? What is the syntax? so that I could create a variable from it :)

[@ShanesCows]

@@POng-lq6yj Last(CollectionName) Will return the last record. :)

[@POng-lq6yj]

@@ShanesCows Thank you. I’ll try it tomorrow. You have been so helpful with my journey to Power Apps. Love your videos!

[@Leighau]

Thank you! Thank you! Thank you! The last method has made my day. Was worth watching the whole thing. Great Content Shane, Really appreciate you taking the time to explain these quirks in a simple way. My case was that the user can select a button to set the default form data. Button onSelect: UpdateContext({tempStr:TrimEnds(Concat(LookUp('Cert-FormDataTemplates',TemplateName = localTemplate,Stages).Value, Value&" "))}) my combo box has this code; items: ShowColumns( Filter('Cert-ChoicesDataList',Not(IsBlank(Stages))),"Stages") DefaultSelectedItems: Filter(ShowColumns( Filter('Cert-ChoicesDataList',Not(IsBlank(Stages))),"Stages"),Stages in tempStr) I tried so many forums and got nowhere until I watched this. You are brilliant! Thanks mate

[@ShanesCows]

Awesome. Makes my day when someone understands the deeper concept then just the answer. Good job! 🐶

[@京萍李]

I notice one trick in this defaultselecteditems. It shows the records you want in the combo box,while it will not be really selected if the user hit and select from dropdown lists. I solved this by coalesce function. Is there any neat solution? You know, as user seeing her/his name correctly selected in box, it is hard to ask her/him to select again..

[@ShanesCows]

Thanks for sharing! 🐶

[@deeparajdeva5223]

How to use that coalesce and where we have use it?

[@mustafahussainmohsin320]

have you fixed this issue when opening the combo box its not getting selected the value which are showing in default selected items???

[@webdevca]

thanks for the tip about the split function and the renaming the column from result to Value

[@ShanesCows]

Glad it helped!

[@davidesparza4905]

Shane thanks for all your videos, you keep me inspired on learning new stuff, you're my idol :) !

[@ShanesCows]

Happy to hear that!

[@ST-hb3xj]

Hi Shane, On a dropdown on the Modern Controls, do you know how to add a "Please select an option" before all the values from a Dataverse table and how to ensure that the dropdown does not show duplicate values?

[@ShanesCows]

Distinct will help you only show unique values kzbin.info/www/bejne/jJ_ElX6NnsueqJo New Table function can add something to your Table kzbin.info/www/bejne/d4Gmlo2umK6jmsk

[@ST-hb3xj]

@@ShanesCows Hi, thank you for getting back to me. Your Distinct video works great on the classic dropdown, but there seems to be an issue with modern dropdowns. I'm not sure if Modern controls are really ready to be used to be honest, but thank you so much for getting back to me 🙂

[@DreW-bm7fc]

Thanks!

[@ShanesCows]

Appreciate the support. 😎

[@sreekuttan2004]

Thanks...This really helps...👍👍 But one scenario that I still struggle with is when using combo box in a edit mode form..I want the already submitted value to stay as default selected items but at the same time, but at the same time, I don't want the user to again select the same items while editing the form... Because default selected items return blank values in the update property of the data field...This really misguided the users...Is there more intuitive way to achieve this?

[@ShanesCows]

I don't have any good ideas. ☹

[@Allison-jg1qu]

This video was so helpful! I have one question. I have a combo box where the default selected items are not highlighted in the list of available Items. Any idea how to resolve that? The Items are coming from a collection, while the default selected items are a SharePoint text column split on a delimiter. I confirmed the column name of the collection and the default items is "Value' but I'm not sure where to go from here. Any help is appreciated!

[@mahalakshmi1404]

Hi thanks for the information..I want to hide the another text input control based the selected value in this checkbox (inside gallery).. what should I writ in the visible property of that text input

[@ShanesCows]

kzbin.info/www/bejne/qWmYmmuLjNxlh68 I have a whole video on ways to do it. 😀

[@mahalakshmi1404]

@@ShanesCows Thankyou.. It helps me lot

[@Kimber_B]

How do you display selected items in the combo box vertically instead of horizontally?

[@ShanesCows]

I don’t believe that you can

[@IamSanjayPersad]

Great video. Exactly what I was looking for. Keep up the awesome work.

[@ShanesCows]

Glad it helped!

[@IamSanjayPersad]

@@ShanesCows Hey Shane is there a way to set multiple persons as a default in a people picker using this code: { Claims: Concatenate( "i:0#.f|membership|", User().Email // Person email ), Department: "", DisplayName: User().FullName, Email: User().Email, // Person email JobTitle: "", Picture: "" }

[@joepark8872]

Thanks Shane. But... I have a list (built by someone else) which has a column with delimited items. This field should be the default selected items. (Why this column was made a single-line text field and not a choice field is beyond me.). I can bring back the choices and split them into a table, like Split(ThisItem.'HUB-DisseminationMechanism',",") but I cannot use this in the DefaultSelected. I've tried {Value:} and I've tried Table({Value:}). Any ideas? The field might be CIDR, Custom Tools, FTP, QuickFacts and these should be the default selected. Thanks in advance!

[@zero2herobeatspaul882]

It's a shame I can only subscribe and like once. Excellent content. These are great times, with all the development that Microsoft is putting behind PowerApps.

[@ShanesCows]

Thanks for the support. 🐶 We will take your once and appreciate it.

[@mustafahussainmohsin320]

Please help, I am able to populate the Combo box but when I open the combo box its not showing currently default selected items

[@TheGracieGrl]

Is there a way to say for text? instead of two dropdowns, I have Combobox and a search bar, and I want to do something similar so I can filter using both, but I can't figure out the right way of structuring the formula.

[@CarFinanceSimplified]

Great video as always. I ahve an issue though. When I set my DefaultSelectedItems to {Value: ThisItem.}, even though the item shows as a default, PowerApps thinks the ComboBox is BLANK until I go in and re-select the item? I need to some comparison logic to check if the default matches another cell, but it won't work until I go in and re-select the item again in the ComboBox??? Any ideas please!?

[@Consciousphotography]

Thank you for your contribution. I was struggling with the combo box and was looking for some help

[@ShanesCows]

You are welcome!

[@shannonfong9519]

I need help. I have been trying to get a multiple select combobox to save to a SharePoint list choice field. The combobox is populated from another SharePoint list and I would like these values stored in the choice field on my existing SharePoint list.

[@kasokar]

This is great if it's the first time submitting an item, however, when the user selects a different option when editing the item, it defaults back to whatever you had set the DefaultSelectedItems. How to change it on edit so that doesn't always return to default and retain the existing option selected by user?

[@gaborpataki87]

I've tried it all, but I have a combo box which has a data source of a SharePoint list and it doesn't work. I can patch data from the combo box to the SharePoint list, but once I wish to retrieve the data and allow the user to edit items it does fail. Within my app I do not use forms, only galleries and the patch function and it is not an option to rebuild it from scratch... any ideas to solve it?

[@MrAbueslam]

I have a combobox lookup coulmn in splist that present vendors , I need to a button that add new vendor when it is not in the list. How i can do that .Thanks

[@pauldavis9789]

Still useful today after being posted 14 months ago. Matching the items column header within the defaultselecteditems and renaming the column to match it fixed my issue. Thanks

[@sammie1729]

Hi Shane. I wanted to ask you what if I want to pass a collection in the combo box? Usecase: I have a collection of user names from a repeating section and want to pass that collection in the people picker field of SharePoint list? Can we do that?

[@ShanesCows]

If I follow correctly then yes. kzbin.info/www/bejne/naTOYmd6YqiMiKc Use that video to learn how to patch the field directly.

[@andersmikkelsen3418]

Tak!

[@ShanesCows]

Thank you for the support. 😎

[@cdunsford]

Thank you Shane! I've created a AppSettings SharePoint list where I am storing app settings (defaults for filters, showing or hiding table columns, etc). Being able to grab a comma delimited string and set the DefaultSelectedItems from the SharePoint column is key to the success of this feature request in my solution...thank you!!

[@pisanchitphanthanakorn1304]

Wow what a great tricks. You alway teach me new thing. Thank you so much Shane

[@ShanesCows]

Glad you enjoyed it!

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

[@maggieho9521]

Thanks for the good info! What about add "ALL" be the first item in the combobox list?

[@philipllorin6105]

ComboBox and Dropdown like very much, but for Teams there is no Dropdown Control?

[@ShanesCows]

Correct. You can copy it from a normal app or turn on classic controls under experimental settings.

[@GPZ_Biker]

Hi Shane, I'm loving your videos and they help a lot. Could you please help me understand how to pass a global variable into a combobox in a new form. So if I click from a Gallery onto a new page to add a record (1 to many for recording notes on a task), how do I pass the primary key into the notes form with foreign key. Thank you

[@Itsprincessa01]

Hi Shane, how do you reset a combo box while also setting it's defaultselecteditem to gallery.selected.column. I want to use the combo box to save new data and update at the same time

[@mcr-mso-85]

Again, thank you, Shane! You are a rockstar. That bloody combobox "Default" field is confusing, why did they keep it there if it doesn't have any use!

[@ShanesCows]

I wish I knew, I wish I knew. 🥲

[@gustavobaeza3890]

There is any way to select copy the text from different text boxes into one final text box.. I already did it but if .. let say the first text box in empty my final text box copy the space from text box 1.. there is any way to make the final text box to ignore if text box1 is empty??

[@ashimishra23]

Another nice video from you, Shane! Thanks (y) . Quick query - I have combo box as one of the field in my form. I selected - more than one value in combo box , (say 2 out of 5)and submitted the form. When I open the form in EDIT mode, how can I see those 2 values as preselected in combo box along with other 3 values?

[@ShanesCows]

If you are using a Form control that should automatically be set, you shouldn't have to do anything. Did you check the DefaultSelectedItems. Did you also make sure your data is being saved to the data source.

[@ashimishra23]

Hi Shane, Yes my data is being saved. I have 2 comboboxes in my form - 1 is single select, another multiselect. When I open form in EDIT mode , I am able to see previously selected values in the multiselect combobox but when I click on the down arrow to see the complete list - those pre-selected values are NOT highlighted. Highlight helps in identifying which values were submitted previously and which values have not been selected earlier. Please note; for both comboboxes, data is being fetched from another list.

[@jeffersondaniel5883]

Does the DefaultSelectedItems actually set the field value? I need something that physically sets the field value based on another field. Visually it seems like it works on my app, but when i go do a form submit. Its not actually saving the field.

[@khiangphathaiuthen8164]

My App show notification error due to gallery use data from combo box. I was set defaultselectedItems for combo box. but it seem to be slow than notification. How can I close notification ?

[@golnarnaghavi9599]

Hi Shane. Do you know how to filter the combo box that has status reason values to only show inactive status reasons?

[@emantrabelsee7799]

I have passed a value to the combo box, but when save the record to the table it says: Value must be a data entity record, how can I solve it?

[@MrNagubhai]

DefaultSelectedItems seems to be now deprecated. I cant see it in the list. Default is working with lists too.

[@ShanesCows]

DefaultSelectedItems is still there for Combo box. It doesn't exist for dropdowns. Is that possibly your issue.

[@MrNagubhai]

@@ShanesCows Yes.. correct. Thanks

[@codeklaudia9696]

Thank you for the video!! Is it also possible to store multiple items selected from a combobox into a global variable (array) to pass it to the next screen?

[@ShanesCows]

ClearCollect(yourCollection, Combobox1.SelectedItems)

[@alexleyva8263]

I have a combo box that I created that pulls the list from one table (table1), and saves the results in another table (table2). I have been able to create new records in table 2 with the data saved using concat(combobox1.selecteditems...), If I retrieve an existing record, I have been able to default the selected items using renamecolumns(split(...). The problem I am having is that if I select one more item from the list, I get something like this ",,,,NewSelection" instead of "OldSelection1,OldSelection2,OldSelection3,OldSelection4,NewSelection". Can you help?

[@prakashamc]

Great explanation, I have a collection of persons, I need to select default all the persons. Thanks.

[@ShanesCows]

Glad it was helpful!

[@shaktisinghmojawat6253]

Hello Shane, it's been great learning, And I wanted to know something, please help me come out of the issue as follows: We have a Form with a combo box that allows multiple selections, we selected 2-3 office365names from the list and save it, when we try to open that record again, it should load the selected items in the combo box without touching any item if we submit again, it should still hold those values in the database, In my case, it is storing multiple values and while editing it is showing the values in the combo box, but when I click on submit, without touching anything, the combo box values are getting vanished. it should still hold the values. Thank-you I am looking forward to hearing from you.

[@zerocool200380]

Hi Shane, Recently I noticed that every time I create a new canvas app the forms will use Cambo boxes while in the past they used dropdowns. is this part of a new update/ layout power apps is pushing? if Yes how can we revert back to the old design? Thank you in advance for your help.

[@ShanesCows]

I am not sure. 😑

[@damianjohnson3057]

Is it possible for comb2 to look at one tbl depending on combo1.selected.value. I.E. combo1 selected value = tbl1 combo2 data source becomes tbl1, if combo1 selected value = tbl2 combo2 data source becomes tbl2. Thanks for all the tips 👍👍

[@ShanesCows]

Yes as long as tbl1 and tble2 have the same structure you could put an If statement in the Items property of the combobox

[@gtrj55tgjr]

Shawn one problem in this, if you want to save it combobox value so you will use combobox.selecteditems, at that time default selected item will not going to save it shows blank, please check the scenario, but its come when you selected values manually, default values not come in selecteditems

[@s961201]

Great video - thanks🤩 will it work the same way if your source is peoplepicker connection? Let’s say I have gallery of projects. Within the form accessed from the gallery, I select the project team from O365 connection. Going back and forth between projects, will I be able to set the default selected team?

[@ShanesCows]

Yes, as long as the table matches it will be happy. 😊

[@samratguha8933]

Hi Shane, Is there anyway to get the version history for a multi line text Thanks in advance

[@ShanesCows]

Not that I know of but never tried.

[@ThePumaso]

THANK YOU! Excellent, easy to understand, to the point!

[@ShanesCows]

Happy to help. Have a great day. 🐶

[@17avskadoo]

You did so much heavy lifting buddy kudos to you. Awesome job, Thanks a lot !!!!

[@ShanesCows]

Happy to help. Have a great day. 🐶

[@erik8362]

Great video as always. Just a quick insight I had: When selecting defaults on a combobox with a database table source, you can not use a function as a filter criteria as the query delegation will not work (e.g. LookUp(DBTable, Col1 = First(PowerBIIntegration.Data).col1). To solve this you first need to set a variable that can be used for filtering (e.g. Set(_varDBTable, First(PowerBIIntegration.Data).Col1 )); and default item= LookUp(DBTable, Col1 =_varDBTable)

[@uzairsiddiqui4290]

Hi Shane! if I have similar values inside combo box if I select one the other one is selected automatically which is quite frustrating. Do you have any idea how to go about this problem?

[@ShanesCows]

Not sure. I haven’t ran into that.

[@andrewvalenzuela1790]

Thank you, I wish the powerapps docs had more example of how to use the various controls

[@ShanesCows]

😊 more is always better

[@Vihushrihu]

Hi Shane, How can build a collection from a Combo Box which dynamically add and deletes values as i add or delete records in the combo box ?

[@RexKanum]

How would you make a good looking desktop shortcut that opens a power app and share it with the users? I keep sending out the urls, but there most be an easier more elegant way for newb like me..

[@ShanesCows]

I don't know. I have never tried it but does seem like a cool idea. I will think about it.

[@raghus8746]

Thanks Shane. One query please. In my Items property for ComboBox I enter ["1", "2"] but when I actually open the app and click the ComboBox it shows values "35" and "37" instead of "1" and "2". Can you please help. Also I dont see the "Advanced Options" tab for my ComboBox.

[@alejandroavalos4863]

very good video, but when applying this to a list containing office users RenameColumns (Split (Text (txt_responsable_division_edit.Text); ","); "Result"; "DisplayName") does not select them, although it is a table type please your help Greetings and thanks

[@optimisesocialmedia]

Hi Shane, my Drop down box is linked to another table, and i have managed to get it to populate from a variable using the {}, but when i 'Submit Form' all the data from the form goes into the SharePoint list except the drop down box value i need. Any suggestions would be really helpful. :)

[@ShanesCows]

Look at the update property of the data card. You need to set it to use the dropdown. I think I show how to do it in this video kzbin.info/www/bejne/amTInJ1rgtGBgLc

[@optimisesocialmedia]

@@ShanesCows thank you Shane :)

[@papithasekar9567]

Thanks again for the good informative video Shan, IF you don't mind,can you tell me how to set defaultselected item from CDS to combobox

[@cijoypf]

Thank you for another great video Shane.

[@ShanesCows]

Glad you enjoyed it

[@bhanuprathappoojari5453]

I want to achieve combobox with People picker and Want to add default users to the combobox selected from another screen.

[@cliftonmcchesney6997]

I have a combo box that is a multiselect it is called UnitCombobox . It is pulling the data from collection UnitNames . It writes the multiple unit names to the column in the library column called Unit. When I open up the form I can't figure out how to Filter the UnitComboBox to show the DefaultSelectedItems that are assigned to the record. It is always blank. I can only make it work if there is only 1 unit in the column not multiple. Here is the code currently DefaultSelectedItems = Filter(UnitName, Title = ThisItem.Unit) only works if there is only 1 unit name not multiple.

[@radiosonicfan1726]

Is there a way to default select every choice? DefaultSelectedItems: Choices([@'SharePointSource'].'ColumnName')? Trying to avoid, hard coding choices in excess of 50 options. Design intent to have all options selected and the user simply have to uncheck undesired options. I tried but shows, Choice 1, Choice 2, Choice 3. Not the actual choices in the SP Choice column.

[@danher4607]

Shane, you are very good, you saved me again.

[@sandiphore21]

Hi shane, thanks for this awesome guide. I am stuck with an idea. I wanted to implement a searchable text input (where i will get suggestion based on input text and existing data.) any idea how to get it?

[@ShanesCows]

Power Apps doesn't do search like that 😐 As far as I know.

[@sandiphore21]

@@ShanesCows thanks for replying. I tried using a combination of searchtext and selecteditems in combobox. Somehow it works for searchtext however unable to update a value from selected items.

[@michaeldeabreu2020]

Great Video Shane. I would love to see Combox used in a gallery. I have still not got this to work where you can have items in a collection the use a combobox within the gallery to 1) select values and then 2) Default the values when coming back to edit. Comboboxes in a gallery using the OnChange to patch a collection end up going into an infinite loop as the onChange and DefaultSelectedItems conflict.

[@ShanesCows]

On change can cause loopiong. Maybe force the user to press a button to do the save instead of OnChange?

[@jnotbusch]

he did a very good video on changing just one record in a gallery and saving/updating it.

[@reivaxmik9058]

Hi Shane, thanks for this. All your examples here works when the app is online, I was even using a collection and works just fine. But not if the app is offline. Any ideas or tips about this? Thanks

[@FlatCapWolf]

Hi Shane! How about if you are working with an optionset?

[@Shinsha-vaami]

Hi Shane, Could you please make a video on below scenario Autocheck check boxes based on the value in another field, check box items are coming from SharePoint list column

[@CarlosSolisNow]

Pure spun gold, Shane

[@ShanesCows]

Thanks Carlos!

[@saradehond3293]

I'm trying to use this with a choice column. I don't want the choices to reset but be matched with the actual value I've selected. As defaultselecteditems needs a table or a lookup for a record, I'm really wondering if this is possible.

[@saradehond3293]

It always helps to post a question, somehow I often find the answer to it just then... It's: Filter(Choices(TableName.ChoiceColumn), Value = ThisItem.ChoiceColumn) This is dependent on using a gallery and in the items property use Choices(TableName.ChoiceColumn). For dataverse...

[@TraderZo1]

You read my mind with this issue Shane! Multi Select filter to Multi Select!

[@ShanesCows]

Awesome