Reza Thanks a ton ! You have No IDEA ! how much I was looking for the section from 7:39 to 12:30 mins. Thanks a bunch for showing the formula fix after deleting tabs.
Thank you. I do have around 28 videos on Power automate and more coming. Power Automate (flows) ua-cam.com/play/PLTyFh-qDKAiEs0rhQuR7fwSv5_63FHr_0.html
Your videos have been very helpful in creating an powerapp for my work in manufacturing environment. Can you make a video explaining combo box usage with an example? I’m unable to save the data when I use combo box.
Those who have issue while writing on second dropdown Filter('TicketCategoryType, Department= drpDept.Selected.Results).'Request type' try writing "Value" instead of "Results"
Thanks! Thats due to a change made in product since the time of this video. learn.microsoft.com/en-us/power-platform/released-versions/powerapps-studio-players/3.23024
Thank you Reza for another great tutorial video. I was able to create the two-level cascade successfully. Is there a way to cascade subsequent levels? My customer's app has 5 levels they wish to choose. Thanks for your immeasurable help.
5 level cascading is a lot :) You would need to keep filtering the subsequent dropdown with the previous selection. There is a way and it depends on the scenario. Its not about 5 levels. Its more about how the data is structured in the backend.
Hi Reza, excellent video. I successfully created Cascading Dropdowns in PowerApps with your fluent and strong explanation. However, I have a question. I created another application on another screen with this method. But, how can I integrate this drop-down mechanism into my resource list in Microsoft List, which I use as a resource in the application? Can I use this mechanism while entering data there?
I am not sure about your scenario or if this method would work. I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Thanks Reza for the informative tutorial, I have a question, what if both fields (Department and Request Type) were both Choice fields in the SP list? will it work?
I love your videos! Do you have one that shows how to make check boxes that when selected, opens another fillable field? For example, if I want to ask the participant if they have another request..they check yes and a box opens…
I do not have a video reference on it. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Learning a lot from you Reza. I have a quick question. What is the best possible way to manage cascading drop-down In canvas app using common data service or we can say dataverse..? Are there any option to manage cascading drop-down using lookup
Hi Reza! I have used a few tutorials on power apps but yours are by far the best, thank you! I did as you have done in this app but when I submit my data it doesn’t submit for the two fields that come from the second Lists. Is there a way around that?
Thanks James. 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 was fantastic and easy to follow. One problem, my second dropdown, values dependent on the first dropdown, is not populating in the Sharepoint List - any thoughts?
I will have to look at your App in action to know about your issue & provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi Reza, excellent video. Do you have a tutorial explaining how we can change the default value of a drop down to some thing like the "Find Items" you have instead of it being one of the options from the dropdown list ?
@@RezaDorrani Can you please share the link to this video ? I applied the cascading filtering as instructed in the video above, but the end users complain about the fact that the dropdowns do not have a search functionality (I have over 300 choices to choose from...) Looking forward to receive that precious link ! ;-)
Thank you Reza for this great info. I'm wondering if you can give us some tips on how to use Dataverse for Teams instead Sharepoint lists as a datasource
Hi Reza, thanks for the helpful videos you are posting on youtube. Are you okay if I use what you are teaching for my development efforts/products at work?
These videos are great! Is there a way to save a record that is based on the "Department" selection. For example, choosing "IT" from the dropdown and saving it to a SharePoint "IT" List, choosing "Marketing" to a SharePoint "Marketing" List, etc...?
Hi Reza, amazing job!! thanks for sharing the knowledge! I'm stuck trying to save the Form... the cascading field is not saving in the SP List. Any help will be grateful!! thanks in advance!
I would have to see your app in action (screenshots, data source info etc.) provide any guidance. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
Did you manage to save the Form? I am also experiencing the same problem... the cascading field will not save in the SP list and I can't solve the issue
Great find. Is there a maximum limit on how many rows can be on SharePoint list? I am trying to create cascade cobmo box with country and city. It seems I am getting maxed out at ~450 rows. Is there any alternative solution? Thank you.
I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted topic ideas get added to my backlog. Make sure to suggest this idea whenever the next topic suggestion post is out.
Hey Reza, thanks so much for the tutorial. I had a doubt though, is the excel file that you uploaded dynamic. Because I wanted to something similar but which reflects changes in the Poweapps dropdown according to changes in my excel file. If it does not, could you please help me on how to do it . Thanks again.
I did this video so long ago - that I do not remember the specifics. You can connect to excel that's stored in SharePoint as well I believe. Try exploring that option.
Not sure I understood that question but if using person type column the formula would be different. I would recommend to check on the forums if someone has done something similar at powerusers.microsoft.com/
I have used the Microsoft lists template. The colors you see are the SharePoint column formatting options which come as part of those templates. You can format columns, views and forms with those features. Check - ua-cam.com/play/PLTyFh-qDKAiE7C_2lVNAPzgHXsBykG0Tf.html
Thanks Reza for your sharing! And if I quote the items from sharepoint list in Power Apps for cascading, do the other users need the list permissions, like view or write? In another word, user can view the list in advance, then can choose in Power Apps.
Hi Reza,very nice video,full of very useful information.I created one cascaded drop down based on excel table ,and trying to Patch in sharepoint List,but it is showing Datatype error("Expecting a record type data something like this").How to solve this please.
I will have to look at your app in action to provide guidance. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani Thanks a lot for such a quick response .In short I can say ,Data is coming from Excel table for cascade drop downs in PwerApps( working well upto here). Now it is required to Patch it in Sharepoint list here it is giving error.Hopefully you understand my problem clearly.
Hello Reza, this video is so so helpful! Thank you so much. I came across an issue with cascading dropdowns for which I have 2 dropdowns referencing the same data base (ex. the Department in your example), in which one of the cascading dropdowns is working fine since it is exactly the Request type as you showed, but the other cascading dropdown is like the Request type but you can select multiple answers and I cannot figure it out out to solve my error. Do you know if this is an easy fix and/or how to?
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
Thank you Reza! Can we have 'Request type' column as choice field instead of single line column. It would be great help, if you can help us with 3 level cascading. Two choice column and one single line column.
@@NarnawareSunil It will work as well. Just that the logic will be different. This is something I would have to try out. I would recommend you check on the forums at powerusers.microsoft.com/
@@NarnawareSunil I have 4 level cascading in my PowerApp. Level 1 is Site, Level 2 is Building, Level 3 is Line, Level 4 is Details. All in a SharePoint Table called "Master Site Equipment List". For Site, Items = Choices('Master Site Equipment List'.Site). For Building, Items = Sort(Distinct(Filter('Master Site Equipment List',Site.Value = drpSite.Selected.Value),Building),Result,Ascending). For Line, Items = Sort(Distinct(Filter('Master Site Equipment List',Building = drpBuilding.Selected.Result),Line),Result,Ascending). For Details, Items = Sort(Distinct(Filter('Master Site Equipment List',Line = drpLine.Selected.Result),Details),Result,Ascending). These formulas also sort the results in ascending order.
Hi Reza: This is very helpful. Thank you. I have a quick question: I have a dropdown with Question Nos. 1 to 10. Is it possible to select only question numbers that are not already answered in the Rich Text Input Box below or are not already selected from that dropdown? Meaning, can we control the dropdown items conditionally?
@@RezaDorrani Sure. I thought I could save a modern Sharepoint List as a template by exporting to an Excel Table and then importing while creating a new List. This actually works to a certain extent except for Multiple Choice formatting. This breaks upon import.
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, thank you for the video. Once I added the dropdown input, the data for that specific field doesn't push to the Sharepoint list. What am I missing, please?
I will have to look at your App in action to know the reason for your issue. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani Hey Reza, I wanted to let you know that I worked out the problem with my list.. Thanks again for your help.. I have set up quite a few PowerApp forms for my teams just by learning from your videos.. Thank you so much for them..
Hi Reza.. Thanks for sharing this video. Its really helpful. I am trying to used combo box instead of Dropdowns as I need multiple options to be selected. I can select multiple options but in my SharePoint list only the last selected options is saved. I am not sure why? Are you able to help me on this?
I would have to try it out to provide any assistance + I would have to look at exactly how you are implementing it. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi Reza, how do you assign the value of the dropdown box to the original sharepoint list? I can do the cascading, but cant get the information on those fields to flow properly to the sharepoint list.
@@RezaDorrani Thank you, effectively the steps are in the video. I think the field i was looking for is "Data Field". I had to start from scratch because when you have played with the columns and columns names in the SharePoint list a lot all the tags become a mess.
Reza, would I be able to use this method to connect to my other apps? What I want to do is have a page with a single drop down with a selection of my apps in it and a title of “What do you want to do” so the user can choose from the multiple lists/spreadsheets we have in the team scattered about, they only have to go to one place.
@@Cartoonhotpot This is something I would need to try out and check whats possible. I would recommend checking on forums in case someone has done something similar powerusers.microsoft.com
@@RezaDorrani Thank you Reza... Your videos are very helpful...I am trying to create an app for my work group....In my share point list I have some items in the dropdown list. For example item1,item2,item3,,item4,item5. Is it possible to limit the visibility of some items in the dropdown list to different users? User1 should be able to see item1 and item2. And user2 should be able to view only item3,4,5 . Is there any way to do that ?
@@87midhunraj Thanks. How would power apps know which item is to be visible to which user? You could either hardcode or set permissions at SharePoint level. I have not done anything like this though or have a video reference related to it.
@@RezaDorrani Thank you so much Reza for the quick response. I am just a beginner in PowerApps. I am considering you as my teacher. The way you are explaining all is amazing.Thank you...🤗
Possible but I do not have a video reference on it 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.
I’m using patch function to update the input values to the share point list. I’m using combo box for cascading. Now how the combo box value would go in a text filed of what point list??
This works fine when putting our columns on a separate screen. The cascade is working fine as we pull in several lists that form our cascade. As soon as these fields are put into the form we have, it ceases to work. Is there anything special we need to do to make this work within our form?
Video showcases cascading in form. 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
Great video Reza. I tried doing this for my app but I have a problem My cascading SharePoint list is composed by two columns: The Title (text) and a column called Type (choice) However, the SharePoint list that I use for my app has two choice columns: Type and Tool, and I think that the column Tool isn't updating since the data format is different. Do you have any advice for this? Thanks in advance
I will have to either recreate your scenario or 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, I wanted to fetch single column data from excel into powerapp Like i wanted to give Manager name and on submit button it should show all the employees reporting to that manager .... Can this be done in powerapp if yes how ? Please please help
Can be done but 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
Hello Reza great video I really enjoyed it. I have an error I can't seem to resolve as I am creating multiple cascading drop downs 3 in total. The error populates on the 2nd and 3rd drop down in my filter function when my 1st drop is blank it says my expression "System eq null" is not supported. This occurs in both my 2nd and 3rd drop downs in the Items functions and it is telling me it is related to the Filter portion. Looking for some help on resolving this.
I will have to look at your App in action to provide any guidance. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
@@geethanjali.c.gowda1037 I would have to look at your error message and how the controls are setup. Post your query with screenshots on the forums - powerusers.Microsoft.com
Is it possible to create two way cascading with combobox? If I select value in first combo box, it should filter values in second combobox. If I select value in second combobox , it should filter values in first combobox.
Possible. I do not have a video on that use case. Will add it to my backlog but this is the first request on this topic. I will need a lot more requests on this topic to give this a higher priority. Meanwhile, I will recommend you check on the forums at powerusers.microsoft.com/
I will have to look at your App/scenario in action to provide any guidance. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani I am trying to reference to see if a dropdown1 equals a value -example: If(Dropdown1.Selected.Value = "Yes",Dropdown2.Selected,{Value: "name of a employee"}). Can you share any video tutorial like this? Thanks in advance
@Reza Dorrani, First of all thank you for making these type of great & helpful videos. Secondly, I have one query if you or someone can help me, Query: I have many Combo Box in PowerApps Form. But In ComboBox1 has Region Name & ComboBox2 has Cities Name & In back end data i am using share point list & both column has Type Choice. So, I want to create cascade between these 2 ComboBoxes. Like; If i select Specific Region Name in ComboxBox1 so automatically the ComboBox2 shows only related Region Cites Name. Please share if one knows the solution or any other way to get the desired result. Thanks
In this case the values selected will be displayed in SharePoint List. I dont know what inputted means. You want user to input cascading values? I do not have any video references on it. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
DROPDOWN.SelectedText should do it but depends on how you have configured the dropdown. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
you do 2:55 to 4:55 is grate. but i want to do in one dropdown which formula i can try it. i try this ::Filter(Quotations, 'Customer Status'.Value = "won").Id and this ::Filter(Quotations, 'Customer Status'.Value = 1).Id ..............give you formula for this.!!
I would have to try this out to give/know the exact formula. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
I do not have a video reference with Dataverse. I would recommend checking on forums in case someone has done something similar powerusers.microsoft.com
do you mind sharing the code for the onscreen/onstart , the request types are not registering for me, if you could give me the full app that would be helpful
Hi Rezza, just wondering what if both my field that will be used on the dropdown values are of "Single line of text" type? In your example you have Departments as a choice, in my case I have text type for both. Will that work? If yes, how could I make it work? Thanks!
i really appreciate if you can help me. i am new to power app. i have two share point lists. 1. site select selection check list . on that list i have a column called "trail ID" ( that is auto generating from power automate. its a unique number) . then my other list 2. " land contract" i need that trial ID to that list as well. i did cascading function. Then common factor is the name. i watched all your videos. i cant figure out . i get a yellow tringle error sating " incompatible types for comparison. Any thoughts? Thank You
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 was successful with this; however, my distinct is pulling only values (sharepoint list column values) until C whereas I have until Z. Can you help me get all the distinct values
Hi Reza. How did you customise your form to place it at the center. And when i share the access of the list to someone else, and when he clicks new the cascading drop-down doesn't appear. Thanks in advance
Customise your form to place it at the center? at which point in video (share the time). For your issue, 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 Thanks for that i figured out tha. Just in case if i am sharing the list with someone else. The items in the drop-down doesn't show up to him but when i create new the drop-down shows
@@namananand2364 Check in SharePoint. Difficult to provide guidance here on chat. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com/
Hey Reza, I really would appreciate your help, I have followed this video to the letter, at 9min 42 when you make sure you select Value - mine has no option to select the column. I have been in circles - any tips how to get this resolved ?
The dropdown list control has its items property coming from my SharePoint list. With the dropdown selected, in the properties pane on the right hand side you should get the option to select the Value.
Excel data types would be different. I do not have a video reference on excel and have not tried it hence not sure. I would recommend posting your query/issue with screenshots on the forums at powerusers.microsoft.com
![How to create a dependent cascading Drop Down, Combo Box controls in Power Apps [Patch]](http://i.ytimg.com/vi/tunWOyPcXks/mqdefault.jpg)
Keep dropping these gems brother!
Thank you. I will keep trying my best.
Reza Thanks a ton ! You have No IDEA ! how much I was looking for the section from 7:39 to 12:30 mins. Thanks a bunch for showing the formula fix after deleting tabs.
You’re most welcome
@@RezaDorrani Any idea of not saving cascade data to SharePoint ? all other fields are saving though.
@@jessy.rozario No idea as I have not come across the issue. I recommend checking or posting your query on forums
powerusers.microsoft.com
I can't tell you how much thankful I am for your this post. Exactly, what I was looking for. Thanks a lot again.
You are most welcome. Thanks for watching.
You saved my butt today! Thank you for making this video. Extremely helpful!!!
Glad to know the video was helpful. Thanks for watching.
Reza .. You really making life simple by sharing your tips... You are my super hero..🦸♂️
Thank you for your kind words.
Got to know the way of handling of text and choices types of drop downs. Thanks a lot to highlight it
My pleasure
You are super sir.....
Your teaching techniques are so amazing 👌👌
Thanks a ton
Thanks Reza for this video. Clean and simple explanation.
My pleasure!
Thank you Reza for the detailed video, this will help me transition from InfoPath to PowerApps smoothly. Well explained👏🏾👏🏾👏🏾👌🏿
Glad it was helpful!
Thanks Reza always interesting to watch and learn from your video's
You are most welcome Sundra
Thank you Reza. Exactly what I was looking for! :)
You are most welcome!
This is absolutely great content, thanks for sharing!!!
Glad you enjoyed it!
TQ Reza....This video Helped me Well, Thanks For Detailed explanation :)
Glad to hear that
Perfect video. Thank you!
You're most welcome!
Very useful,Excellent work!
Thank You
It's really nice video I learned new today
So glad to hear that and thanks for watching
Very detailed explanation. Thank you Reza 👍
Thank you for watching
Thank you very much ..really very nice and thanks for detailed explanation :)
You are most welcome
Thank you so much! Really useful😊
Glad it was helpful!
Great Video Reza, Thank you for sharing!
Thanks for watching
Thank you so much, you helped a lot!
Thanks for watching
Very nice scenario. Happy to see your videos. Kindly make some videos on Power Automate as well.
Thank you.
I do have around 28 videos on Power automate and more coming.
Power Automate (flows) ua-cam.com/play/PLTyFh-qDKAiEs0rhQuR7fwSv5_63FHr_0.html
This is so useful, thanks!
Your most welcome
Really nice and well explained
Thank You
Yesssss , Thank you RD
👍
Muchas gracias brother!
Thank You!
Thank you Reza for this
You are most welcome
Thank you very much for this video....
You are most welcome
Thank you for your sharing.
I have question in time 4:05 dropdown list in excel data base. How to set show alphabetical order "a-z"?
Thank you
Explore the Sort function
Your videos have been very helpful in creating an powerapp for my work in manufacturing environment. Can you make a video explaining combo box usage with an example? I’m unable to save the data when I use combo box.
Great to hear that.
Check out my forma tutorial - ua-cam.com/video/aVEaRpAlaTA/v-deo.html
One great video after another ... could you please upload this Power App file somewhere so it can be shared?
Here you go - github.com/rdorrani/PowerApps/blob/master/HelpDesk-CascadingDropdowns_20210218143903.zip
@@RezaDorrani Thank you very much!
Those who have issue while writing on second dropdown Filter('TicketCategoryType, Department= drpDept.Selected.Results).'Request type' try writing "Value" instead of "Results"
Thanks!
Thats due to a change made in product since the time of this video. learn.microsoft.com/en-us/power-platform/released-versions/powerapps-studio-players/3.23024
Thank you Reza for another great tutorial video. I was able to create the two-level cascade successfully. Is there a way to cascade subsequent levels? My customer's app has 5 levels they wish to choose. Thanks for your immeasurable help.
5 level cascading is a lot :)
You would need to keep filtering the subsequent dropdown with the previous selection.
There is a way and it depends on the scenario. Its not about 5 levels. Its more about how the data is structured in the backend.
i got it to 3 levels! It is alot.This is the military and they have alot of levels to their staff.
Here is your like and your subscribe good man, this video helped a lot, thanks
Thanks for the sub!
Hi Reza, excellent video. I successfully created Cascading Dropdowns in PowerApps with your fluent and strong explanation. However, I have a question. I created another application on another screen with this method. But, how can I integrate this drop-down mechanism into my resource list in Microsoft List, which I use as a resource in the application? Can I use this mechanism while entering data there?
I am not sure about your scenario or if this method would work. I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Thanks Reza for the informative tutorial, I have a question, what if both fields (Department and Request Type) were both Choice fields in the SP list? will it work?
Formula would be different but it can work. I did another video on cascading as well where I may have shown that.
I love your videos! Do you have one that shows how to make check boxes that when selected, opens another fillable field? For example, if I want to ask the participant if they have another request..they check yes and a box opens…
I do not have a video reference on it. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Learning a lot from you Reza.
I have a quick question.
What is the best possible way to manage cascading drop-down In canvas app using common data service or we can say dataverse..?
Are there any option to manage cascading drop-down using lookup
I believe approach will be similar to the one showcased in the video. I have not give cascading a try though with Dataverse
Hi Reza! I have used a few tutorials on power apps but yours are by far the best, thank you!
I did as you have done in this app but when I submit my data it doesn’t submit for the two fields that come from the second Lists. Is there a way around that?
Thanks James.
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
Did you find a solution for this?
This was fantastic and easy to follow. One problem, my second dropdown, values dependent on the first dropdown, is not populating in the Sharepoint List - any thoughts?
I will have to look at your App in action to know about your issue & provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani Thank you!
Waiting
Hope you enjoy the video
Thank you Reza for this great tutorial video.
Would it be possible to create the same instead of the Drop Dow for a combo box?
Yes possible. Beauty of data cards in a form control is they can be changed per your needs.
Great
Thanks
Hi Reza, excellent video. Do you have a tutorial explaining how we can change the default value of a drop down to some thing like the "Find Items" you have instead of it being one of the options from the dropdown list ?
Your request will be my video in 2 weeks time :)
@@RezaDorrani Can you please share the link to this video ? I applied the cascading filtering as instructed in the video above, but the end users complain about the fact that the dropdowns do not have a search functionality (I have over 300 choices to choose from...)
Looking forward to receive that precious link ! ;-)
@@ghyootceg Default values - ua-cam.com/video/bjvigaL68ts/v-deo.html
Combo Box - ua-cam.com/video/zPM0Q53L3sE/v-deo.html
Thank you Reza for this great info. I'm wondering if you can give us some tips on how to use Dataverse for Teams instead Sharepoint lists as a datasource
I did a full series on Dataverse for Teams including live videos.
Check ua-cam.com/play/PLTyFh-qDKAiFG_FxWr-ACSmP39_84IUWl.html
Hi Reza, thanks for the helpful videos you are posting on youtube. Are you okay if I use what you are teaching for my development efforts/products at work?
100%
All of my videos are for community. Feel free to use them as you want.
These videos are great! Is there a way to save a record that is based on the "Department" selection. For example, choosing "IT" from the dropdown and saving it to a SharePoint "IT" List, choosing "Marketing" to a SharePoint "Marketing" List, etc...?
You could use the Patch function to do that.
Switch(dropdown.selected.value, “marketing”, patch to marketing list, “it”, patch to it list)
Hi Reza, amazing job!! thanks for sharing the knowledge! I'm stuck trying to save the Form... the cascading field is not saving in the SP List. Any help will be grateful!! thanks in advance!
I would have to see your app in action (screenshots, data source info etc.) provide any guidance. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
Did you manage to save the Form? I am also experiencing the same problem... the cascading field will not save in the SP list and I can't solve the issue
Hi!! Very useful and great tips provided, Can you share another video with some different examples?
Can you give examples of the different examples 😀
@@RezaDorrani Sure!! :)
Hi Reza, is there a video on how to do this using modern controls?
No
Thanks for this video, how can I add "Yes" & "No" in the dropdown control without using any table/list or any dataset
["Yes","No"]
@@RezaDorrani thanks but again the question is where should I give these values? In OnSelect or somewhere else
directly on items property since you want to hardcode
Great find. Is there a maximum limit on how many rows can be on SharePoint list? I am trying to create cascade cobmo box with country and city. It seems I am getting maxed out at ~450 rows. Is there any alternative solution? Thank you.
I believe its 500 which is the delegation limit. Alternate solution would be to use a gallery so user can select the value.
@@RezaDorrani Tank you for confirming. I could not find any document that confirmed this. However I can take your reply as 'official document' ;)
@@md.fazlulkarim :)
Can you please create similar video for cascading dropdown using modern controls?
I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted topic ideas get added to my backlog. Make sure to suggest this idea whenever the next topic suggestion post is out.
Hey Reza, thanks so much for the tutorial. I had a doubt though, is the excel file that you uploaded dynamic. Because I wanted to something similar but which reflects changes in the Poweapps dropdown according to changes in my excel file. If it does not, could you please help me on how to do it .
Thanks again.
I did this video so long ago - that I do not remember the specifics. You can connect to excel that's stored in SharePoint as well I believe. Try exploring that option.
Hi Reza, Could you please help me with Multiselect cascade dropdown option. Thanks in advance
I will add this to my backlog. I do not have a video on it. Try posting your query on the forums at powerusers.microsoft.com/
that was great but what of one the lookup fields is people type how to fetch that?
Not sure I understood that question but if using person type column the formula would be different.
I would recommend to check on the forums if someone has done something similar at powerusers.microsoft.com/
You are genius! Btw, how did you put a color on the left side of each item in the list or where they are coming from?
I have used the Microsoft lists template. The colors you see are the SharePoint column formatting options which come as part of those templates. You can format columns, views and forms with those features. Check - ua-cam.com/play/PLTyFh-qDKAiE7C_2lVNAPzgHXsBykG0Tf.html
Is there a video on how you got the browse gallery layout to look like that?
ua-cam.com/video/bnC8u3gdWss/v-deo.html
Thanks Reza for your sharing!
And if I quote the items from sharepoint list in Power Apps for cascading, do the other users need the list permissions, like view or write?
In another word, user can view the list in advance, then can choose in Power Apps.
Yes, users would need read access.
Would this work in the grid view of the list? Thank you
It would. Code would differ though based on grid design.
Hi Reza,very nice video,full of very useful information.I created one cascaded drop down based on excel table ,and trying to Patch in sharepoint List,but it is showing Datatype error("Expecting a record type data something like this").How to solve this please.
I will have to look at your app in action to provide guidance. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani Thanks a lot for such a quick response .In short I can say ,Data is coming from Excel table for cascade drop downs in PwerApps( working well upto here). Now it is required to Patch it in Sharepoint list here it is giving error.Hopefully you understand my problem clearly.
@@_Raj- Please post the issue with screenshots on forums. Your use case is not something I have shown in a video.
Hello Reza, this video is so so helpful! Thank you so much. I came across an issue with cascading dropdowns for which I have 2 dropdowns referencing the same data base (ex. the Department in your example), in which one of the cascading dropdowns is working fine since it is exactly the Request type as you showed, but the other cascading dropdown is like the Request type but you can select multiple answers and I cannot figure it out out to solve my error. Do you know if this is an easy fix and/or how to?
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
Thank you Reza!
Can we have 'Request type' column as choice field instead of single line column.
It would be great help, if you can help us with 3 level cascading. Two choice column and one single line column.
I have added this request to my backlog
@@RezaDorrani yes.. i too have this question.. what if both are choice columns.. instead of one being the single line of text..
@@NarnawareSunil It will work as well. Just that the logic will be different. This is something I would have to try out. I would recommend you check on the forums at powerusers.microsoft.com/
@@NarnawareSunil I have 4 level cascading in my PowerApp. Level 1 is Site, Level 2 is Building, Level 3 is Line, Level 4 is Details. All in a SharePoint Table called "Master Site Equipment List". For Site, Items = Choices('Master Site Equipment List'.Site). For Building, Items = Sort(Distinct(Filter('Master Site Equipment List',Site.Value = drpSite.Selected.Value),Building),Result,Ascending). For Line, Items = Sort(Distinct(Filter('Master Site Equipment List',Building = drpBuilding.Selected.Result),Line),Result,Ascending). For Details, Items = Sort(Distinct(Filter('Master Site Equipment List',Line = drpLine.Selected.Result),Details),Result,Ascending). These formulas also sort the results in ascending order.
Hi Reza: This is very helpful. Thank you. I have a quick question: I have a dropdown with Question Nos. 1 to 10. Is it possible to select only question numbers that are not already answered in the Rich Text Input Box below or are not already selected from that dropdown? Meaning, can we control the dropdown items conditionally?
You could by using filter function on items property of dropdown. Seems a very specific use case though. I have no references on this.
Great! Can you show me how to import an excel table with dropdowns into Sharepoint online, so it retains the Choices formatting?
Export table with dropdowns? I did not understand the question.
@@RezaDorrani You know, multiple choice answers
@@jeffmcguire2072 But what about retaining formatting? Not sure what that means.
@@RezaDorrani Sure. I thought I could save a modern Sharepoint List as a template by exporting to an Excel Table and then importing while creating a new List. This actually works to a certain extent except for Multiple Choice formatting. This breaks upon import.
@@jeffmcguire2072 There are limitations. One of them is the multi choice column.
Hi Reza,, thanks for your video. can you help me why the data i select using cascade is not filled in my list?
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, thank you for the video. Once I added the dropdown input, the data for that specific field doesn't push to the Sharepoint list. What am I missing, please?
I will have to look at your App in action to know the reason for your issue. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani Hey Reza, I wanted to let you know that I worked out the problem with my list.. Thanks again for your help.. I have set up quite a few PowerApp forms for my teams just by learning from your videos.. Thank you so much for them..
@@sophiadcosta-braganza5954 Awesome 👏
Can you do a cascade from the sharepoint list or it can only be done via powerapps? If its only in powerapps, can it be ran via a browser? Thank you
Via a sharepoint list - out if the box there is no option.
Can be done using spfx or power apps.
There are sp custom form based power apps.
Hi Reza.. Thanks for sharing this video. Its really helpful. I am trying to used combo box instead of Dropdowns as I need multiple options to be selected. I can select multiple options but in my SharePoint list only the last selected options is saved. I am not sure why? Are you able to help me on this?
I would have to try it out to provide any assistance + I would have to look at exactly how you are implementing it.
I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi Reza, how do you assign the value of the dropdown box to the original sharepoint list? I can do the cascading, but cant get the information on those fields to flow properly to the sharepoint list.
The steps are as shown in the video.
@@RezaDorrani Thank you, effectively the steps are in the video. I think the field i was looking for is "Data Field". I had to start from scratch because when you have played with the columns and columns names in the SharePoint list a lot all the tags become a mess.
@@chigoth hope it worked
Is it possible with data from people column? I see you have card Assigned to, does it work like other dropdowns?
Not sure about this one. I would have to explore and try it out.
I will recommend you check on the forums at powerusers.microsoft.com/
Reza, would I be able to use this method to connect to my other apps? What I want to do is have a page with a single drop down with a selection of my apps in it and a title of “What do you want to do” so the user can choose from the multiple lists/spreadsheets we have in the team scattered about, they only have to go to one place.
I don’t think this scenario is for such a use case. I have not tried it so not sure.
@@RezaDorrani ok, so what would me the best method for selecting various apps from one location so the user doesn’t have a long list of URLs?!
@@Cartoonhotpot This is something I would need to try out and check whats possible. I would recommend checking on forums in case someone has done something similar
powerusers.microsoft.com
Hello, How about the people field, how do you select that and patch?
Check ua-cam.com/video/g9ChYuTdNd4/v-deo.html
Hi Reza, Is it possible to get selected items from a dropdown list based on the current user ?
Not sure I understand the question. What is correlation between selected items and current user?
@@RezaDorrani Thank you Reza... Your videos are very helpful...I am trying to create an app for my work group....In my share point list I have some items in the dropdown list. For example item1,item2,item3,,item4,item5. Is it possible to limit the visibility of some items in the dropdown list to different users? User1 should be able to see item1 and item2. And user2 should be able to view only item3,4,5 . Is there any way to do that ?
@@87midhunraj Thanks.
How would power apps know which item is to be visible to which user?
You could either hardcode or set permissions at SharePoint level. I have not done anything like this though or have a video reference related to it.
@@RezaDorrani Thank you so much Reza for the quick response. I am just a beginner in PowerApps. I am considering you as my teacher. The way you are explaining all is amazing.Thank you...🤗
Hi Reza, Is it possible to implement the same with multi-select People columns? I have tried different ways to achieve it but I could not.
Possible but I do not have a video reference on it 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,
While reselect parent drop-down value then how to reset second drop-down value.
If parent dropdown is changed, then dependent drop down should change automatically
@@RezaDorrani I am getting new select dependent values in the second drop-down but I want "reset" the dependent value (I am using combobox)
@@kambhampatisreenivarao8757 Not sure. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani Thank you very much for replied
I’m using patch function to update the input values to the share point list. I’m using combo box for cascading. Now how the combo box value would go in a text filed of what point list??
I did not understand your question. I recommend posting your query with screenshots on the forums at powerusers.microsoft.com
This works fine when putting our columns on a separate screen. The cascade is working fine as we pull in several lists that form our cascade. As soon as these fields are put into the form we have, it ceases to work. Is there anything special we need to do to make this work within our form?
Video showcases cascading in form. 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
Great video Reza. I tried doing this for my app but I have a problem
My cascading SharePoint list is composed by two columns: The Title (text) and a column called Type (choice)
However, the SharePoint list that I use for my app has two choice columns: Type and Tool, and I think that the column Tool isn't updating since the data format is different.
Do you have any advice for this? Thanks in advance
I will have to either recreate your scenario or 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,
I wanted to fetch single column data from excel into powerapp
Like i wanted to give Manager name and on submit button it should show all the employees reporting to that manager .... Can this be done in powerapp if yes how ?
Please please help
Can be done but 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
Hello Reza great video I really enjoyed it. I have an error I can't seem to resolve as I am creating multiple cascading drop downs 3 in total. The error populates on the 2nd and 3rd drop down in my filter function when my 1st drop is blank it says my expression "System eq null" is not supported. This occurs in both my 2nd and 3rd drop downs in the Items functions and it is telling me it is related to the Filter portion. Looking for some help on resolving this.
I will have to look at your App in action to provide any guidance. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani Thanks Reza I will request assistance through that community site.
Reza hi, is this cascading dropdown only available with Power Apps? Could it be done with only a sharepoint list?
Thanks!
Cannot be done with just a modern SharePoint list.
Hi Reza,
What would be formula for 3rd drop-down dependent on 2nd drop-down where the data source is excel file?
Similar to formula for 2nd which is based on 1st.
@@RezaDorrani Thank You for your reply!!
Can we use Distinct and Filter in same formula?
@@ashishkulkarni8193 Yes. Note that distinct returns a collection with column Result. So make sure to apply filter function accordingly.
Hi,
Would like to know how can we auto populate the data to text box control based on my dropdown selection
For the textbox default property, just use dropdown.Selected.Value or dropdown.Selected.ColumnName
@@RezaDorrani Not working !! any help
@@geethanjali.c.gowda1037 I would have to look at your error message and how the controls are setup. Post your query with screenshots on the forums - powerusers.Microsoft.com
@@RezaDorrani Thx
Have u got solution ,,??If so please say the solution
Is it possible to create two way cascading with combobox? If I select value in first combo box, it should filter values in second combobox. If I select value in second combobox , it should filter values in first combobox.
Possible. I do not have a video on that use case. Will add it to my backlog but this is the first request on this topic. I will need a lot more requests on this topic to give this a higher priority.
Meanwhile, I will recommend you check on the forums at powerusers.microsoft.com/
@@RezaDorrani, can you share any article related or base structure of the formula? It will be very helpful for me now.
@@MadRockway I am not aware of any article. I would have to try it out myself to provide any formula. Your best bet would be to post on the forums.
how do i change a dropdown value based on selection of another dropdown? any help highly appreciated.
I will have to look at your App/scenario in action to provide any guidance. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani I am trying to reference to see if a dropdown1 equals a value -example: If(Dropdown1.Selected.Value = "Yes",Dropdown2.Selected,{Value: "name of a employee"}). Can you share any video tutorial like this? Thanks in advance
@@akcreative8956 I do not have a video tutorial on this use case. I would recommend you check on the forums at powerusers.microsoft.com
@Reza Dorrani, First of all thank you for making these type of great & helpful videos. Secondly, I have one query if you or someone can help me,
Query: I have many Combo Box in PowerApps Form. But In ComboBox1 has Region Name & ComboBox2 has Cities Name & In back end data i am using share point list & both column has Type Choice. So, I want to create cascade between these 2 ComboBoxes. Like; If i select Specific Region Name in ComboxBox1 so automatically the ComboBox2 shows only related Region Cites Name. Please share if one knows the solution or any other way to get the desired result. Thanks
I do not have a video on this use case. I would recommend you post your query on the forums at powerusers.microsoft.com
@@RezaDorrani Sure, Thanks for proactive response
Is there a way to build a cascading dropdown where the values inputed will be displayed onto the sharepoint list?
In this case the values selected will be displayed in SharePoint List. I dont know what inputted means. You want user to input cascading values? I do not have any video references on it. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
While clicking the dropdown list it should display the selected text from the drop down .how could I do. pls help me out!!!
DROPDOWN.SelectedText should do it but depends on how you have configured the dropdown.
I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
you do 2:55 to 4:55 is grate. but i want to do in one dropdown which formula i can try it.
i try this ::Filter(Quotations, 'Customer Status'.Value = "won").Id and this ::Filter(Quotations, 'Customer Status'.Value = 1).Id
..............give you formula for this.!!
I would have to try this out to give/know the exact formula.
I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Hi Reza, how can this be done using Dataverse ?
I do not have a video reference with Dataverse. I would recommend checking on forums in case someone has done something similar powerusers.microsoft.com
do you mind sharing the code for the onscreen/onstart , the request types are not registering for me, if you could give me the full app that would be helpful
I did this video a long while ago and do not have the app anymore. The video is the best reference I have.
Hi Rezza, just wondering what if both my field that will be used on the dropdown values are of "Single line of text" type? In your example you have Departments as a choice, in my case I have text type for both. Will that work? If yes, how could I make it work? Thanks!
Yes, it will work. You can populate the data using Distinct function as shown in the video.
choice dropdown depends on choice dropdown by using share point list in power app. please explain
dropdown values are populated from choice column in SharePoint
i really appreciate if you can help me. i am new to power app.
i have two share point lists. 1. site select selection check list . on that list i have a column called "trail ID" ( that is auto generating from power automate. its a unique number) . then my other list 2. " land contract" i need that trial ID to that list as well. i did cascading function. Then common factor is the name. i watched all your videos. i cant figure out .
i get a yellow tringle error sating " incompatible types for comparison. Any thoughts?
Thank You
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 was successful with this; however, my distinct is pulling only values (sharepoint list column values) until C whereas I have until Z. Can you help me get all the distinct values
Distinct is not a delegable function and there is no way around it as far as I know.
Hi Reza, I'm trying to follow the Filter formula but I don't have the .Result but the available is .Value only.
Because .Result got changed to .Value since I did this video years ago
@@RezaDorrani but it should be the same formula?
@@PopoyTanke instead of Result you will use Value
Hi Reza. How did you customise your form to place it at the center. And when i share the access of the list to someone else, and when he clicks new the cascading drop-down doesn't appear.
Thanks in advance
Customise your form to place it at the center? at which point in video (share the time).
For your issue, 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 Thanks for that i figured out tha. Just in case if i am sharing the list with someone else. The items in the drop-down doesn't show up to him but when i create new the drop-down shows
@@namananand2364 Check permissions of that user.
@@RezaDorrani it would be great if you could tell how can i do that. I'll be really thankful for that
@@namananand2364 Check in SharePoint. Difficult to provide guidance here on chat. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com/
Hey Reza, I really would appreciate your help, I have followed this video to the letter, at 9min 42 when you make sure you select Value - mine has no option to select the column. I have been in circles - any tips how to get this resolved ?
The dropdown list control has its items property coming from my SharePoint list. With the dropdown selected, in the properties pane on the right hand side you should get the option to select the Value.
Hi Reza, I tried to do this via excel but the options are showing as blank. What do I need to do to show the available options?
Excel data types would be different. I do not have a video reference on excel and have not tried it hence not sure. I would recommend posting your query/issue with screenshots on the forums at powerusers.microsoft.com