Power Apps Combo Box DefaultSelectedItems
ฝัง
- เผยแพร่เมื่อ 29 ก.ย. 2024
- It is no secret that the Combo box is a grumpy control. So in this video I break down how to make it less grumpy by setting its default(s). I also teach a bit on the Table function, in operator, and hand crafting a record. Good ole fashion nerdy fun!
Power Apps Consulting and training at www.PowerApps9...
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: ""
}
nice one Shane
Thanks Max
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
Saved my life on that comma-delimited source... Appreciate your videos man! Life saver!
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.
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...
Hey Shane, great video! While the default item "appears" in the combobox using your method, it won't actually register as selected if you reference the combobox from another control to identify which items were selected. It also won't patch the selected items correctly. It seems with the combobox, one has to actually physically 'select' the items in order for other controls to see what has been selected. Any idea how to deal with this issue?
same case for me have you found any solution
same for me
Me too - so frustrating! PowerApps *thinks* the box is BLANK until you go in and re-select the item again! I need to do some logic to compare the default selected item with another control but it won't work!!!!
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)"
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???
I thank You immediately and not later ;-). But what a load of crap PowerFX is, as a C# developer I'm shocked at what MS has messed up.
Thanks. I guess the only good news is Power FX is still a work in progress. Hopefully they get it to a place that works better for you.
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. ☹
Error- Comobox displays the default selected value but on reset the Value of combobox.selected.value is BLANK even the combo box display the default value
I have ran into that bug a few times also. 😳 I don't have an easy fix. Last time I was able to switch to a dropdown and that saved the day for me. Sorry
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. 🥲
Thanks a ton for this video! Helped a lot!
You're welcome!
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. th-cam.com/video/gsk14D-CYRE/w-d-xo.html Use that video to learn how to patch the field directly.
Looking under the hood like this is always expands my understanding. Thank you.
That was my hope. 😍
Thanks, my problem was whith record value and I could not understand the problem, you video was was amazing for me.
You're welcome!
I was showing default selected items in combobox but not highlighting the items of the combobox inside.
I have had that happen before. 😔 Not sure I have a fix when it decides to do that.
You did so much heavy lifting buddy kudos to you.
Awesome job, Thanks a lot !!!!
Happy to help. Have a great day. 🐶
ComboBox and Dropdown like very much, but for Teams there is no Dropdown Control?
Correct. You can copy it from a normal app or turn on classic controls under experimental settings.
How do you display selected items in the combo box vertically instead of horizontally?
I don’t believe that you can
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.
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.
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. 😊
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.
You are a true life saver. Thanks mate 👍👍👍👍👍👍 More thumbs up 👍👍👍👍👍 Thx
Glad it helped
I was using Default instead DefaultSelectedItems ajajajaj thanks!!!!
Glad you got it!
Really awesome... thanks for this video... it was very useful for me... :)
Most 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!?
EXCELLENT !
And I seldom use the capital letters 😃
Happy to help. Have a great day. 🐶
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 th-cam.com/video/VnadKWifkr8/w-d-xo.html
New Table function can add something to your Table th-cam.com/video/APCeZxcIpdg/w-d-xo.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 🙂
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.
This is very usedfull information, thank for sharing.
Happy to help. Have a great day. 🐶
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.
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
th-cam.com/video/s85i8UWw2QM/w-d-xo.html I have a whole video on ways to do it. 😀
@@ShanesCows Thankyou.. It helps me lot
Thanking you later. Great recap, Shane!
Appreciate it Patrick. 😎
LookUp(Employees, 'First Name'="Chewy")
LookUp(Employees, 'Department'=Dropdown1.Selected.Result)
["Yes", "No", "Maybe"] => {Value:"Yes"}
Table({Value: "Yes"}, {Value: "No"})
btn.onSelect=Set(varDefaults, "Yes,Maybe") => Split(varDefaults, ",") => RenameColumns(Split(varDefaults, ","), "Result", "Value")
Filter(["Yes", "No", "Maybe"], Value in varDefaults)
Great video, congrats! I'v a doubt. I'm trying to create a validation of condition for a fdefault value and im using the formule for this as well below:
If(DataCardValue34 , "","N/A")
But when i use the formule, i'v the issue below:
Parenclose w. EOF expected issue
Issue
Unexpected characters. Formula contains 'Eof'
where 'ParenClose' is expected.
This error occurs if, for example, a formula
contains '{Val@ 7}' instead of '{Val: 7}'. When you
define a variable, the syntax requires a colon
of an "at" symbol.
Location
DataCardValue35 .Default
How to fix
Remove or replace unexpected characters
by an expected character.
can you help me with that?
Nope, the Lookup returns nothing. I'm trying to set a default on a lookup column so instead of using 'First Name' = "Chewey", I'm using Band.Value = "SomeBand" and this doesnt return anything. I even tried wrapping it with the 'Plaintext' function. Nothing seems to work.
Trust Microsoft to put out something that makes EVERY SINGLE step of what you're trying to accomplish a nightmare. That's EVERY STEP. Wouldn't it be nice if they provided an actual functional and INTUITIVE way of doing anything?!
Thank you for this video. you are awesome Shane!
My pleasure!
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.
Just incase If some is looking to update Comobox (MultiSelect) in SP.
ProjectCode is Single Line/Text in SP
Update: Concat(CB_ProjectCode_1.SelectedItems,Result,", ")
DefaultSelectedItems: Split(varRecord.ProjectCode,", ").Result
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
I've got a new item form with a Combobox which saves the selected items in a SharePoint long text column separated by ",". In order to show the selected items in DefaultSelectedItems when I use the form in Edit/view mode I'm using the following code: Split(PlainText(Selectd_Item), ",")
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?
your tutorial to much curved not straight to the point..
THis is a very complicted topic, unfortunately you have to understand those extra details to set this in the real world.
Frustrating how the combo box control in PowerApps lacks a collapse "x" though a desktop browser. The only way to collapse the selection drop down is to lose focus (aka randomly click somewhere else). Ironically, the combo box does have a collapse feature when the application is run on iOS through the PowerApps player.
Jeff i think the Combo Boxes middle name is frustration. 😐 It is painful to use but great when it does work.
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.
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.
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
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
What if I don't type anything. Is it possible not to show all results? I just want to type to show results.
You could set the Items property to be Filter(Datasource, Startswith... ) and then Combobox1.SearchText
I don't have it in front of me but that is the basic concept.
@@ShanesCows thank you. Hope you will have a video tutorial for that one. 😊
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?
This is helpful, but it's not working for me using a people picker. I can get the user's information to load using DefaultSelectedItems, but the update does not save the value no matter what I try to do. It's a record. It's looking for a record. And yet it has been denying me all day long.
Thank you for providing me with the answer as to why DefaultSelectedItems does not show those values as selected in the list that is displayed.
Allow me to be irate for you here as I wasted a ton of time on this for no valid reason. This is the stupidest implementation of a control I have seen. If I derive the combo box items from a collection or a data source the combo box control SHOULD NOT need to do do matching on anything more than the fields that make up the items table. You said it your self. To get the default item to display as selected in the items list you must provide the control with a complete record from the source of the items even if you whittled it down to one column/value from the source. This forces an unnecessary a lookup to get the full row from the source just so the combo box will work properly. That is ridiculous. What exactly is it looking for, ID? Oh, wait that is a secret only Microsoft knows. So much for the low code philosophy.
DefaultSelectedItems seems to be now deprecated. I cant see it in the list. Default is working with lists too.
DefaultSelectedItems is still there for Combo box. It doesn't exist for dropdowns. Is that possibly your issue.
@@ShanesCows Yes.. correct. 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.
How can we just select the first item regardless of what it is?
Try the First function. First(Datasource) in DefaultSelectedItems should work.
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?
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.
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
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! 🐶
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 ?
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.
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?
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. 😎
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.
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!
Shane, thank you very much, I mean really MUCH ;-) I spent so much time on this apparently easy thing. …
I shoud have seen this video 5 hours ago :-/ THX
Sorry Frank
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
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
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. 😊
Please help, I am able to populate the Combo box but when I open the combo box its not showing currently default selected items
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
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 👍👍
Yes as long as tbl1 and tble2 have the same structure you could put an If statement in the Items property of the combobox
I want to achieve combobox with People picker and Want to add default users to the combobox selected from another screen.
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.
I am not sure. 😑
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.
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??
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?
Not sure. I haven’t ran into that.
Thank you for another great video Shane.
Glad you enjoyed it
Thanks for the good info! What about add "ALL" be the first item in the combobox list?
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
Hi Shane, your quick tip on Split() saved my butt after spending hours on sorting out the defaultSelectedItems in the way it was expected! Thank you very much :)
Anyway, let me share with you the issue I had. I appreciate it if you can please advise me what could have gone wrong.
I am using a ComboBox (SelectMultiple = true, IsSearchable = true) for making a so-called Active Directory using Office365Users:
Items = Office365Users.SearchUser({searchTerm: ExcSponsorCombo.SearchText, top:10});
I concatenate the SelectedItems as
Set(varExcSponsors, Concat(ExcSponsorCombo.SelectedItems, DisplayName, "\\\"));
Then have
DefaultSelectedItems = If(IsBlank(varExcSponsors), Filter(Office365Users.SearchUser({searchTerm: ExcSponsorCombo.SearchText, top:10}), DisplayName =""), Filter(Office365Users.SearchUser({searchTerm: ExcSponsorCombo.SearchText, top:10}), DisplayName in varExcSponsors));
I tried to have data source in Items and DefaultSelectedItems the same but it does not filter out the DisplayName per concatenated items in varExcSponsors.
Thank you,
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!
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!
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
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 👌
Hi Shane. Do you know how to filter the combo box that has status reason values to only show inactive status reasons?
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)
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)
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..
I don't know. I have never tried it but does seem like a cool idea. I will think about it.
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. 😊
Mr. you saved my life haha
Awesome 👏
You solved my issue..thank u so much
Awesome! 🤩
I think you have started video ..after having RED BULL...😂...too much energy...
I was tired so I was over compensating I guess. 🤩
Shane, struggling here.... I have Office365Users.SearchUser({searchTerm:User().Email}).DisplayName in DefaultSelectedItems of my combo box. It is behaving correctly (my gallery is showing this), BUT it's not displaying in the combo box. so to "see all" I have to re-select the current user name, then deselect it to show all in my gallery.... I've spent days researching this.... have you experienced this?
AT 8:14 I saw the Light! Thanks Shane!
Awesome Lance. Hope all is well. 😎
Thank you for going the extra mile! Those are the videos that help! Anyone can be basic!
You are so welcome!