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”
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
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. 😊
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.
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)"
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.
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!!
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
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😍
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!
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!
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.
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!!!!
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
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 🤦♂️🤦♂️🤦♂️
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!!
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
@@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: "" }
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.
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)
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.
Hi Shane, I have had a lot of trouble setting the default selected items of a combo box when looking at a choices column. This seems to be a fundamental thing in Dataverse / Power Apps, using a combo box for a choices column but wow is it hard to find a way to set the default selected item. You mention the solution during the video, I use something like this: {Value: varRecord.'Choices Column'}. I use this in several places in almost all of the apps I build. Thanks for dropping that in there. I feel like this should be a bigger deal... This is the only place I have found this technique mentioned.
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
I am bookmarking this one. Thanks! One thing I wish you could cover in the future is how to populate a Person combobox with filtered people from another List. Like how do you show available Counselors in that combobox so that the user must select one of those. The problem is that a FILTER() in items will make that combobox loose its Person schema and you no longer can display Email, Picture, etc. out the combobox selection. Plus saving the selection and coming back to the form how do you do the DefaulSelectedItems to show what was previously selected and to display the Picture in a separate image control?
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
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.
@@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?
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?
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!
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..
Awesome video Shane I learned a couple of really cool stuff from this video! I have a question, how can I use the Combo Box and New Form thus when I type the name in the Combo Box, it shows me the record in Edit Mode Form? Thanks for your help!
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?
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.
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.
Always rely on you Shane! Stupid past me stored a column as a text value, with the control in the app a combobox, then the customer says we want multiple values in that column. Crap i cant change it to a lookup now i will loose all my data! Split to the rescue with rename columns haha Thanks!
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!?
I use PowerApps with integrated sharepoint list. I have a problem when it comes to editing an item from the list: To be able to display the already selected item content in edit mode, do I have to set the DefaultSelectedItem = SharePointIntegration.Selected. This works. However, I have 3 input depending on each other, using filters. [Boat (Lv. 1), Main Component (Lv. 2), Sub-Component (Lv. 3)]. Which means that the choices in the comboboxes depends on the selection in the level above. For example two different boat choices, the main component drop down choices is depending on the selected boat, and the sub-component is depending on the main component. Therefore is there a need to reset the selections if any changes is made in a higher level. In the new item screen is the DefaultSelectedItem set to [], and I set the OnChange = Reset(…). This works, as the selection is set to blank. In the edit view is the same approach set to the item value, as it is the defaultselecteditem. I need to set the comboboxes on levels 2 and 3 to be blank OnChange in a higher level and not depending on the defaultselecteditem. Any suggestions?
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
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?
Distinct will help you only show unique values ruclips.net/video/VnadKWifkr8/видео.html New Table function can add something to your Table ruclips.net/video/APCeZxcIpdg/видео.html
@@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 🙂
Just a tip. If you want to use combobox selecteditems as string use concat....for one item, concat(combobox.selecteditems, result & "") for few items concat(combobox.selecteditems, result & ",") well you will get an idea.
Another great video Shane. One question, have you done a video on combobox and how to display the current value from a selected gallery versus being able to select a item from the combobox on a new form and then how to write the new selection to the sql table that the form uses?
I just had this very issue, I had to save the selected record to a variable then use that like this.. If(editMode = true,Filter(Departments,Name = varSelectedItem.Department)).Name or this... If(editMode,LookUp(tbl_NonStockSuppliers,Name = varSelectedItem.Supplier,ThisRecord)) then just use patch/update for SQL
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?
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?
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.
Thank you Shane for your excellent videos 🙏🏻 I have a form which is connected to two SharePoint lists, and I tried to filter a dropdown list so if one chooses Department A, the second dropdown list will be populated with its content from the other column from the same SharePoint list (the source of both dropdown lists is the same SharePoint list), but whatever I write in the formula nothing seem to work. Since the form includes DataCard and DataCardvalue, I believe I should write the formula different, but I don't know how. I'm aware there's a cascading solution, but I wanted to a create a straightforward solution, so users don't have to choose a value from the second dropdown list - it's will be populated automatically. Do you have any suggestions for each dropdown list? In addition, I have two departments in the SharePoint list which include multiple values, so I wonder how will they be displayed in the dropdown list? Will the first value be populated? I prefer it will work this way, and not display multiple values.
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
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.
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.
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
Hi Shane, I want to set current logged in user as default selected person then can add more people from people picker combobox. Below things I have done and hoping you would help!! I have people picker combo box and data source is SharePoint. Combo box is set to true to allow multiple selection. On AppStart I set "Set(CurrentUser, Office365Users.MyProfile());" I have datacard which to I used DefaultSelectedItem and set "CurrentUser". To update item property of datacard I used "DataCard1.SelectedItems" but seems like it says record expected then when I change to "DataCard1.Selected" then it only takes 1 value which I selected and removes DefaultSelectedItem and other selection.
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?
Hello Shane, thanks to your tutorials I have recently build my first app. Your presentation is clear and understandable and energy is great! Thank you. I have however ran into a problem and I cannot find a solution anywhere. I want to use combobox to filter the records in vertical galery. The items of the combobox are added with Distinct function. The filter works, but the options are invisible . The user can choose them but is unable to see which option he is choosing. Have you ever ran into such problem? is there a remedy for this?
@@ShanesCows Hello, yes, the issue was in the Field propoerty. Apparently when Distinct is used to fill the combobox the Result field must be added to the fields. Thanks!
Thanks Shane, always appreciate your videos. I'm using the steps provided in your repeating table videos and have added a combo box to the gallery. The combo box selections do save in the collection. When I create a new record in the gallery, the context in the saved text fields remain on the display but the combo box selected item disappears. What am I missing?
Hey Shane... thanks for all the great videos. I tried something and didn't manage to solve it... so I changed my approach... but I'm curious to see you show how it can be done. I had one gallery and one form to show that record... and then I had another smaller form for users to fill out "requests" on the selected gallery Record... The second form had one prepopulated field for the "Record ID" from the selected gallery record, so I could keep track on which record the request was attached to. However in my attempts to be "clever" I used two sharepoint lists... where that ID-column in the second list was linked to the ID-column of the first list. Now, no matter how I tried I couldn't get that column populated with the selected records ID when I submitted the second form. So finally I just turned it into a simple number column to get it to work. But I would love to know how it was supposed to be done... because I think I was close...
Hey Shane great video. I do have a question for you or anyone in the comments. I am building a app that connects to SharePoint data source and i have a combo box that shows the list but I have multiple items the same name I have used distinct to filter the other out but when i do the "Allow Searching" flips to false and when i flips it back it it changes again. Is there a way to keep the search function?
Once again, great content Shane, thank you very much! In one of my apps my registering several items according the distinct value of a table. For instance, it starts asking for a item, and then the quantity box shows up to insert a value. When I put the quantity the 2nd box item shows up, but the box shows the item I choose in the 1st. Do you know a simple way of removing the value from the 1st box in the 2nd box? Best regards.
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 .
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?
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
I have been doing this for a WHILLLLE now. Probably as long as you considering I started playing in Preview circa 2016. This dhoozey always has me coming back to the books. Just one of those things, I guess. This actually adds a little more complexity when you have Dataverse as a source and the fields in your form are CDM choices such as "Months" or "Fiscal Years". Because it stets the items property to Choices(Months) and Choices(Fiscal Years) rather than Choices([@YourDataSource].Column).
Hi Shane! Thanks for the combobox tutorial. I have a question though. I'm trying to get the default values inside the combo box within the 'defaultselecteditems' property. While it does show the values inside the combobox, the values cannot be retrieved or displayed and the combobox is considered as empty unless the values are re-selected. Is there a workaround for this? thanks!
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.
Hey man thanks for the video. Can you make the video about setting default selected item for a combobox that is an Office 365 User Search then patching it to sharepoint?
Hours of looking on Microsoft's documentation and you salved my problem in 5 minutes. Well done!
Awesome 😎
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”
Saved my life on that comma-delimited source... Appreciate your videos man! Life saver!
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!
Glad you got it. 😊
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
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. 😊
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.
Glad I could help, I hope your head doesn't hurt too bad. :)
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)"
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.
Awesome! Thank you!
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.
That is awesome 😎
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!!
Looking under the hood like this is always expands my understanding. Thank you.
That was my hope. 😍
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
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😍
Glad I could help
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!
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!
Awesome!
3 yrs later you solved my issue! Thank you for your videos!
Great to hear!
I was struggling to get a comboBox to work with a default value from a Sharepoint item. This helped me a lot, thank you!😁
Glad you got it, combo boxes are so frustrating.
seriously you are a life saver! this turorial gave the idea how I should go with this defaultSelectedItems. thanks!
Awesome! 🐶
Thank you for going the extra mile! Those are the videos that help! Anyone can be basic!
You are so welcome!
I have referred back to this video so many times. Thank you for continuing to make useful content!
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.
Awesome, glad to help. 😎
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!!!!
Excellent video. Concise, yet thorough, as usual.
Much appreciated!
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 !
Still valid in 2024. Help me save so much time figuring this out by myself. Real guru
Awesome, glad to help. DefaultSelectedItems is one of the hardest concepts in Power Apps.
@@ShanesCows thank you Master
When I have an issue I almost always end up at your videos! I just need to start coming here first :)
You do. 😜 Glad to help.
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
Awesome. Makes my day when someone understands the deeper concept then just the answer. Good job! 🐶
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 🤦♂️🤦♂️🤦♂️
Glad to help Frank.
thanks for the tip about the split function and the renaming the column from result to Value
Glad it helped!
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!!
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
Thank you for your contribution. I was struggling with the combo box and was looking for some help
You are welcome!
Shane thanks for all your videos, you keep me inspired on learning new stuff, you're my idol :) !
Happy to hear that!
Great video. Exactly what I was looking for. Keep up the awesome work.
Glad it helped!
@@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: ""
}
Wow what a great tricks. You alway teach me new thing. Thank you so much Shane
Glad you enjoyed it!
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.
Thanks for the support. 🐶 We will take your once and appreciate it.
You did so much heavy lifting buddy kudos to you.
Awesome job, Thanks a lot !!!!
Happy to help. Have a great day. 🐶
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)
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.
On change can cause loopiong. Maybe force the user to press a button to do the save instead of OnChange?
he did a very good video on changing just one record in a gallery and saving/updating it.
Thank you, I wish the powerapps docs had more example of how to use the various controls
😊 more is always better
THANK YOU! Excellent, easy to understand, to the point!
Happy to help. Have a great day. 🐶
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!
I wish I knew, I wish I knew. 🥲
Great explanation, I have a collection of persons, I need to select default all the persons. Thanks.
Glad it was helpful!
Thank you for another great video Shane.
Glad you enjoyed it
You read my mind with this issue Shane! Multi Select filter to Multi Select!
Awesome
Hi Shane, I have had a lot of trouble setting the default selected items of a combo box when looking at a choices column.
This seems to be a fundamental thing in Dataverse / Power Apps, using a combo box for a choices column but wow is it hard to find a way to set the default selected item.
You mention the solution during the video, I use something like this: {Value: varRecord.'Choices Column'}. I use this in several places in almost all of the apps I build. Thanks for dropping that in there. I feel like this should be a bigger deal...
This is the only place I have found this technique mentioned.
Shane, you are very good, you saved me again.
Thanks, my problem was whith record value and I could not understand the problem, you video was was amazing for me.
You're welcome!
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
Thanks for the good info! What about add "ALL" be the first item in the combobox list?
Pure spun gold, Shane
Thanks Carlos!
I am bookmarking this one. Thanks! One thing I wish you could cover in the future is how to populate a Person combobox with filtered people from another List. Like how do you show available Counselors in that combobox so that the user must select one of those. The problem is that a FILTER() in items will make that combobox loose its Person schema and you no longer can display Email, Picture, etc. out the combobox selection. Plus saving the selection and coming back to the form how do you do the DefaulSelectedItems to show what was previously selected and to display the Picture in a separate image control?
You could do a lookup, for 1 row, or a filter, for multiple selections, on the original data source using the selected items from the last combo box
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
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.
@@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?
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 :)
@@POng-lq6yj Last(CollectionName) Will return the last record. :)
@@ShanesCows Thank you. I’ll try it tomorrow. You have been so helpful with my journey to Power Apps. Love your videos!
You are a true life saver. Thanks mate 👍👍👍👍👍👍 More thumbs up 👍👍👍👍👍 Thx
Glad it helped
Thank you for this video. you are awesome Shane!
My pleasure!
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
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?
I don't have any good ideas. ☹
Fun to watch learning at the same time. Thanks a lot!
Glad you enjoyed it!
Thanks! Makes sense now on the combo defaults.
Happy to help. Have a great day. 🐶
Thanking you later. Great recap, Shane!
Appreciate it Patrick. 😎
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!
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..
Thanks for sharing! 🐶
How to use that coalesce and where we have use it?
have you fixed this issue when opening the combo box its not getting selected the value which are showing in default selected items???
Really awesome... thanks for this video... it was very useful for me... :)
Most welcome 😊
Awesome video Shane I learned a couple of really cool stuff from this video!
I have a question, how can I use the Combo Box and New Form thus when I type the name in the Combo Box, it shows me the record in Edit Mode Form?
Thanks for your help!
You would want to set the Item property of the form to be the ComboBox.Selected assuming they both were usign the same data source
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?
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.
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.
Always rely on you Shane! Stupid past me stored a column as a text value, with the control in the app a combobox, then the customer says we want multiple values in that column. Crap i cant change it to a lookup now i will loose all my data! Split to the rescue with rename columns haha Thanks!
Perfect 👌
Thanks!
Appreciate the support. 😎
Thanks a ton for this video! Helped a lot!
You're welcome!
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!?
I use PowerApps with integrated sharepoint list. I have a problem when it comes to editing an item from the list:
To be able to display the already selected item content in edit mode, do I have to set the DefaultSelectedItem = SharePointIntegration.Selected. This works. However, I have 3 input depending on each other, using filters. [Boat (Lv. 1), Main Component (Lv. 2), Sub-Component (Lv. 3)]. Which means that the choices in the comboboxes depends on the selection in the level above. For example two different boat choices, the main component drop down choices is depending on the selected boat, and the sub-component is depending on the main component. Therefore is there a need to reset the selections if any changes is made in a higher level. In the new item screen is the DefaultSelectedItem set to [], and I set the OnChange = Reset(…). This works, as the selection is set to blank. In the edit view is the same approach set to the item value, as it is the defaultselecteditem. I need to set the comboboxes on levels 2 and 3 to be blank OnChange in a higher level and not depending on the defaultselecteditem. Any suggestions?
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
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?
Distinct will help you only show unique values ruclips.net/video/VnadKWifkr8/видео.html
New Table function can add something to your Table ruclips.net/video/APCeZxcIpdg/видео.html
@@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 🙂
Just a tip. If you want to use combobox selecteditems as string use concat....for one item, concat(combobox.selecteditems, result & "") for few items concat(combobox.selecteditems, result & ",") well you will get an idea.
Yup. Very common pattern. I thnk I showed that in the combobox video. This one I was trying not to get too far off topic on defaults.
AT 8:14 I saw the Light! Thanks Shane!
Awesome Lance. Hope all is well. 😎
Another great video Shane. One question, have you done a video on combobox and how to display the current value from a selected gallery versus being able to select a item from the combobox on a new form and then how to write the new selection to the sql table that the form uses?
I just had this very issue, I had to save the selected record to a variable then use that like this.. If(editMode = true,Filter(Departments,Name = varSelectedItem.Department)).Name or this... If(editMode,LookUp(tbl_NonStockSuppliers,Name = varSelectedItem.Supplier,ThisRecord)) then just use patch/update for SQL
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?
Yes, as long as the table matches it will be happy. 😊
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?
If I follow correctly then yes. ruclips.net/video/gsk14D-CYRE/видео.html Use that video to learn how to patch the field directly.
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.
Thank you Shane for your excellent videos 🙏🏻
I have a form which is connected to two SharePoint lists, and I tried to filter a dropdown list so if one chooses Department A, the second dropdown list will be populated with its content from the other column from the same SharePoint list (the source of both dropdown lists is the same SharePoint list), but whatever I write in the formula nothing seem to work. Since the form includes DataCard and DataCardvalue, I believe I should write the formula different, but I don't know how. I'm aware there's a cascading solution, but I wanted to a create a straightforward solution, so users don't have to choose a value from the second dropdown list - it's will be populated automatically. Do you have any suggestions for each dropdown list?
In addition, I have two departments in the SharePoint list which include multiple values, so I wonder how will they be displayed in the dropdown list? Will the first value be populated? I prefer it will work this way, and not display multiple values.
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
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.
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.
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
ruclips.net/video/s85i8UWw2QM/видео.html I have a whole video on ways to do it. 😀
@@ShanesCows Thankyou.. It helps me lot
Hi Shane,
I want to set current logged in user as default selected person then can add more people from people picker combobox. Below things I have done and hoping you would help!!
I have people picker combo box and data source is SharePoint. Combo box is set to true to allow multiple selection. On AppStart I set "Set(CurrentUser, Office365Users.MyProfile());" I have datacard which to I used DefaultSelectedItem and set "CurrentUser". To update item property of datacard I used "DataCard1.SelectedItems" but seems like it says record expected then when I change to "DataCard1.Selected" then it only takes 1 value which I selected and removes DefaultSelectedItem and other selection.
Shane, thank you very much, I mean really MUCH ;-) I spent so much time on this apparently easy thing. …
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?
ClearCollect(yourCollection, Combobox1.SelectedItems)
Hello Shane, thanks to your tutorials I have recently build my first app. Your presentation is clear and understandable and energy is great! Thank you. I have however ran into a problem and I cannot find a solution anywhere. I want to use combobox to filter the records in vertical galery. The items of the combobox are added with Distinct function. The filter works, but the options are invisible . The user can choose them but is unable to see which option he is choosing. Have you ever ran into such problem? is there a remedy for this?
Check the Field you are displaying in the Combobox. It is over on the right under the data source.
@@ShanesCows Hello, yes, the issue was in the Field propoerty. Apparently when Distinct is used to fill the combobox the Result field must be added to the fields. Thanks!
Thanks Shane, always appreciate your videos. I'm using the steps provided in your repeating table videos and have added a combo box to the gallery. The combo box selections do save in the collection. When I create a new record in the gallery, the context in the saved text fields remain on the display but the combo box selected item disappears. What am I missing?
Tak!
Thank you for the support. 😎
Hey Shane... thanks for all the great videos.
I tried something and didn't manage to solve it... so I changed my approach... but I'm curious to see you show how it can be done.
I had one gallery and one form to show that record... and then I had another smaller form for users to fill out "requests" on the selected gallery Record...
The second form had one prepopulated field for the "Record ID" from the selected gallery record, so I could keep track on which record the request was attached to.
However in my attempts to be "clever" I used two sharepoint lists... where that ID-column in the second list was linked to the ID-column of the first list.
Now, no matter how I tried I couldn't get that column populated with the selected records ID when I submitted the second form.
So finally I just turned it into a simple number column to get it to work.
But I would love to know how it was supposed to be done... because I think I was close...
Hey Shane great video. I do have a question for you or anyone in the comments. I am building a app that connects to SharePoint data source and i have a combo box that shows the list but I have multiple items the same name I have used distinct to filter the other out but when i do the "Allow Searching" flips to false and when i flips it back it it changes again. Is there a way to keep the search function?
Once again, great content Shane, thank you very much!
In one of my apps my registering several items according the distinct value of a table. For instance, it starts asking for a item, and then the quantity box shows up to insert a value. When I put the quantity the 2nd box item shows up, but the box shows the item I choose in the 1st. Do you know a simple way of removing the value from the 1st box in the 2nd box?
Best regards.
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 .
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?
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
I have been doing this for a WHILLLLE now. Probably as long as you considering I started playing in Preview circa 2016. This dhoozey always has me coming back to the books. Just one of those things, I guess. This actually adds a little more complexity when you have Dataverse as a source and the fields in your form are CDM choices such as "Months" or "Fiscal Years". Because it stets the items property to Choices(Months) and Choices(Fiscal Years) rather than Choices([@YourDataSource].Column).
Thanks for sharing. 😀
Hi Shane! Thanks for the combobox tutorial. I have a question though. I'm trying to get the default values inside the combo box within the 'defaultselecteditems' property. While it does show the values inside the combobox, the values cannot be retrieved or displayed and the combobox is considered as empty unless the values are re-selected.
Is there a workaround for this? thanks!
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.
Hey man thanks for the video.
Can you make the video about setting default selected item for a combobox that is an Office 365 User Search then patching it to sharepoint?
Thanks Shane, you are the best!!!!!!
Thanks 🙏