There is a handy feature the combobox provides when you want to have a tiny "preview" of text in a gallery and have limited space. If you set the combobox to View mode. Then Set it's defaultselecteditems to {Value:ThisItem.TextColumnName}. If the length of the text/entry is longer than the width of the combobox, it'll shorten it and do a "...More", which you can click and it'll provide a popout of all the text. I use it for an issue tracking card. It'll show the first bit of the issue, if the issue is long, you can click "More" and it'll show all the issue text.
i just wanna ask, is it possible the combo box can put 7 to 8 selected item without it showing "7 items" ? means, I want it to show all the name that i have selected
Many thanks! Any idea why the ‘hint’ text I have got seems to get duplicated and is slightly out of line with the original when I click on the Dropbox? Also, I am using a Person column and I am unable to show the items in a list when I click on the down arrow? Only the search box appears? I can see items in another kind of CHOICE column?
I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi Reza, Hope everything is going awesome with you, I have one question is there a way to present SharePoint View in PowerApps Gallery as we can create multiple SharePoint views on large data set. If there is any way then it will make using PowerApps much easier for large dataset. If there are ways then I would love if you can enlighten us with your amazing demonstration and guidance.
This is very useful information, but I'm faced with a scenario that I can't seem to find explained in any of your videos. I have a SharePoint list with a multi-select choice column ("Role"). What I'd like to do is, in an app, use a combo box to display as choices, each of the "Role" values that's in use in the list. For example, the choices in the Role column are Faculty, Staff, Student, External. Most entries have a single value selected, but some have more than one. Currently, there are NO entries where External is selected. I want to use a combo box in an app to display the choices, excluding External (because no entries have that value selected). I've tried using "Distinct(Source,Role)" (and a number of other variations), but the combo box remains blank. If I populate a collection with that same formula, each record is an array. So, I somehow need to expand those "internal" arrays in order to find out which values are used in each and then get a unique/distinct list of those values. Any help or guidance you can provide would be very appreciated!
I do not have a video reference on this scenario and would have to try it out to provide guidance or provide any inputs. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@@RezaDorrani I did a bit of searching through there but couldn't find anyone with a similar scenario. I can post there with a video to show what I've already tried. In theory, if I could figure out how to get the union of the arrays of values stored in each item in the list, that would do it, I think. It would probably not be a delegable operation, but I'm ok with that.
Please, Good morning, i have been following your videos on RUclips on Microsoft Power Apps creation. Please, is application created in Power Apps just for Organizations or anyone else can use it after creation
Thank you so much for this content, I want to search within a unique text value field on the SharePoint list based on text input, if the value is there on SP list, populate the entire row and may be then edit/update the same. And if such a value is not there in the SP list, then I would like to let the user insert a new record into SP list. Is this double? Kindly refer to a relevant youtube reference video if possible.
Most welcome. I do not have a video reference on the scenario you mentioned and would have to try it out to know its feasibility. I would recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Very rich, indeed. Question: @25:05 "Manufacturer.Value" does not work when I reference a Choice column in a dataverse table. Why? Instead, I used Choices(Manufacturer) and it worked. However, I don't know how to convert this choice to text so that I use with Concat function.
Because Dataverse choice columns are not same as SharePoint. They return enum values. I have not tried with Dataverse choice column. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Thanks, Reza, you are one of the best Tech Guru available on this platform, the way you explain topics is Topnotch, kindly request you to do one full app development using all the functionalities in powerapps in one sequence step by step by procedure, thanks
Thanks for the video! If I want to filter the combobox based on a toggle, but the toggle should be related to a Yes/No column in a different list. Would that be possible?
If this channel have a step by step comprehensive course to Power Apps then it would be the best dedicated channel in the world without a question, great work though!!
Hello Rezza, Thank you for this video. I encountered an issue that while the form is in new mode and the checkbox are selected, even after closing the form those values are not reset and appear as soon as we open the next instance of the new form. This occurs until we refresh the page. This is resolved by resetting the variable if it is blank in the checkbox reset property.
@@RezaDorrani Thank you Rezaa for responding back. I tried to test this on other user profile and lists, and this occurred there as well. The checkbox is not reset until we refresh the browser. Even the Edit/View from showed the last selected option. Yes, it was resolved by resetting the checkbox. Thank you for your kind response and your videos. Love from India. :)
Great. Very useful content. Thanks a lot Reza. Also, please try to showcase us on how to effectively migrate "Power Apps" and "Power Automate" from one environment (Dev env. to UAT and Prod). Once again thanks very much for your efforts.
Hey Reza, I cannot thank you enough for the amount of information youve shared and all the help you've done. I've been working on an combo box option and couldn't get through for months, could you help me with this ? Using combo box as people picker connected to office365, I'm not able to write back the selected item back to MS lists (people column). The Update prop is set to combobox.selected (since it only accepts records). Many thanks Reza😊
ruclips.net/video/BzZ0a3zRFUk/видео.html & ruclips.net/video/g9ChYuTdNd4/видео.html may help. I would also recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Thank you Reza. This is Uber Cool! Indeed the ComboBox is a mystery control😃.. Not anymore.. if we add the new Fluent UI control, will it 'break' the app when we migrate the app..not as such completely per say but as it is still in preview mode?
Reza, I really appreciate your hard work with your videos, you've helped me a lot. I've been wanting to ask you since I can't find an answer. If I have form created from a SharePoint list, in the form I have a people picker with multiple selections ON, the source column needs to be Person type in my SharePoint list. What would happen when using a gallery to view a record of my SharePoint list if at least one of the employees selected is not within the company anymore? In SharePoint, is the person's metadata lost?
I don’t think metadata gets lost. My guess is it would continue to work fine. But I have not come across this scenario before. I will also recommend checking on forums at powerusers.microsoft.com in case someone has done something similar
Hello, I was wondering if you had a video which explained how to auto select in a second combobox as a result of the selection of the first. So for example, you select a site location from combobox 1 which auto populates the site ID in combobox 2. Thanks
I do not have a video reference on this scenario. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Thank you very much for the video, it was very helpful. One question, how do you allow users to enter in their own answer if it is not in the list (SharePoint linked). thank you
Most welcome! I do not have a video reference on the scenario mentioned and would have to try it out to provide guidance. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hello Reza, great content! Very helpful. I was trying out the combo-box where the values are connected to another source data in sharepoint. Whenever, I close the PowerApps pages upon editing and go back to the Sharepoint List view, when I add a new test data into my list, the fields, including the combo-box appear to work, however, upon save, the data values selected under the combo-box disappears. My source data has over 200 rows
I have not come across this issue and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Reza, I can always learn something new from you whenver I watch any of your videos. Thank you for your hard work. I like the idea to copy the modern combo box in Teams to a canvas app. I tested it and connected it to a SharePoint choice column. Unfortunately, It didn't work for me. Can you let me know what went wrong? Thanks in advance.
Thank You so much for your kind words. So happy to hear the feedback. After connecting to ur choice column, go to fields and ensure value is selected there and is the first field.
Hi Raza, I am trying to show activities from Activity list in a lookup dropdown in Activity list but i want to show only only Activities where logged in user is the Lead (Lead is people picker column in Activity list.)
I do not have a reference on this and something that I would have to try out to know more. Il recommend posting your query on forums powerusers.microsoft.com
@Reza Dorrani Here is my solution, and its working fine. Filter(Choices([@'Activity Updates '].Activity),Lookup('Activity List', ActivityTitle =Value, Lead.Email)=User().Email) Make sure in SharePoint list, goto Lead field (people picker) and Show Field dropdown select Name (DO NOT SELECT NAME WITH PRESENCE)
Thanks @Reza for your videos, they are concise and comprehensive, the place to learn from. In minute 18:08 you explained how you can copy and paste the modern combobox from PowerApps in Teams into PowerApps. I have replicated the steps but the copied modern combobox from PowerApps in Teams turned into a simple Label in PowerApps. Is there any setting i should modify?
Hi Reza, Great videos :) I have created a form with multiple fields for a user to enter information. As there are lots of fields, it is vital keyboard shortcuts can be used. When I try to use keyboard shortcuts on a combo box, it doesn't seem to be that user friendly. Here are the Steps I take: 1. Type in the combo box to search 2. Click on the down arrow (It moves to the clear 'X' button) 3. Click on the down arrow (it moves to the dropdown list) 4. Click on Return to select the value. Is there any way of removing step 2 or a shortcut I am missing? Thanks in advance!
Thanks. I am not aware of shortcuts related to combo box. I will recommend checking on forums at powerusers.microsoft.com in case someone has done this
@Reza Dorrani Thanks you so much i have a question on combo box and People picker column on share point. i want to update multiselected peoples from combo box to sharepoint people picker column i tried every way but unable to update please guide me thanks for your great effort.
@@RezaDorrani Form control. In addition to that one more question ,i want to set default selected items of combo box from Sharepoint people picker column last record(Last set users) as I tried but it's getting error while submitting form as below. please guide me.Thanks again for your time as am stuck on this for long time appriciate your efforts on reply. error ⇒The requested operation is invalid. Server Response: Operation members list: The specified user i:0#.f|membership| could not be found.
@@manjunathpatil6785 That’s a weird requirement to set value of a control based on last submitted. Check my video on form control. I have 2 of them. They will give you some ideas. I will also recommend posting on forums.
Great wok Raza.. I need help with sorting out an issue. I have a combobox with the Item Property bound to Sharepoint. I want to allow users to enter free text in the combobox, and I want that free text to be saved. I noticed that the onchange property of the combobox for searchText is not working as expected. I want the searchText value to be stored in a collection when the onchange property is triggered. Your help is greatly appreciated.
I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
5 месяцев назад
Hi all! for some reason, at 12:02, the part where I'm supposed to be able to grab my datamodel, I just can't. I am using a SP list and tried different ways to call my column, but no luck. Any ideas? thanks!!
I have not come across this and hence not sure what the cause for it could be. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
I would like to ask your opinion how to trick out the 2000 row limit at the combobox datasource. In this video you simply add a filter before it and it worked well in this scenario. There is any way to use the combox's serchfield to filter the datasource? So when you start to type characters to the combox it will filter the datasource, so you can see limited datas in its dropdown (expected under 2000 rows). I was thinking about it, but simply it wasn't work because it's effects later, than the datasource was loaded. Have you got any idea to solve the problem? Thanks :)
"but simply it wasn't work because it's effects later, than the datasource was loaded." - Not sure why it doesnt work! I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani Thank you. I found other way: OnStart clearcollect to a new collection and using the collection to get all item into the combobox's dropdown.
I probably have done a few on it but that would probably not be the title of the video. I have done 200+ videos. Sorry but I don’t remember which ones.
Hi Reza, great video. But I'm facing one issue while trying to do AddColumns in items property. The thing is that when i try to addcolumns it shows multiple column values fine but when i try to submit it to sharepoint list the value doesn't go to the sharepoint list at all? Any idea how i can fix it. Thanks
Thanks! I have not experienced the mentioned issue and hence not sure what the cause for it could be. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
@@RezaDorrani the two videos talk about dropdown cascade ... if possible can you make a combobox cascade video please ... i'm doing a project and it's the last part that cause me problem
@@abdourahmanediallo9430 I make videos when I receive multiple requests on a topic. Every quarter I ask subscribers for topic suggestions on Community tab of my channel. Make sure to post this idea whenever the next topic post comes out. If it gets max votes, I will add it to my backlog
I have a SharePoint list containing 50,000 items with one of the column is Lookup ie. "Area". I need to retrieve items with an ID between 1 to 50000 based on the OnChange property of a multi-select ComboBox (Area column values are given in Item property) in Power Apps. But I don't want to use Collection for 50000 SP List items. How can I accomplish this?
Combox box has the limit of delegation. I would recommend reading about delegation. Also, I have not come across a scenario with lookup of large data so not sure what the best approach would be. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Hii..Reza , I am facing with issues with my Power Apps I have created a combobox and Text input In combobox I have list various products and in Text box input I have used lookup formula in default property , Its work fine for selected products but I need to sum up all multiple selected valves in combo box of selected products I shows only the recent selected valves for recent selected products in Text box input pls suggests how can we achieve this Lookup formula as used is as below LookUp(Table5,Product=ComboBox1.Selected.Product,'Wt per Box') what changes need to be made pls suggests as soon so that it automatically sum up selected valves
I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hello Reza, I'm currently using Oracle as my data source. I've experimented with several approaches, but I'm encountering difficulty in conducting case-insensitive searches within a combo box. Specifically, when I search for "fire," it doesn't display any items if the actual item is spelled as "FIRE." Is there a solution to address this case sensitivity issue? I would appreciate any guidance on overcoming this challenge. Thank you.
I have not done any work with Oracle as a data source. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Thanks Reza. You've answered my question 100% about having access to the extra data related to the search items. (Just like the old "Access" days) . Concatenating extra information is a real bonus.
I have a search page gallery with a combo box with allow multiple selection set to true. the defaultselected item is LookUp('A sharepoint List',Title=avariable) but when the combobox loads it shows only with the default item. once I click on an item from the search gallery and go back to the previous screen then combo box shows all items with the correct defaultseletecteditem. How do I fix this
I do not have a video reference on this and would have to try it out to provide guidance. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Hi, Great Video. Can you please help on below scenario. I have single Edit form which has Combobox connected with SharePoint list. User select the value from Combobox and submit the details (Update - Selected.result) The value is then updated into another SP list. Now, After submit I'm using same form as NewForm to enter new record. I don't need to reset the form. whatever the value selected in Last submit it should show the same value into the Combobox. Hoe can I achieve this?
I do not have a video reference on this scenario and would have to recreate your scenario to provide guidance. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com in case someone has done something similar
Hei Reza, I have a combobox in an app and i have a a little more than 2000 items in a SharePoint list, i have use the filter: Filter(INT_ISYPOProsjekt, Prosjektstatus = "Godkjent") and that reduces the items to 863, but i still can not find one of the items that seems to be after the 2000 items limit, is there a way to get these items searchable to the combobox? I thought the filter would solve the delegation issue, is there a work around? I have also try with a collection, but it does not work either, i get the same problem. Thanks a lot!
Hi Reza, nice content. All your videos help me a lot. In modern combo box control search office365 users is working but once type the username and select it shows just for a sec and immediately disappears. Is it still a bug or any solution on this? Please help to understand. Thanks in advance.
Hello Reza, Has there been a solution for adding the search text as a new choice in the modern combobox. I have found many examples for the classic combobox (including yours). I have not been able to track this down on the internet. Thanks, E.
Hi Reza, can we set combo box list of values Searching with alphabets. I want show starting with that alphabet. ex. if Im searching with P. I want only those values are starting with P (not those values including P).
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?
I have not come across this issue and hence not sure what the cause or fix for it can be. I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Hi Reza I need some help on ,i have Combox but default value is empty,though varble i specify some text " Compare roles" , after i selected one option from Combox,next time when I go to home combobox showy to previous option in Combox.but I need to reset the comboxbox text "compare role" ...Could u please help how to reset combobox in other screen to default value
I do not have a specific video reference on this scenario and would have to try it out to know the steps and provide guidance. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Hi Reza, I have a query, On Change trigger of combo box control how to capture previous value before it is changed to new value. Please give a solution . Thanks
with Dataverse as backend. If I want to show a certain field in Combo box ( Delegation limit to 1 in setting) why it show only 1 item. Though Dataverse delegation limit is too high. If I bind to a Gallery it show all
Hello Reza Thanks for video. Its really great. How can i achieve the scenario that if user select status "new" and i just want to block user to chose further statuses like packaging, on-hold or completed?
I do not have a video reference on this scenario and would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani Yes. Since morning im digging on internet and there were no guidence about it whoch could be usefull on the future :) I just asked now on ms. Thanks. although someone help me on MS, i wait your videos :)
@@MikariN40 I make videos when I receive multiple requests on a topic. I don't see folks requesting this as it is very specific. Forums will be your best bet powerusers.microsoft.com/
Hello Reza, I tried to have the combo Box for people picker but it does not write back to my dataverse table. Do you have any work around to it? Thank for the help in Advanced
I dont think I showed dataverse table in video. SharePoint and Dataverse are different data sources. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi Reza, I am trying to fit two columns in one combox. For eg: I need to add ID and their description in one combo box. Not able to figure out how? Please could you help me?
What if I don't want to see autopopulated items when I just click that combobox? Is that possible? Because I want to see autopopulated items only when I type on something.
if I have more than 2000 items in the list. I want to show one column distinct Values in a Combo box it not shows all items distinct values. Instead it show some less number of items. Any solution for Distinct function with delegation ?
Hi Raza, Thank you for this wonderful video. I want to build a cascading combobox for filtering my gallery. If you have already made a video on this topic please share the link, I am not able to find that video. Please help
Try searching for “cascading dropdown reza dorrani” on youtube. You should get 2 videos on this. I have shown combo box based filter as well but probably not with multi-select filtering levels.
@@RezaDorrani That videos I have already watched it several times and they are really amazing but was not able to filter it for multi select. If you have any reference document or video please share it with me. Please
@@RezaDorrani You have done it in the last part of this video I just want to know how you filter the cascading combobox. When you select multiple manufacturers how does it shows list related to both those manufacturers?
How to restrict the employee names only to a list provided in SharePoint list. In the patch video you mentioned the use of collection I am struggling to achive it. Please help
I do not have a video reference on this scenario and would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
I have not come across the mentioned issue and hence not sure what the reason for your issue is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Hi Reza. Thank you for your great work. As for search fields I never succeeded in using more than 1 field for search. It is like the input for searchFields in the advanced tab was not used. Only the field selected in the interface on the first tab is used. Do you know why ?
@@RezaDorrani thanks for your answer. It looks like there is a bug anyway. European users have to create a typo error in the searchfields (example use a , instead of a ; ) to make a multiple fields search. And by multiple, looks like no more than 2 fields can be used
Hi Reza, I have a combobox inside the gallery which is connected to the SharePoint column "Projects" in sharepoint list A and the gallery is connected to SharePoint list B, I set the DefaultSelectedItems Property of the combobox as "ThisItem.Projects" which is throwing an error saying "This Formula uses scope, which is not presently supported for evaluation". Its a cascading combobox, 1st combobox is outside the gallery and 2nd dependent one is inside the gallery. what can I put in "DefaultSelectedItems" property of the Combobox inside the gallery where the data whatever is saved shows up ? Basically I am looking to display existing data from SharePoint into the Combobox which is inside the Gallery and "ThisItem.Column" is not working which works well with Dropdownlist. Thanks for the help!
I do not have a specific video reference on the mentioned scenario and would have to try it out to provide guidance. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
@@RezaDorrani I made it work!!! The drop-downs inside gallery have the Default "ThisItem.FieldName" and display the value required. The Combo Box however displays multiple lines and cannot display the value stored. Instead I added a label to the gallery and made the visible False, to the text of this label I added "ThisItem.FieldName" and to the "InputTextPlaceHolder" property of the Combobox inside the gallery I added Label.Text. 😀 here the combobox Multiselect is set to False. From a user interface point of view, it does the job required.!! Posted this work around here incase it helps. Thanks a lot Reza! #PowerApps #PowerAutomate
Hey, I want to be able to get the selected value of the combobox from it's default value but it always returns blank. I only get a value when manually selecting it
I have not come across the mentioned issue and hence not sure what the cause could be. I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Hi Reza , I am facing this problem in Power app from long ago but couldn’t find the exact solution for this . I am using multiple select people picker in my application form when I am patching while inserting new data it is working fine but while updating the data for the same record from gallery when I don’t change the persons in multi select drop-down getting this error “ 'Specified user i:0#.f|membership| could not be found" while trying to patch”. Please help me here
I have not come across this issue hence not sure what the fix or reason for your issue would be. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Hi Reza thank you so much for your inputs, i would like to know how to create people picker(only particular group of people, ex;people who belong to manager category) in dropdown or combo box. This would be a great help . Thanks
How do you define one belonging to manager category? Someone who has direct reports in AD? That should be possible I assume but I do not have a specific video reference for it. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@@divyashree4558 Possible. Connect the combo box Items property to that list. Once again, I do not have a video reference on this. I will recommend checking on the forums.
I checked in the forums but i couldnt get a solution, so i approached my power apps guru😊, its like i need to filter the persons who belongs to particular category and show only them when i click the dropdown.
@@divyashree4558 Forums will be your best bet. I also go to forums to assist but only in my free time. I do not have a video reference hence I cannot provide guidance unless I try it out and currently, I do not have any bandwidth.
Thank you Reza this really helps me a lot, once question though, how can I input text manually in case one of my dropdown is 'Others'? Thank you so much
Hi , thanks Reza, how do I get the index of the selected item in the combobox if I want to position it in a Gallery for the Select(Gallery, index) function. thx
Hi Reza, I'm still struggling to understand 'Defaults' Items = SortByColumns( AddColumns( ' Locations ', "FullLocation", Concatenate( Title, ", ", State, ", ", Postcode ) ), "Title" ) but I'm still having errors with my DefaultSelectedItems = ThisItem.FullLocation in ' Locations ' any ideas on where I'm going wrong 😣😣
I cannot make a guess by looking at code here on chat. There could be various reasons for it. Best to post your issue with screenshots on the forums at powerusers.microsoft.com
Hi Reza, is there any way to change formatting for primary text and secondary text separately? I have category and subcategory as two columns. I want to make the category (primary text) bold but not the subcategory (secondary text)? Thanks
@RezaDorrani All right. May be not with combo box but any workaround? I will elaborate on my use case: I have dropdowns which looks like sentences. Example: 1) Mercedes: It has the best suspension 2) Audi: It has the best braking system And so on... In every dropdown option, I wish to highlight the first word (may be with different font or weight) Is this doable with any control? Thanks! (I thought of using cascading dropdown but business requirements are not allowing)
So just to clarify; 1. The classic combobox allows multiple (searchable) display fields. 2. The modern dropbox does not allow multiple display fields and it does not have search as an option. 3. The Dataverse for Teams Combobox allows search but still doesn't allow for multiple display fields.
1 - Modern just released a combo box control that is searchable. Its in the latest app authoring versions. 2 - Modern only allows for single field display 3 - Don't use DVT combo box
Hi Reza, Thank you for your video. I've got the following question. I've got a Combox the items for which are selected on the basis of the existing Sharepoint list and DropBox selecteditem. Multiple selections are allowed. The selected items in the ComboBox (in my scenario the list of printers available to user extracted from resources sharepoint list and selected city ) should be inserted in the other sharepoint list (Requests). There is no problem to Concat the selected items and insert them into the new sharepoint list record. But I'm going to add approvals scenario (w/o Flow) which means that the form should be opened by the other user and display the selected on the previous step options. due to the fact the the variety of the selected items could be significant it means that the setting for the column in the Requests sharepoint list will be difficult to maintain to add all possible choices. Is it possible to insert several values from the dropdown into the sharepoint list column, if selected item is not defined in the choices option for the column? Despite the fact the adding of the new values is allowed I can't save selected items to the list.
Adding of new choices in dropdown is more of a sharepoint feature. I think there is a way to achieve it in power apps but something that I have never tried + I do not have any reference on it. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Dear Raza, I have an Excel sheet connected to my Powerapps Canvas Form and we use it as our data entry. The form has ComboBoxes and TextInput Fields. When we enter our data and submit, most of the relevant rows in excel are populated. Except some of the ComboBoxes are not. The problem is when I try to edit an existing case details, I would like to have the ComboBoxes filled by default in my PowerApps with the data from my Excel. All the TextInput fields are populated, but the ComboBoxes are empty and not interacting with Excel at all. Please advise and share any solutions to this. Many thanks,
I have not come across this issue or scenario with excel and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Thanks for this great video Reza. I had a question if you can guide: Is there an easy/straight forward way to validate if the value in Default Selected Item property of combo box is one of the values in Items property?
Excellent tutorial as usual. I have a question, I'd like to use the ComboBox to select "Approvers" (Items property points to AD), I'm then adding these Users into a List with additional columns, this is being done using the "on change" property of the ComboBox i.e. ForAll(Self.SelectedItems,.... As there are other columns in the List e.g. approval Date etc. What I haven't been able to figure out is how to remove / add changes to the list, as and when selections in the Combo Box change i.e. if a new person is added or existing person removed. Here's a scenario, 3 persons were selected and Patched to the List, out of the 3, 2 have clicked on Approve and data has been recorded. The 3rd person is unavailable and needs to be removed and an alternate approver needs to be added. How do I remove the 3rd person from the list and add the replacement, while not touching the 2 that have already approved?
I do not have a video reference on your scenario and would have to try it out to provide guidance. I will recommend posting your query with screenshots on the forums at powerusers.microsoft.com
There is no direct action to do that but you can show a message that only 5 selections are allowed or disable the submit button if more than 5 selections are made
That is not a direct option. I do not have a video reference on this scenario. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Still unclear about the no of items combobox can hold if I am using a SP list as datasource. Like If I want to show 10000+ values inside combobox, is it doable without any issues?
Thanks for this video. Can you share the syntax for Searching Users and groups from the active directory.. Currently using Office365Users.SearchUser({searchTerm:ComboBox1_1.SearchText,top:100}) but this helps to search only users . I need for groups too.
This function is not for searching groups. I am not sure what the group search function is. I will recommend checking on forums in case someone has done something similar powerusers.microsoft.com
Thanks...This really helps... e But one scenario that 1I 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... there more intuitive way to achieve this?
When combo box is edited in form, it will maintain the previous value for edit form. Most of my form based videos have shown that. As for the requirement on not selecting an already selected value, this is not something I have tried. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Ok when user open edit form even though there is a selected value in combobox it still says blank as it's mandatory column they are not able to submit again until they manually change the combobox value again .....how to resolve this?
@@sridharreddy1607 I have not experienced this issue, hence not sure how to resolve it. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
@@RezaDorrani I did but the query box (the one that appears when you start searching a person) shows blank. I noticed that it has the values but just looks blank. for example if I hover over it and click somewhere it will select a person but I have no way of finding out who I am selecting because the query box just seems blank. This is for Dataverse for Teams btw and on the published side only.
@@rorsara3940 Im not sure why that would be the case. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Can anyone tell me how we can highlight the values inside the combobox Iam showing default selected items for combobox But it is not highlighting inside the combobox
Have not experienced any issues with that, hence not sure. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
There is a handy feature the combobox provides when you want to have a tiny "preview" of text in a gallery and have limited space. If you set the combobox to View mode. Then Set it's defaultselecteditems to {Value:ThisItem.TextColumnName}. If the length of the text/entry is longer than the width of the combobox, it'll shorten it and do a "...More", which you can click and it'll provide a popout of all the text.
I use it for an issue tracking card. It'll show the first bit of the issue, if the issue is long, you can click "More" and it'll show all the issue text.
Thanks for sharing
Brilliant as usual, your content helps beginners in a big way.
Great to hear that! Thanks so much for watching.
This is beyond helpful; thank you!
You’re most welcome
Thank you so much for this video Reza. To filter office365 users, how can we filter based on userType: Guest or Member?
Its one of the properties in it. I dont have a specific video for it but I have seen responses on this on forums.
Check powerusers.microsoft.com/
i just wanna ask, is it possible the combo box can put 7 to 8 selected item without it showing "7 items" ? means, I want it to show all the name that i have selected
Combo box will need the width to fit those names. Not sure if there will be any real estate left.
Many thanks! Any idea why the ‘hint’ text I have got seems to get duplicated and is slightly out of line with the original when I click on the Dropbox? Also, I am using a Person column and I am unable to show the items in a list when I click on the down arrow? Only the search box appears? I can see items in another kind of CHOICE column?
I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi Reza, Hope everything is going awesome with you, I have one question is there a way to present SharePoint View in PowerApps Gallery as we can create multiple SharePoint views on large data set. If there is any way then it will make using PowerApps much easier for large dataset. If there are ways then I would love if you can enlighten us with your amazing demonstration and guidance.
Power Apps does not understand SharePoint Views. This is by design.
This is very useful information, but I'm faced with a scenario that I can't seem to find explained in any of your videos. I have a SharePoint list with a multi-select choice column ("Role"). What I'd like to do is, in an app, use a combo box to display as choices, each of the "Role" values that's in use in the list. For example, the choices in the Role column are Faculty, Staff, Student, External. Most entries have a single value selected, but some have more than one. Currently, there are NO entries where External is selected. I want to use a combo box in an app to display the choices, excluding External (because no entries have that value selected). I've tried using "Distinct(Source,Role)" (and a number of other variations), but the combo box remains blank. If I populate a collection with that same formula, each record is an array. So, I somehow need to expand those "internal" arrays in order to find out which values are used in each and then get a unique/distinct list of those values. Any help or guidance you can provide would be very appreciated!
I do not have a video reference on this scenario and would have to try it out to provide guidance or provide any inputs.
I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@@RezaDorrani I did a bit of searching through there but couldn't find anyone with a similar scenario. I can post there with a video to show what I've already tried. In theory, if I could figure out how to get the union of the arrays of values stored in each item in the list, that would do it, I think. It would probably not be a delegable operation, but I'm ok with that.
@@cvkealey You can give that a try. Sorry but I will not be of much help as I am slammed with multiple projects.
Please, Good morning, i have been following your videos on RUclips on Microsoft Power Apps creation. Please, is application created in Power Apps just for Organizations or anyone else can use it after creation
Power Apps can be shared with external users as well. ruclips.net/video/NEM1StcJzUI/видео.html
Thank you so much for this content,
I want to search within a unique text value field on the SharePoint list based on text input, if the value is there on SP list, populate the entire row and may be then edit/update the same. And if such a value is not there in the SP list, then I would like to let the user insert a new record into SP list.
Is this double? Kindly refer to a relevant youtube reference video if possible.
Most welcome.
I do not have a video reference on the scenario you mentioned and would have to try it out to know its feasibility.
I would recommend checking or posting your query on forums in case someone has done something similar
powerusers.microsoft.com
Very rich, indeed. Question: @25:05 "Manufacturer.Value" does not work when I reference a Choice column in a dataverse table. Why? Instead, I used Choices(Manufacturer) and it worked. However, I don't know how to convert this choice to text so that I use with Concat function.
Because Dataverse choice columns are not same as SharePoint.
They return enum values.
I have not tried with Dataverse choice column. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Thanks, Reza, you are one of the best Tech Guru available on this platform, the way you explain topics is Topnotch, kindly request you to do one full app development using all the functionalities in powerapps in one sequence step by step by procedure, thanks
Thanks Ravi. I am planning a training course in Sep. Will share more details once the planning is complete.
Check channel memberships. I have gone live with a training tier that you can sign up for now.
ruclips.net/user/rezadorranijoin
Thanks for the video! If I want to filter the combobox based on a toggle, but the toggle should be related to a Yes/No column in a different list. Would that be possible?
I would say possible but not something I have tried
If this channel have a step by step comprehensive course to Power Apps then it would be the best dedicated channel in the world without a question, great work though!!
Live training is planned for Sep or Oct. That would be on a different platform. I will be sharing more details about it in August.
Check channel memberships. I have gone live with a training tier that you can sign up for now.
ruclips.net/user/rezadorranijoin
Hello Rezza, Thank you for this video.
I encountered an issue that while the form is in new mode and the checkbox are selected, even after closing the form those values are not reset and appear as soon as we open the next instance of the new form. This occurs until we refresh the page. This is resolved by resetting the variable if it is blank in the checkbox reset property.
Welcome!
I dont remember running into this issue but if its resolved by resetting the variable then great
@@RezaDorrani Thank you Rezaa for responding back. I tried to test this on other user profile and lists, and this occurred there as well. The checkbox is not reset until we refresh the browser. Even the Edit/View from showed the last selected option. Yes, it was resolved by resetting the checkbox. Thank you for your kind response and your videos. Love from India. :)
Great. Very useful content. Thanks a lot Reza.
Also, please try to showcase us on how to effectively migrate "Power Apps" and "Power Automate" from one environment (Dev env. to UAT and Prod).
Once again thanks very much for your efforts.
Thanks.
I do have a video planned on solutions.
Hey Reza, I cannot thank you enough for the amount of information youve shared and all the help you've done.
I've been working on an combo box option and couldn't get through for months, could you help me with this ?
Using combo box as people picker connected to office365, I'm not able to write back the selected item back to MS lists (people column).
The Update prop is set to combobox.selected (since it only accepts records).
Many thanks Reza😊
ruclips.net/video/BzZ0a3zRFUk/видео.html & ruclips.net/video/g9ChYuTdNd4/видео.html may help.
I would also recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Thank you Reza. This is Uber Cool! Indeed the ComboBox is a mystery control😃.. Not anymore.. if we add the new Fluent UI control, will it 'break' the app when we migrate the app..not as such completely per say but as it is still in preview mode?
Thanks.
Im not too sure about exporting and preview mode. I wanted to show the new fluent ui control as well hence covered it in video.
Reza, I really appreciate your hard work with your videos, you've helped me a lot.
I've been wanting to ask you since I can't find an answer.
If I have form created from a SharePoint list, in the form I have a people picker with multiple selections ON, the source column needs to be Person type in my SharePoint list.
What would happen when using a gallery to view a record of my SharePoint list if at least one of the employees selected is not within the company anymore? In SharePoint, is the person's metadata lost?
I don’t think metadata gets lost.
My guess is it would continue to work fine.
But I have not come across this scenario before.
I will also recommend checking on forums at powerusers.microsoft.com in case someone has done something similar
Hello, I was wondering if you had a video which explained how to auto select in a second combobox as a result of the selection of the first. So for example, you select a site location from combobox 1 which auto populates the site ID in combobox 2. Thanks
I do not have a video reference on this scenario. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Thank you very much for the video, it was very helpful. One question, how do you allow users to enter in their own answer if it is not in the list (SharePoint linked). thank you
Most welcome!
I do not have a video reference on the scenario mentioned and would have to try it out to provide guidance. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Thanks as always Reza. Using the people picker, my selected names are not writing back to Microsoft List. What could be the problem?
I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hello Reza, great content! Very helpful. I was trying out the combo-box where the values are connected to another source data in sharepoint. Whenever, I close the PowerApps pages upon editing and go back to the Sharepoint List view, when I add a new test data into my list, the fields, including the combo-box appear to work, however, upon save, the data values selected under the combo-box disappears. My source data has over 200 rows
I have not come across this issue and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Request to make full power apps master class in udemy or something similar will be great.
I have plans for live training (paid) on my YT channel.
Check channel memberships. I have gone live with a training tier that you can sign up for now.
ruclips.net/user/rezadorranijoin
Reza, I can always learn something new from you whenver I watch any of your videos. Thank you for your hard work. I like the idea to copy the modern combo box in Teams to a canvas app. I tested it and connected it to a SharePoint choice column. Unfortunately, It didn't work for me. Can you let me know what went wrong? Thanks in advance.
Thank You so much for your kind words. So happy to hear the feedback.
After connecting to ur choice column, go to fields and ensure value is selected there and is the first field.
Thanks so much, Reza. This was a very helpful tutorial. Your delivery style is top notch.
Thanks Jason
Hi Raza,
I am trying to show activities from Activity list in a lookup dropdown in Activity list but i want to show only only Activities where logged in user is the Lead (Lead is people picker column in Activity list.)
I do not have a reference on this and something that I would have to try out to know more. Il recommend posting your query on forums powerusers.microsoft.com
@Reza Dorrani
Here is my solution, and its working fine.
Filter(Choices([@'Activity Updates '].Activity),Lookup('Activity List', ActivityTitle =Value, Lead.Email)=User().Email)
Make sure in SharePoint list, goto Lead field (people picker) and Show Field dropdown select Name (DO NOT SELECT NAME WITH PRESENCE)
Thanks @Reza for your videos, they are concise and comprehensive, the place to learn from.
In minute 18:08 you explained how you can copy and paste the modern combobox from PowerApps in Teams into PowerApps. I have replicated the steps but the copied modern combobox from PowerApps in Teams turned into a simple Label in PowerApps. Is there any setting i should modify?
That is weird. Might be some bug. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com/
Hi Reza,
Great videos :)
I have created a form with multiple fields for a user to enter information. As there are lots of fields, it is vital keyboard shortcuts can be used. When I try to use keyboard shortcuts on a combo box, it doesn't seem to be that user friendly. Here are the Steps I take:
1. Type in the combo box to search
2. Click on the down arrow (It moves to the clear 'X' button)
3. Click on the down arrow (it moves to the dropdown list)
4. Click on Return to select the value.
Is there any way of removing step 2 or a shortcut I am missing?
Thanks in advance!
Thanks.
I am not aware of shortcuts related to combo box.
I will recommend checking on forums at powerusers.microsoft.com in case someone has done this
@Reza Dorrani Thanks you so much i have a question on combo box and People picker column on share point. i want to update multiselected peoples from combo box to sharepoint people picker column i tried every way but unable to update please guide me thanks for your great effort.
Patch function or form control?
I have videos on them.
Patch function video has my blog post linked in description as well.
@@RezaDorrani Form control. In addition to that one more question ,i want to set default selected items of combo box from Sharepoint people picker column last record(Last set users) as I tried but it's getting error while submitting form as below. please guide me.Thanks again for your time as am stuck on this for long time appriciate your efforts on reply. error ⇒The requested operation is invalid. Server Response: Operation members list: The specified user i:0#.f|membership| could not be found.
@@manjunathpatil6785 That’s a weird requirement to set value of a control based on last submitted. Check my video on form control. I have 2 of them. They will give you some ideas.
I will also recommend posting on forums.
@@RezaDorrani Thank you for responding sure i will check same.
Great wok Raza..
I need help with sorting out an issue. I have a combobox with the Item Property bound to Sharepoint. I want to allow users to enter free text in the combobox, and I want that free text to be saved. I noticed that the onchange property of the combobox for searchText is not working as expected. I want the searchText value to be stored in a collection when the onchange property is triggered.
Your help is greatly appreciated.
I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Hi all! for some reason, at 12:02, the part where I'm supposed to be able to grab my datamodel, I just can't. I am using a SP list and tried different ways to call my column, but no luck. Any ideas? thanks!!
I have not come across this and hence not sure what the cause for it could be.
I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
You are outstanding!!! love to learn from your videos. Your contents are very helpful.
Glad you like them!
I would like to ask your opinion how to trick out the 2000 row limit at the combobox datasource. In this video you simply add a filter before it and it worked well in this scenario.
There is any way to use the combox's serchfield to filter the datasource? So when you start to type characters to the combox it will filter the datasource, so you can see limited datas in its dropdown (expected under 2000 rows). I was thinking about it, but simply it wasn't work because it's effects later, than the datasource was loaded.
Have you got any idea to solve the problem?
Thanks :)
"but simply it wasn't work because it's effects later, than the datasource was loaded." - Not sure why it doesnt work!
I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani Thank you. I found other way: OnStart clearcollect to a new collection and using the collection to get all item into the combobox's dropdown.
Do you have any video of yours on How to use/customise Lookup column in Power Apps? If yes, Please provide the link. Thank you.
I probably have done a few on it but that would probably not be the title of the video. I have done 200+ videos. Sorry but I don’t remember which ones.
Hi Reza, great video. But I'm facing one issue while trying to do AddColumns in items property. The thing is that when i try to addcolumns it shows multiple column values fine but when i try to submit it to sharepoint list the value doesn't go to the sharepoint list at all? Any idea how i can fix it. Thanks
Thanks!
I have not experienced the mentioned issue and hence not sure what the cause for it could be.
I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Hi reza in your example you only showed a combo box with multiple selection, how about if user only selected 1? Concat function wont be able to work.
Combo box will return an array even if it has 1 record. Concat will not break as long as its an array.
🔎Thanks for the tutorial! Always learn something new!
Most welcome
Hi Reza Thx for the helpful videos ... i'm just asking if you made a video for combobox cascade (depend on)
I have 2 videos on cascading. May be I showed cascading with combo box in one of them. Not 100% sure
@@RezaDorrani the two videos talk about dropdown cascade ... if possible can you make a combobox cascade video please ... i'm doing a project and it's the last part that cause me problem
@@abdourahmanediallo9430 I make videos when I receive multiple requests on a topic. Every quarter I ask subscribers for topic suggestions on Community tab of my channel. Make sure to post this idea whenever the next topic post comes out. If it gets max votes, I will add it to my backlog
@@RezaDorrani ok i understand, so can i expose you my problem to see if you can help to fix my issues please
@@abdourahmanediallo9430 I recommend posting issues on forums
powerusers.microsoft.com
I have a SharePoint list containing 50,000 items with one of the column is Lookup ie. "Area". I need to retrieve items with an ID between 1 to 50000 based on the OnChange property of a multi-select ComboBox (Area column values are given in Item property) in Power Apps. But I don't want to use Collection for 50000 SP List items. How can I accomplish this?
Combox box has the limit of delegation.
I would recommend reading about delegation.
Also, I have not come across a scenario with lookup of large data so not sure what the best approach would be. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Hii..Reza , I am facing with issues with my Power Apps
I have created a combobox and Text input
In combobox I have list various products and in Text box input I have used lookup formula in default property , Its work fine for selected products but I need to sum up all multiple selected valves in combo box of selected products
I shows only the recent selected valves for recent selected products in Text box input
pls suggests how can we achieve this
Lookup formula as used is as below
LookUp(Table5,Product=ComboBox1.Selected.Product,'Wt per Box')
what changes need to be made pls suggests as soon so that it automatically sum up selected valves
I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hello Reza,
I'm currently using Oracle as my data source. I've experimented with several approaches, but I'm encountering difficulty in conducting case-insensitive searches within a combo box. Specifically, when I search for "fire," it doesn't display any items if the actual item is spelled as "FIRE." Is there a solution to address this case sensitivity issue? I would appreciate any guidance on overcoming this challenge. Thank you.
I have not done any work with Oracle as a data source.
I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Thanks Reza. You've answered my question 100% about having access to the extra data related to the search items. (Just like the old "Access" days) . Concatenating extra information is a real bonus.
Glad to hear that! Thanks for watching Tony
I have a search page gallery with a combo box with allow multiple selection set to true. the defaultselected item is LookUp('A sharepoint List',Title=avariable) but when the combobox loads it shows only with the default item. once I click on an item from the search gallery and go back to the previous screen then combo box shows all items with the correct defaultseletecteditem. How do I fix this
I do not have a video reference on this and would have to try it out to provide guidance. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Hi, Great Video.
Can you please help on below scenario.
I have single Edit form which has Combobox connected with SharePoint list.
User select the value from Combobox and submit the details (Update - Selected.result)
The value is then updated into another SP list.
Now, After submit I'm using same form as NewForm to enter new record. I don't need to reset the form. whatever the value selected in Last submit it should show the same value into the Combobox.
Hoe can I achieve this?
I do not have a video reference on this scenario and would have to recreate your scenario to provide guidance. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com in case someone has done something similar
Hei Reza, I have a combobox in an app and i have a a little more than 2000 items in a SharePoint list, i have use the filter: Filter(INT_ISYPOProsjekt, Prosjektstatus = "Godkjent") and that reduces the items to 863, but i still can not find one of the items that seems to be after the 2000 items limit, is there a way to get these items searchable to the combobox? I thought the filter would solve the delegation issue, is there a work around? I have also try with a collection, but it does not work either, i get the same problem. Thanks a lot!
I have not come across this issue hence not sure. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Right on time. Thank you.
You are so welcome
Hi Reza, nice content. All your videos help me a lot. In modern combo box control search office365 users is working but once type the username and select it shows just for a sec and immediately disappears. Is it still a bug or any solution on this? Please help to understand. Thanks in advance.
Last I checked it was still not working.
This video covers a lot about office 365 users ruclips.net/video/y90lDTHOm3k/видео.htmlsi=M_mOvu29fQZVBw9J
Hello Reza,
Has there been a solution for adding the search text as a new choice in the modern combobox. I have found many examples for the classic combobox (including yours). I have not been able to track this down on the internet.
Thanks, E.
Not something I have tried so not sure
Hi Reza, can we set combo box list of values Searching with alphabets. I want show starting with that alphabet.
ex. if Im searching with P.
I want only those values are starting with P (not those values including P).
Not sure. Something I would have to try out to know its feasibility.
Hi Rezza I was waiting this for a long time. Thanks for sharing 👍.
Hope you enjoyed it!
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?
I have not come across this issue and hence not sure what the cause or fix for it can be.
I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Great tutorial video as always. Thank you so much Reza.
You’re most welcome
Hi Reza
I need some help on ,i have Combox but default value is empty,though varble i specify some text " Compare roles" , after i selected one option from Combox,next time when I go to home combobox showy to previous option in Combox.but I need to reset the comboxbox text "compare role" ...Could u please help how to reset combobox in other screen to default value
I do not have a specific video reference on this scenario and would have to try it out to know the steps and provide guidance. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Thanks again Rezza, I didn't know I could add extra meta data
I learnt some new things while prepping for the video as well
How can I delete the word after write and select the item?
I don´t want to use the "x"
Im not aware of any other way to do it
Thank youuu.
I have other answer.
Can I move the items selected in the combobox from one origin list to destination list in sharepoint?@@RezaDorrani
Thank youuu.
I have other answer.
Can I move the items selected in the combobox from one origin list to destination list in sharepoint? @RezaDorrani
Possible but again not something I have tried
Hi Reza, I have a query, On Change trigger of combo box control how to capture previous value before it is changed to new value. Please give a solution . Thanks
When screen loads, store initial value beforehand. Then if control is changed, use onchange to get new value.
with Dataverse as backend. If I want to show a certain field in Combo box ( Delegation limit to 1 in setting) why it show only 1 item. Though Dataverse delegation limit is too high. If I bind to a Gallery it show all
I have not tried this with Dataverse so not sure.
Hello Reza
Thanks for video. Its really great. How can i achieve the scenario that if user select status "new" and i just want to block user to chose further statuses like packaging, on-hold or completed?
I do not have a video reference on this scenario and would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani Yes. Since morning im digging on internet and there were no guidence about it whoch could be usefull on the future :) I just asked now on ms. Thanks. although someone help me on MS, i wait your videos :)
@@MikariN40 I make videos when I receive multiple requests on a topic. I don't see folks requesting this as it is very specific. Forums will be your best bet powerusers.microsoft.com/
Hello Reza, I tried to have the combo Box for people picker but it does not write back to my dataverse table. Do you have any work around to it?
Thank for the help in Advanced
I dont think I showed dataverse table in video. SharePoint and Dataverse are different data sources. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Top-notch explanation as always.
Thanks Reza!
I believe combo box supports delegation for dataverse, correct me if I am wrong.
Concept is same for Dataverse as well
@@RezaDorrani Thanks for the reply. Does combo box supports delegation for dataverse?
@@kireetiyakkali No
Hi Reza, I am trying to fit two columns in one combox. For eg: I need to add ID and their description in one combo box. Not able to figure out how? Please could you help me?
Check the following
ruclips.net/video/y90lDTHOm3k/видео.html
What if I don't want to see autopopulated items when I just click that combobox? Is that possible? Because I want to see autopopulated items only when I type on something.
I’m not sure if that is possible.
I recommend posting your query on forums powerusers.microsoft.com in case someone has done something similar
if I have more than 2000 items in the list. I want to show one column distinct Values in a Combo box it not shows all items distinct values. Instead it show some less number of items. Any solution for Distinct function with delegation ?
Distinct is not a delegable function. Im not aware of any workarounds.
Hi Raza, Thank you for this wonderful video. I want to build a cascading combobox for filtering my gallery. If you have already made a video on this topic please share the link, I am not able to find that video. Please help
Try searching for “cascading dropdown reza dorrani” on youtube.
You should get 2 videos on this.
I have shown combo box based filter as well but probably not with multi-select filtering levels.
@@RezaDorrani That videos I have already watched it several times and they are really amazing but was not able to filter it for multi select. If you have any reference document or video please share it with me. Please
@@yashkumarjain6317 I dont have for multi select. Check on forums at powerusers.microsoft.com in case someone has done something similar
@@RezaDorrani You have done it in the last part of this video I just want to know how you filter the cascading combobox.
When you select multiple manufacturers how does it shows list related to both those manufacturers?
@@yashkumarjain6317 I have not done filtering of cascading but not multi to multi from what I remember.
Thanks so much Reza. This video comes in handy for me
Awesome
I use combo boxes regularly but I still learned so many great tips from this. Keep this up !
Awesome! Thank you!
How to restrict the employee names only to a list provided in SharePoint list. In the patch video you mentioned the use of collection I am struggling to achive it. Please help
I do not have a video reference on this scenario and would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Updating manually the array for SearchFields property is not working. Any ideia on the reason?
No ideas as I have not come across this issue
Any idea what to do then part 'Self.SearchText' doesn't work in Custom Page MD?
I have not come across the mentioned issue and hence not sure what the reason for your issue is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Hi Reza. Thank you for your great work.
As for search fields I never succeeded in using more than 1 field for search. It is like the input for searchFields in the advanced tab was not used. Only the field selected in the interface on the first tab is used. Do you know why ?
That’s the default behavior. You can change that in advanced settings for combo box control as shown in the video.
@@RezaDorrani thanks for your answer. It looks like there is a bug anyway. European users have to create a typo error in the searchfields (example use a , instead of a ; ) to make a multiple fields search. And by multiple, looks like no more than 2 fields can be used
@@AlexandrePerret Wow! That is weird.
@@AlexandrePerret many thanks!
Hi Reza, I have a combobox inside the gallery which is connected to the SharePoint column "Projects" in sharepoint list A and the gallery is connected to SharePoint list B, I set the DefaultSelectedItems Property of the combobox as "ThisItem.Projects" which is throwing an error saying "This Formula uses scope, which is not presently supported for evaluation".
Its a cascading combobox, 1st combobox is outside the gallery and 2nd dependent one is inside the gallery.
what can I put in "DefaultSelectedItems" property of the Combobox inside the gallery where the data whatever is saved shows up ?
Basically I am looking to display existing data from SharePoint into the Combobox which is inside the Gallery and "ThisItem.Column" is not working which works well with Dropdownlist.
Thanks for the help!
I do not have a specific video reference on the mentioned scenario and would have to try it out to provide guidance.
I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
@@RezaDorrani I made it work!!!
The drop-downs inside gallery have the Default "ThisItem.FieldName" and display the value required. The Combo Box however displays multiple lines and cannot display the value stored.
Instead I added a label to the gallery and made the visible False, to the text of this label I added "ThisItem.FieldName" and to the "InputTextPlaceHolder" property of the Combobox inside the gallery I added Label.Text. 😀 here the combobox Multiselect is set to False.
From a user interface point of view, it does the job required.!!
Posted this work around here incase it helps.
Thanks a lot Reza!
#PowerApps #PowerAutomate
Hi Reza, I'm a power apps newbie. is there a way to use the people from a sharepoint group as the options of my combo box?
I am not aware if that is a possibility
Hey, I want to be able to get the selected value of the combobox from it's default value but it always returns blank. I only get a value when manually selecting it
I have not come across the mentioned issue and hence not sure what the cause could be.
I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Sometimes I get the feeling that you are reading my mind. This is exactly what I needed now. Thanks a lot for this.
You're so welcome!
Thanks Reza, very useful video.
You’re most welcome
Hi Reza , I am facing this problem in Power app from long ago but couldn’t find the exact solution for this . I am using multiple select people picker in my application form when I am patching while inserting new data it is working fine but while updating the data for the same record from gallery when I don’t change the persons in multi select drop-down getting this error “ 'Specified user i:0#.f|membership| could not be found" while trying to patch”. Please help me here
I have not come across this issue hence not sure what the fix or reason for your issue would be. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Hi Reza, why am I not able to add a combo box to my Gallery? I am able to add a modern combo box but not the classic combo box.
I have no idea about that
thanks amazing, easy and very clear lesson.
Glad to hear that!
Thanks Reza
Welcome
This channel is one stop shop for all our PowerApps needs. Great content Reza as always.
Thank You so much
Hi Reza thank you so much for your inputs, i would like to know how to create people picker(only particular group of people, ex;people who belong to manager category) in dropdown or combo box. This would be a great help . Thanks
How do you define one belonging to manager category? Someone who has direct reports in AD? That should be possible I assume but I do not have a specific video reference for it.
I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@@RezaDorrani Im looking for people picker from a Sharepoint list not from 365users, Thanks
@@divyashree4558 Possible. Connect the combo box Items property to that list. Once again, I do not have a video reference on this. I will recommend checking on the forums.
I checked in the forums but i couldnt get a solution, so i approached my power apps guru😊, its like i need to filter the persons who belongs to particular category and show only them when i click the dropdown.
@@divyashree4558 Forums will be your best bet. I also go to forums to assist but only in my free time. I do not have a video reference hence I cannot provide guidance unless I try it out and currently, I do not have any bandwidth.
CAn you share the code how to load multiselect combox values after retrieve from table
Video shows exactly that step by step
Thank you Reza this really helps me a lot, once question though, how can I input text manually in case one of my dropdown is 'Others'? Thank you so much
I have not tried this scenario so not sure
@@RezaDorrani Thank you Reza, no worries 👍
Hi , thanks Reza, how do I get the index of the selected item in the combobox if I want to position it in a Gallery for the Select(Gallery, index) function. thx
Not sure about this
@@RezaDorrani Thx
Hi Reza,
I'm still struggling to understand 'Defaults'
Items = SortByColumns(
AddColumns(
' Locations ',
"FullLocation",
Concatenate(
Title,
", ",
State,
", ",
Postcode
)
),
"Title"
)
but I'm still having errors with my DefaultSelectedItems = ThisItem.FullLocation in ' Locations '
any ideas on where I'm going wrong 😣😣
I cannot make a guess by looking at code here on chat. There could be various reasons for it. Best to post your issue with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani Thanks Reza will put something up on the forum
Hi Reza, is there any way to change formatting for primary text and secondary text separately? I have category and subcategory as two columns. I want to make the category (primary text) bold but not the subcategory (secondary text)? Thanks
Not sure as this is not something I have tried
@RezaDorrani All right. May be not with combo box but any workaround?
I will elaborate on my use case: I have dropdowns which looks like sentences. Example:
1) Mercedes: It has the best suspension
2) Audi: It has the best braking system
And so on...
In every dropdown option, I wish to highlight the first word (may be with different font or weight)
Is this doable with any control?
Thanks! (I thought of using cascading dropdown but business requirements are not allowing)
@@adityapadmawar8754 I dont think that is an option
@@RezaDorrani Okay. Thanks a lot for your response Reza!
So just to clarify;
1. The classic combobox allows multiple (searchable) display fields.
2. The modern dropbox does not allow multiple display fields and it does not have search as an option.
3. The Dataverse for Teams Combobox allows search but still doesn't allow for multiple display fields.
1 - Modern just released a combo box control that is searchable. Its in the latest app authoring versions.
2 - Modern only allows for single field display
3 - Don't use DVT combo box
Hi Reza, Thank you for your video. I've got the following question. I've got a Combox the items for which are selected on the basis of the existing Sharepoint list and DropBox selecteditem. Multiple selections are allowed. The selected items in the ComboBox (in my scenario the list of printers available to user extracted from resources sharepoint list and selected city ) should be inserted in the other sharepoint list (Requests). There is no problem to Concat the selected items and insert them into the new sharepoint list record. But I'm going to add approvals scenario (w/o Flow) which means that the form should be opened by the other user and display the selected on the previous step options. due to the fact the the variety of the selected items could be significant it means that the setting for the column in the Requests sharepoint list will be difficult to maintain to add all possible choices. Is it possible to insert several values from the dropdown into the sharepoint list column, if selected item is not defined in the choices option for the column? Despite the fact the adding of the new values is allowed I can't save selected items to the list.
Adding of new choices in dropdown is more of a sharepoint feature. I think there is a way to achieve it in power apps but something that I have never tried + I do not have any reference on it. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Dear Raza,
I have an Excel sheet connected to my Powerapps Canvas Form and we use it as our data entry. The form has ComboBoxes and TextInput Fields. When we enter our data and submit, most of the relevant rows in excel are populated. Except some of the ComboBoxes are not.
The problem is when I try to edit an existing case details, I would like to have the ComboBoxes filled by default in my PowerApps with the data from my Excel. All the TextInput fields are populated, but the ComboBoxes are empty and not interacting with Excel at all.
Please advise and share any solutions to this. Many thanks,
I have not come across this issue or scenario with excel and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani Thank you Raza. I have already posted my question on Powerapps community, but so far no response :(
@@mabob12 Community forums is an open platform where you may or may not get a response. If urgent, then I would recommend getting consulting help
Thanks for this great video Reza. I had a question if you can guide: Is there an easy/straight forward way to validate if the value in Default Selected Item property of combo box is one of the values in Items property?
I am not aware of a way to do that.
Excellent tutorial as usual. I have a question, I'd like to use the ComboBox to select "Approvers" (Items property points to AD), I'm then adding these Users into a List with additional columns, this is being done using the "on change" property of the ComboBox i.e. ForAll(Self.SelectedItems,.... As there are other columns in the List e.g. approval Date etc. What I haven't been able to figure out is how to remove / add changes to the list, as and when selections in the Combo Box change i.e. if a new person is added or existing person removed. Here's a scenario, 3 persons were selected and Patched to the List, out of the 3, 2 have clicked on Approve and data has been recorded. The 3rd person is unavailable and needs to be removed and an alternate approver needs to be added. How do I remove the 3rd person from the list and add the replacement, while not touching the 2 that have already approved?
I do not have a video reference on your scenario and would have to try it out to provide guidance. I will recommend posting your query with screenshots on the forums at powerusers.microsoft.com
Could we limit number of selection in combobox down to 5 choices only?
There is no direct action to do that but you can show a message that only 5 selections are allowed or disable the submit button if more than 5 selections are made
What if I wanted to input my own value as well as chose from the list?
That is not a direct option. I do not have a video reference on this scenario. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Still unclear about the no of items combobox can hold if I am using a SP list as datasource. Like If I want to show 10000+ values inside combobox, is it doable without any issues?
You cannot show more than delegable limit in combo box. Max 2000.
Thanks for this video. Can you share the syntax for Searching Users and groups from the active directory.. Currently using Office365Users.SearchUser({searchTerm:ComboBox1_1.SearchText,top:100}) but this helps to search only users . I need for groups too.
This function is not for searching groups. I am not sure what the group search function is. I will recommend checking on forums in case someone has done something similar
powerusers.microsoft.com
It's really helped a lot. Thanks.
Glad to hear that!
Thanks...This really helps... e But one scenario that 1I 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... there more intuitive way to achieve this?
When combo box is edited in form, it will maintain the previous value for edit form. Most of my form based videos have shown that.
As for the requirement on not selecting an already selected value, this is not something I have tried. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Ok when user open edit form even though there is a selected value in combobox it still says blank as it's mandatory column they are not able to submit again until they manually change the combobox value again .....how to resolve this?
@@sridharreddy1607 I have not experienced this issue, hence not sure how to resolve it.
I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
The modern combo box limitation with no delegation makes it useless to use for people picker (linked to Entra ID table). Any work around this issue?
Currently, modern combo box does not work well for people picker scenario. Stick to classic for now.
@@RezaDorrani I did but the query box (the one that appears when you start searching a person) shows blank. I noticed that it has the values but just looks blank. for example if I hover over it and click somewhere it will select a person but I have no way of finding out who I am selecting because the query box just seems blank. This is for Dataverse for Teams btw and on the published side only.
@@rorsara3940 Im not sure why that would be the case. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Can anyone tell me how we can highlight the values inside the combobox
Iam showing default selected items for combobox
But it is not highlighting inside the combobox
Have not experienced any issues with that, hence not sure.
I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com