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!!
@RezaDorrani
2 жыл бұрын
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.
@RezaDorrani
Жыл бұрын
Check channel memberships. I have gone live with a training tier that you can sign up for now. kzitem.infojoin
@fakharahmedkhan5157
2 жыл бұрын
Sometimes I get the feeling that you are reading my mind. This is exactly what I needed now. Thanks a lot for this.
@RezaDorrani
2 жыл бұрын
You're so welcome!
@ravikumararavapalli8850
2 жыл бұрын
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
@RezaDorrani
2 жыл бұрын
Thanks Ravi. I am planning a training course in Sep. Will share more details once the planning is complete.
@RezaDorrani
Жыл бұрын
Check channel memberships. I have gone live with a training tier that you can sign up for now. kzitem.infojoin
@rajasekharreddysanivarapu4239
2 жыл бұрын
This channel is one stop shop for all our PowerApps needs. Great content Reza as always.
@RezaDorrani
2 жыл бұрын
Thank You so much
@markburley2670
2 жыл бұрын
I use combo boxes regularly but I still learned so many great tips from this. Keep this up !
@RezaDorrani
2 жыл бұрын
Awesome! Thank you!
@tonykuiper9127
2 жыл бұрын
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.
@RezaDorrani
2 жыл бұрын
Glad to hear that! Thanks for watching Tony
@jasonthedogcatcher
2 жыл бұрын
Thanks so much, Reza. This was a very helpful tutorial. Your delivery style is top notch.
@RezaDorrani
2 жыл бұрын
Thanks Jason
@madhusudhanarajusarikonda5173
2 жыл бұрын
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.
@RezaDorrani
2 жыл бұрын
Thanks. I do have a video planned on solutions.
@god_hacker581
2 жыл бұрын
You are outstanding!!! love to learn from your videos. Your contents are very helpful.
@RezaDorrani
2 жыл бұрын
Glad you like them!
@ShuskiCross
2 жыл бұрын
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.
@RezaDorrani
2 жыл бұрын
Thanks for sharing
@Latoshi-c6h
Ай бұрын
Right on time. Thank you.
@RezaDorrani
Ай бұрын
You are so welcome
@ronbakker1300
2 жыл бұрын
Thanks again Rezza, I didn't know I could add extra meta data
@RezaDorrani
2 жыл бұрын
I learnt some new things while prepping for the video as well
@josbar80
Жыл бұрын
Brilliant as usual, your content helps beginners in a big way.
@RezaDorrani
Жыл бұрын
Great to hear that! Thanks so much for watching.
@davidvo30
2 жыл бұрын
Great tutorial video as always. Thank you so much Reza.
@RezaDorrani
2 жыл бұрын
You’re most welcome
@barunroyghatak4380
2 жыл бұрын
Hi Rezza I was waiting this for a long time. Thanks for sharing 👍.
@RezaDorrani
2 жыл бұрын
Hope you enjoyed it!
@paolovr1970
2 жыл бұрын
thanks amazing, easy and very clear lesson.
@RezaDorrani
2 жыл бұрын
Glad to hear that!
@oluwatobiyusuf
2 жыл бұрын
Thanks so much Reza. This video comes in handy for me
@RezaDorrani
2 жыл бұрын
Awesome
@briancanfield2968
2 жыл бұрын
This is beyond helpful; thank you!
@RezaDorrani
2 жыл бұрын
You’re most welcome
@kireetiyakkali
2 жыл бұрын
Top-notch explanation as always. Thanks Reza! I believe combo box supports delegation for dataverse, correct me if I am wrong.
@RezaDorrani
2 жыл бұрын
Concept is same for Dataverse as well
@kireetiyakkali
2 жыл бұрын
@@RezaDorrani Thanks for the reply. Does combo box supports delegation for dataverse?
@RezaDorrani
2 жыл бұрын
@@kireetiyakkali No
@musicmania9837
Жыл бұрын
It's really helped a lot. Thanks.
@RezaDorrani
Жыл бұрын
Glad to hear that!
@SHAli1474
2 жыл бұрын
Thanks Reza, very useful video.
@RezaDorrani
2 жыл бұрын
You’re most welcome
@siddharthgoutam7857
2 жыл бұрын
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.
@RezaDorrani
2 жыл бұрын
Power Apps does not understand SharePoint Views. This is by design.
@user-dx2it5rg8d
Жыл бұрын
🔎Thanks for the tutorial! Always learn something new!
@RezaDorrani
Жыл бұрын
Most welcome
@JenMayB
Жыл бұрын
Fantastic. Thank you!
@RezaDorrani
Жыл бұрын
Welcome
@Nick-gi7yl
8 ай бұрын
Thank you so much for this video Reza. To filter office365 users, how can we filter based on userType: Guest or Member?
@RezaDorrani
8 ай бұрын
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/
@hoges510
Жыл бұрын
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.
@RezaDorrani
Жыл бұрын
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
@puterimawarshazleen5941
Жыл бұрын
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
@RezaDorrani
Жыл бұрын
Combo box will need the width to fit those names. Not sure if there will be any real estate left.
@theChandruR
Жыл бұрын
Request to make full power apps master class in udemy or something similar will be great.
@RezaDorrani
Жыл бұрын
I have plans for live training (paid) on my YT channel.
@RezaDorrani
Жыл бұрын
Check channel memberships. I have gone live with a training tier that you can sign up for now. kzitem.infojoin
@AimeeReynolds-rr6wt
Жыл бұрын
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
@RezaDorrani
Жыл бұрын
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
@kelum0823
Жыл бұрын
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.
@RezaDorrani
Жыл бұрын
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
@SaidElnaffar
2 жыл бұрын
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.
@RezaDorrani
2 жыл бұрын
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
@karinay8557
Жыл бұрын
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
@RezaDorrani
Жыл бұрын
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
@abhisheksreenivasan9353
Жыл бұрын
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😊
@RezaDorrani
Жыл бұрын
kzitem.info/news/bejne/o7CQlpVps4R3iKA & kzitem.info/news/bejne/yG95zo2rjZZ_l2k may help. I would also recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@abdourahmanediallo9430
Жыл бұрын
Hi Reza Thx for the helpful videos ... i'm just asking if you made a video for combobox cascade (depend on)
@RezaDorrani
Жыл бұрын
I have 2 videos on cascading. May be I showed cascading with combo box in one of them. Not 100% sure
@abdourahmanediallo9430
Жыл бұрын
@@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
@RezaDorrani
Жыл бұрын
@@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
@abdourahmanediallo9430
Жыл бұрын
@@RezaDorrani ok i understand, so can i expose you my problem to see if you can help to fix my issues please
@RezaDorrani
Жыл бұрын
@@abdourahmanediallo9430 I recommend posting issues on forums powerusers.microsoft.com
@Yinusa00
Жыл бұрын
Thanks Reza
@RezaDorrani
Жыл бұрын
Welcome
@ericdvoracek
Жыл бұрын
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
@RezaDorrani
Жыл бұрын
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
@ppei2012
2 жыл бұрын
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.
@RezaDorrani
2 жыл бұрын
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.
@luisaymarinacruz
2 жыл бұрын
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?
@RezaDorrani
2 жыл бұрын
That is weird. Might be some bug. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com/
@PedroTorres-ip7sj
2 жыл бұрын
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?
@RezaDorrani
2 жыл бұрын
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
@havoc1723
3 ай бұрын
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
@RezaDorrani
3 ай бұрын
I have not tried this scenario so not sure
@havoc1723
3 ай бұрын
@@RezaDorrani Thank you Reza, no worries 👍
@raghadm5719
11 ай бұрын
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?
@RezaDorrani
11 ай бұрын
I would say possible but not something I have tried
@NarnawareSunil
2 жыл бұрын
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?
@RezaDorrani
2 жыл бұрын
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.
@shivoham3633
5 ай бұрын
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
5 ай бұрын
Welcome! I dont remember running into this issue but if its resolved by resetting the variable then great
@shivoham3633
5 ай бұрын
@@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. :)
@misganawkibret603
2 жыл бұрын
Thank you !
@RezaDorrani
2 жыл бұрын
You're welcome!
@CarFinanceSimplified
2 жыл бұрын
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?
@RezaDorrani
2 жыл бұрын
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
@cvkealey
Жыл бұрын
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!
@RezaDorrani
Жыл бұрын
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.
@cvkealey
Жыл бұрын
@@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.
@RezaDorrani
Жыл бұрын
@@cvkealey You can give that a try. Sorry but I will not be of much help as I am slammed with multiple projects.
@princeoluable
Жыл бұрын
Thanks as always Reza. Using the people picker, my selected names are not writing back to Microsoft List. What could be the problem?
@RezaDorrani
Жыл бұрын
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
@akshat8899
Жыл бұрын
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?
@RezaDorrani
Жыл бұрын
I am not aware of a way to do that.
@sridharreddy1607
2 күн бұрын
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?
@RezaDorrani
2 күн бұрын
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
@sridharreddy1607
2 күн бұрын
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?
@RezaDorrani
2 күн бұрын
@@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
@abbasthegreat5
Жыл бұрын
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.
@RezaDorrani
Жыл бұрын
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.
@manjunathpatil6785
Жыл бұрын
@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
Жыл бұрын
Patch function or form control? I have videos on them. Patch function video has my blog post linked in description as well.
@manjunathpatil6785
Жыл бұрын
@@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.
@RezaDorrani
Жыл бұрын
@@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.
@manjunathpatil6785
Жыл бұрын
@@RezaDorrani Thank you for responding sure i will check same.
@mahyartalehfirooz8946
2 жыл бұрын
You are Rock
@RezaDorrani
2 жыл бұрын
Thanks
@sumitringane2037
29 күн бұрын
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.
@RezaDorrani
29 күн бұрын
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.
@kashifhaque9452
2 жыл бұрын
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 ?
@RezaDorrani
2 жыл бұрын
Because asset related column was called asset type. It has a space hence ‘’.
@kashifhaque9452
2 жыл бұрын
@@RezaDorrani ahh, so simple :)
@derrickamoako5560
Жыл бұрын
Please, Good morning, i have been following your videos on KZitem on Microsoft Power Apps creation. Please, is application created in Power Apps just for Organizations or anyone else can use it after creation
@RezaDorrani
Жыл бұрын
Power Apps can be shared with external users as well. kzitem.info/news/bejne/r3uDl4eqnHyriH4
@MosieRiddleton
Жыл бұрын
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!
@RezaDorrani
Жыл бұрын
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
@andreyy1016
Жыл бұрын
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.
@RezaDorrani
Жыл бұрын
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.
@vikita0123
Ай бұрын
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.
@RezaDorrani
Ай бұрын
Last I checked it was still not working. This video covers a lot about office 365 users kzitem.info/news/bejne/2m9m0niKgYGeZqAsi=M_mOvu29fQZVBw9J
@UB-qc8yk
2 жыл бұрын
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?
@RezaDorrani
2 жыл бұрын
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
@Reena-he9mt
2 ай бұрын
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
@RezaDorrani
2 ай бұрын
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
@ericmoisan6568
3 ай бұрын
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.
@RezaDorrani
3 ай бұрын
Not something I have tried so not sure
@GamingisourDestiny
Ай бұрын
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
@RezaDorrani
Ай бұрын
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
@etelewischan9109
2 жыл бұрын
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 :)
@RezaDorrani
2 жыл бұрын
"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
@etelewischan9109
2 жыл бұрын
@@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.
@Soulebi03
Жыл бұрын
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.
@RezaDorrani
Жыл бұрын
Combo box will return an array even if it has 1 record. Concat will not break as long as its an array.
@2007pradipta
3 ай бұрын
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
@RezaDorrani
3 ай бұрын
I have not tried this with Dataverse so not sure.
@gaborpataki87
5 ай бұрын
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?
@RezaDorrani
5 ай бұрын
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
@yashkumarjain6317
Жыл бұрын
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
@RezaDorrani
Жыл бұрын
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.
@yashkumarjain6317
Жыл бұрын
@@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
Жыл бұрын
@@yashkumarjain6317 I dont have for multi select. Check on forums at powerusers.microsoft.com in case someone has done something similar
@yashkumarjain6317
Жыл бұрын
@@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?
@RezaDorrani
Жыл бұрын
@@yashkumarjain6317 I have not done filtering of cascading but not multi to multi from what I remember.
@NatashaGondiProfessional
9 күн бұрын
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!
@RezaDorrani
9 күн бұрын
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
@NatashaGondiProfessional
8 күн бұрын
@@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
@us4604
9 ай бұрын
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.
@RezaDorrani
9 ай бұрын
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
@JohnJoe131
7 ай бұрын
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
@RezaDorrani
7 ай бұрын
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
@KuldeepSingh-nq1vi
6 ай бұрын
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
@RezaDorrani
6 ай бұрын
When screen loads, store initial value beforehand. Then if control is changed, use onchange to get new value.
@excel-k-sir
Жыл бұрын
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
@RezaDorrani
Жыл бұрын
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
@AlexandrePerret
2 жыл бұрын
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
2 жыл бұрын
That’s the default behavior. You can change that in advanced settings for combo box control as shown in the video.
@AlexandrePerret
2 жыл бұрын
@@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
@RezaDorrani
2 жыл бұрын
@@AlexandrePerret Wow! That is weird.
@birgerlofgren540
Жыл бұрын
@@AlexandrePerret many thanks!
4 ай бұрын
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!!
@RezaDorrani
4 ай бұрын
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
@fawadrehman
Жыл бұрын
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.)
@RezaDorrani
Жыл бұрын
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
@fawadrehman
Жыл бұрын
@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)
@bannethirupathaiah5777
6 ай бұрын
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).
@RezaDorrani
6 ай бұрын
Not sure. Something I would have to try out to know its feasibility.
@divyashree4558
2 жыл бұрын
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
@RezaDorrani
2 жыл бұрын
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
2 жыл бұрын
@@RezaDorrani Im looking for people picker from a Sharepoint list not from 365users, Thanks
@RezaDorrani
2 жыл бұрын
@@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.
@divyashree4558
2 жыл бұрын
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.
@RezaDorrani
2 жыл бұрын
@@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.
@victoriacabodevila2026
7 ай бұрын
How can I delete the word after write and select the item? I don´t want to use the "x"
@RezaDorrani
7 ай бұрын
Im not aware of any other way to do it
@victoriacabodevila2026
7 ай бұрын
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
@victoriacabodevila2026
7 ай бұрын
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
@RezaDorrani
7 ай бұрын
Possible but again not something I have tried
@FerencHarmann
4 ай бұрын
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
@RezaDorrani
4 ай бұрын
Not sure about this
@FerencHarmann
4 ай бұрын
@@RezaDorrani Thx
@mahekpandya1900
Жыл бұрын
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?
@RezaDorrani
Жыл бұрын
Check the following kzitem.info/news/bejne/2m9m0niKgYGeZqA
@anjalikapartiwar6808
7 ай бұрын
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?
@RezaDorrani
7 ай бұрын
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
@MikariN40
Жыл бұрын
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?
@RezaDorrani
Жыл бұрын
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
@MikariN40
Жыл бұрын
@@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 :)
@RezaDorrani
Жыл бұрын
@@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/
@diegosmarinho
7 ай бұрын
Updating manually the array for SearchFields property is not working. Any ideia on the reason?
@RezaDorrani
7 ай бұрын
No ideas as I have not come across this issue
@srivenkateshsatti3402
14 күн бұрын
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
@RezaDorrani
13 күн бұрын
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
@kamranpatel4489
Жыл бұрын
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
@RezaDorrani
Жыл бұрын
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
@Succuub
10 ай бұрын
Any idea what to do then part 'Self.SearchText' doesn't work in Custom Page MD?
@RezaDorrani
10 ай бұрын
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
@estherlopeznavarro6100
Жыл бұрын
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!
@RezaDorrani
Жыл бұрын
I have not come across this issue hence not sure. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@sainathp991
11 ай бұрын
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
@RezaDorrani
11 ай бұрын
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
@matthewlim4642
7 ай бұрын
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?
@RezaDorrani
7 ай бұрын
I am not aware if that is a possibility
@amitkhatakar1806
Жыл бұрын
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?
@RezaDorrani
Жыл бұрын
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
@PandeyArun390
Жыл бұрын
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
@RezaDorrani
Жыл бұрын
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
@mabob12
6 ай бұрын
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,
@RezaDorrani
6 ай бұрын
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
@mabob12
6 ай бұрын
@@RezaDorrani Thank you Raza. I have already posted my question on Powerapps community, but so far no response :(
@RezaDorrani
6 ай бұрын
@@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
@taylorhines1031
2 жыл бұрын
What if I wanted to input my own value as well as chose from the list?
@RezaDorrani
2 жыл бұрын
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.
@vivekreddy2063
Жыл бұрын
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
@RezaDorrani
Жыл бұрын
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
@rathikavenkatesh2510
Жыл бұрын
CAn you share the code how to load multiselect combox values after retrieve from table
@RezaDorrani
Жыл бұрын
Video shows exactly that step by step
@2007pradipta
Жыл бұрын
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 ?
@RezaDorrani
Жыл бұрын
Distinct is not a delegable function. Im not aware of any workarounds.
@Club08Official
3 ай бұрын
How to show icons and images in combo box just near to the text
@RezaDorrani
3 ай бұрын
I dont think thats an option
@adityapadmawar8754
8 ай бұрын
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
8 ай бұрын
Not sure as this is not something I have tried
@adityapadmawar8754
8 ай бұрын
@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)
@RezaDorrani
8 ай бұрын
@@adityapadmawar8754 I dont think that is an option
@adityapadmawar8754
8 ай бұрын
@@RezaDorrani Okay. Thanks a lot for your response Reza!
@legendgod
11 ай бұрын
Could we limit number of selection in combobox down to 5 choices only?
@RezaDorrani
11 ай бұрын
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
@shannonmarceau
2 жыл бұрын
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)
@RezaDorrani
2 жыл бұрын
Dataverse for teams is modern UI. It does not have the layout option.
Пікірлер: 357