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!!
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.
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
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.
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.
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.
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
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
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
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?
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
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
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
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
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?
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.
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
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.
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
@@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
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. :)
Thank you for your amazing video! I've searched the whole internet and can't find if theres a way to keep the combo box open all the time so users don't have to click the dropdown! Thank you!!
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
@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.
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?
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.
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
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, 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.
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 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
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
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
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
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 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.
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 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 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?
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
Reza this is super helpful! I do however have a question, how come in the items section we had to put single quotes around asset, but not manufacturer ?
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
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
Hello, @Reza! I have a question. Is it possible to display my Sharepoint connections inside a combo box? The idea is for the user to select a list from the combo box then store that into a variable. Then on the Filter function of my gallery, instead of hardcoding the list name or the data source, I would just replace it with the variable. Is this possible?
@@RezaDorrani Hi Reza! Thanks for the reply. That's quite unfornate. It would be a really good feature if it was possible. Because every component that references the list name would be replaced for everytime i need to test in different environments
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
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.
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 , 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 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
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
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
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.
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
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
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, 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)
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, 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
@@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
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)
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
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 Sir, Hope you are doing well. I have some managed metadata choices columns in my powerapps and I am publishing/tagging the data in SharePoint document library but whenever the flow runs it only stores one value in that particular column. Pls advise.
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
In modern controls we have a combobox , but we do not have depends on property to do the cascading functionality , but in classic combo box we have depends on , is depends on property is deprecated for modern controls ?
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
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
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?
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).
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/
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.
Is there a way to filter out options that have been used in a sharepoint list. I have a choice column and employee column, i need to filter out options the employee has already selected from the choice column so they can't be selected more than once, its hard to find a solution for this.
Probably possible but I do not have a video reference on this and would have to try it out to know the options. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
@@RezaDorrani thank you, i have done but not much response. i can filter just the options that have been used, but not the ones that haven't! Thank you for your videos, they're a great help for an amateur!
Reza, I do not see an option for layout or for primary, secondary or search in data ...fields. I just see a list of all the text columns (Dataverse Teams)
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?
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!
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
This channel is one stop shop for all our PowerApps needs. Great content Reza as always.
Thank You so much
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 use combo boxes regularly but I still learned so many great tips from this. Keep this up !
Awesome! Thank you!
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 so much, Reza. This was a very helpful tutorial. Your delivery style is top notch.
Thanks Jason
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
You are outstanding!!! love to learn from your videos. Your contents are very helpful.
Glad you like them!
Brilliant as usual, your content helps beginners in a big way.
Great to hear that! Thanks so much for watching.
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.
Great tutorial video as always. Thank you so much Reza.
You’re most welcome
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
Thanks a lot for making this video!
Glad it was helpful!
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.
Hi Rezza I was waiting this for a long time. Thanks for sharing 👍.
Hope you enjoyed it!
Thanks so much Reza. This video comes in handy for me
Awesome
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
This is beyond helpful; thank you!
You’re most welcome
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 amazing, easy and very clear lesson.
Glad to hear that!
Right on time. Thank you.
You are so welcome
Thanks Reza, very useful video.
You’re most welcome
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
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/
Fantastic. Thank you!
Welcome
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
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
It's really helped a lot. Thanks.
Glad to hear that!
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
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
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
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/
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.
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
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.
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
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
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. :)
Thank you for your amazing video! I've searched the whole internet and can't find if theres a way to keep the combo box open all the time so users don't have to click the dropdown! Thank you!!
Glad I could help!
User will need to click on combo box to search.
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 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
@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.
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.
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
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
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, 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.
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
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
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
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.
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
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
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 👍
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.
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 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 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
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
Reza this is super helpful! I do however have a question, how come in the items section we had to put single quotes around asset, but not manufacturer ?
Because asset related column was called asset type. It has a space hence ‘’.
@@RezaDorrani ahh, so simple :)
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
🔎Thanks for the tutorial! Always learn something new!
Most welcome
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
Hello, @Reza!
I have a question. Is it possible to display my Sharepoint connections inside a combo box?
The idea is for the user to select a list from the combo box then store that into a variable.
Then on the Filter function of my gallery, instead of hardcoding the list name or the data source, I would just replace it with the variable. Is this possible?
data source connections cannot be dynamically selected even if stored in a variable.
@@RezaDorrani Hi Reza! Thanks for the reply. That's quite unfornate. It would be a really good feature if it was possible.
Because every component that references the list name would be replaced for everytime i need to test in different environments
@@thatdudette3945 Yes, but currently its not supported
@@RezaDorrani Okay, thanks again!
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
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 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.
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 , 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 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.
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
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
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.
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
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
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, 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!
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, 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
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
You are Rock
Thanks
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)
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
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
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 Sir, Hope you are doing well. I have some managed metadata choices columns in my powerapps and I am publishing/tagging the data in SharePoint document library but whenever the flow runs it only stores one value in that particular column. Pls advise.
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 thanks I will.
In modern controls we have a combobox , but we do not have depends on property to do the cascading functionality , but in classic combo box we have depends on , is depends on property is deprecated for modern controls ?
Modern controls are in preview.
Not sure if that would be deprecated.
@@RezaDorrani how to achieve the cascading filters in modern combobox
@@Srinivas-h2e I have not tried that so not sure
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
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
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.
Thank you !
You're welcome!
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.
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/
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
Can you adjust font style for primary text to strike-through or bold/italicized or even just change the font color?
We are limited to the options provided by the style properties of the combo box.
@@RezaDorrani thank you, and upon checking i believe it is true that the combo box allows strikethrough for text - much appreciated!
@@geralddahl9159 +1
@@RezaDorrani sorry if I'm overdoing it on questions and replies, but, what does @Gerald Dahl +1 mean?
@@geralddahl9159 +1 means I support your comment.
Is there a way to filter out options that have been used in a sharepoint list. I have a choice column and employee column, i need to filter out options the employee has already selected from the choice column so they can't be selected more than once, its hard to find a solution for this.
Probably possible but I do not have a video reference on this and would have to try it out to know the options. I recommend checking or posting your query on forums in case someone has done something similar
powerusers.microsoft.com
@@RezaDorrani thank you, i have done but not much response. i can filter just the options that have been used, but not the ones that haven't! Thank you for your videos, they're a great help for an amateur!
@@FXGL. May be its not a common use case. You may want to look at getting consulting help for your scenario.
Reza, I do not see an option for layout or for primary, secondary or search in data ...fields. I just see a list of all the text columns (Dataverse Teams)
Dataverse for teams is modern UI. It does not have the layout option.
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.