OMG. You saved my life. I was struggling with the problem to make the form accept card change. I needed exactly what you explain. Thank you so much. Brazilllllll
Thank you so much for the help! this has worked great. Is there a way you can do the same Cascading drop down, but allowing you to select more than one choice on the (dependent Dropdown), or the second drop down that depends on the first selection?
Thanks. Could you please prepare a quick video on Model Driven PowerApp as well for just a simple Country and State scenario? Or guide on any similar tutorial for it. I am interested in joining your course on Udemy as well if this topic is available there. Please help! Thank you so much!
Great tutorial - thank you! Question, while I see the dropdowns in the SPO form and it behaves as expected, I'm not seeing any dropdown items when I'm in the 'Edit in grid view'. Is this normal behavior or is something wrong on my end?
Hello sir, first of all i would like to thank you for this video which helped me create a form which has multiple CBs depending on others. THANK YOU. Right now i'm stuck at one thing where the combo box has duplicates and i'm not able to apply DISTINCT function since its already using FILTER function. /// Formula in ITEMS -> Filter('List-activities', MainActivity = cb_main_activities.Selected.MainActivity)
Add distinct before the filter and end it with second category like for me District was dependent on State and the syntax which worked is Distinct(Filter(CascadingDropDownExample, StateName = dd_State.Selected.Result),District)
Hello Ali, and many thanks for your videos, I tried this cascading dropdown menu for my sharepoint list and I need to let it open for multiple choice, but when I save it only save one Item, what can I do for that? thanks in advance for your help
Hello, thx for this very good video, i have only the problem that i can update the data from the dropboxes, but when i reopen the data record the dropdown has other values not the record data. it seems that the dropdown dont get the real data to the dropboxes. do you have a tip for me? Greetings from DE
Hi, it really helped, thanks for the video. Also would like to know how to bring these cascade dropdown into bulk edit window of Sharepoint? Any thoughts
Hi Alizera, i would like to add an extra column so i get 4 levels of cascading, is that even possible? Every filter of distinct i tried, i get error's.
Thanks. I have followed these instructions and achieved adding a cascading dropdown field. There is one problem, though. The data from the DDL is entered and stored and viewable in the regular SharePoint view. But when the Power Apps form is reopened to edit, the cascading dropdown field looks empty, even though the data has not been lost. Any advice is appreciated.
Hello Ali, Both the approaches are superb, but in prefer the first approach since it is very easy for the end user to use without any help. The problem where I am facing is that the second dropdown is showing the complete list of. Is there any restriction in the dropdown that not more then this count will be shown.
Hi teacher. I was able to follow your procedure and finish. Helped me a lot. But I am wanting to include a third dim table, and I am creating a new dropdown, and this dropdown will be filtered based on the result selection that is referring to the first dropdown linked to the first dim table. Summary A-One fat table B-One dim (to dropdown cascade) inside de powerapps form (done exactly as per your instructions. Success) C-Second dim (to dropdown cascade based on a dropdown created on result "B") I'm not getting. I believe it is some Parent configuration. But I have no idea. Could you help me if I send you a Video explaining it?
Awesome tutorial but for some reason the cascading fields don't clear upon clicking the New button. Tried a few reset-type formulas, to no avail - thanks!
for existed item I want to edit, so I need the already selected item and whenever I select above dropdown then 2nd dropdown should be empty and show the cascading items
Hi Alireza :) My cascaded dropdown does not save data to the sharepoint list. The rest everything comes in my to sharepoint but not data from cascaded dropdowns. In app i can see data in the cascading dropdowns but it does not send it to the sharpoint list. 1 dropdown menu is called: Produkttype and formula is: Distinct('Data Source til Bestillingsliste', Produkttype) 2 dropdown is called: Produkt and it filters: Filter('Data Source til Bestillingsliste', Produkttype = Dropdown1.Selected.Result) could you please hlep? or anyone else? best regards Naji
@@AlirezaAliabadi ya dear master, I have few excel file in onedrive business and trying to sync data when edit excel and another excel auto update data in background(mean don't need to open excel file to load data) by power automate. But it fails.
Omg..do you know that you are awesome..you just finished my requirement in a 10mins..thanks❤
OMG. You saved my life. I was struggling with the problem to make the form accept card change. I needed exactly what you explain. Thank you so much. Brazilllllll
You legend. This was just what I needed. I've been looking for weeks. Love your Udemy lessons too.
Really liked your approach of explaining things. You made it look so simple for new learners like me... thanks a lot 😀👍
What a brilliant and clear instructional video!! Thanks
Thank you sir, You are a life saver.
this is very helpful thanks for the brilliant idea I can use this as my reference on creating Cascading dropdown on my organization.
Thank you so much for the help! this has worked great. Is there a way you can do the same Cascading drop down, but allowing you to select more than one choice on the (dependent Dropdown), or the second drop down that depends on the first selection?
Thanks. Could you please prepare a quick video on Model Driven PowerApp as well for just a simple Country and State scenario? Or guide on any similar tutorial for it. I am interested in joining your course on Udemy as well if this topic is available there. Please help! Thank you so much!
So very useful!
Great tutorial - thank you! Question, while I see the dropdowns in the SPO form and it behaves as expected, I'm not seeing any dropdown items when I'm in the 'Edit in grid view'. Is this normal behavior or is something wrong on my end?
Hello sir, first of all i would like to thank you for this video which helped me create a form which has multiple CBs depending on others. THANK YOU. Right now i'm stuck at one thing where the combo box has duplicates and i'm not able to apply DISTINCT function since its already using FILTER function. /// Formula in ITEMS -> Filter('List-activities', MainActivity = cb_main_activities.Selected.MainActivity)
Add distinct before the filter and end it with second category like for me District was dependent on State and the syntax which worked is
Distinct(Filter(CascadingDropDownExample, StateName = dd_State.Selected.Result),District)
Great explanation
Thank you very much for posting this wisdom.
What if we want to create a cascade dropdowns with different lists which are connected with look up fields
Hello Ali, and many thanks for your videos, I tried this cascading dropdown menu for my sharepoint list and I need to let it open for multiple choice, but when I save it only save one Item, what can I do for that? thanks in advance for your help
does the excel have to have the cascading table before you import it into sharepoint or do you just need a list of the items?
Hello, thx for this very good video, i have only the problem that i can update the data from the dropboxes, but when i reopen the data record the dropdown has other values not the record data. it seems that the dropdown dont get the real data to the dropboxes. do you have a tip for me? Greetings from DE
Hi, it really helped, thanks for the video. Also would like to know how to bring these cascade dropdown into bulk edit window of Sharepoint? Any thoughts
I really doubt if it is even possible. If you find an answer for that, just let me know if it is possible.
Hi Alizera, i would like to add an extra column so i get 4 levels of cascading, is that even possible? Every filter of distinct i tried, i get error's.
Thanks. I have followed these instructions and achieved adding a cascading dropdown field. There is one problem, though. The data from the DDL is entered and stored and viewable in the regular SharePoint view. But when the Power Apps form is reopened to edit, the cascading dropdown field looks empty, even though the data has not been lost. Any advice is appreciated.
Perfect, very nice.
Hello Ali, Both the approaches are superb, but in prefer the first approach since it is very easy for the end user to use without any help. The problem where I am facing is that the second dropdown is showing the complete list of. Is there any restriction in the dropdown that not more then this count will be shown.
Ich hab im Powerapp gleich gemacht, in Powerapp funktioniert auch, es übernimmt aber die Auswahl Möglichkeit nicht in Sharepointlist
Hi teacher. I was able to follow your procedure and finish. Helped me a lot. But I am wanting to include a third dim table, and I am creating a new dropdown, and this dropdown will be filtered based on the result selection that is referring to the first dropdown linked to the first dim table.
Summary
A-One fat table
B-One dim (to dropdown cascade) inside de powerapps form (done exactly as per your instructions. Success)
C-Second dim (to dropdown cascade based on a dropdown created on result "B")
I'm not getting. I believe it is some Parent configuration. But I have no idea.
Could you help me if I send you a Video explaining it?
Awesome tutorial but for some reason the cascading fields don't clear upon clicking the New button. Tried a few reset-type formulas, to no avail - thanks!
Great lecture, It's awesome and I'd like to a crash course on Power Apps with you
for existed item I want to edit, so I need the already selected item and whenever I select above dropdown then 2nd dropdown should be empty and show the cascading items
Love it!
Very well done. Thank you!
Hello Alireza, How to add hyperlink to Dropdown menu text in SharePoint with PowerApps
what would be different if it were a Library instead of a list ?
Would you be able to do something similar with a choice combo box?
This one sounds like a good one. Let me try and get back to you 🙂
Hi Alireza :)
My cascaded dropdown does not save data to the sharepoint list. The rest everything comes in my to sharepoint but not data from cascaded dropdowns. In app i can see data in the cascading dropdowns but it does not send it to the sharpoint list.
1 dropdown menu is called: Produkttype and formula is:
Distinct('Data Source til Bestillingsliste', Produkttype)
2 dropdown is called: Produkt and it filters:
Filter('Data Source til Bestillingsliste', Produkttype = Dropdown1.Selected.Result)
could you please hlep?
or anyone else?
best regards
Naji
have same erorr
how to have 3 dropdowns instead of 2. how do you both distinkt AND filter ?
Dear master, possible to sync data from excel to another excel by power automate?
Yes it is. For which part do you need help?
@@AlirezaAliabadi ya dear master, I have few excel file in onedrive business and trying to sync data when edit excel and another excel auto update data in background(mean don't need to open excel file to load data) by power automate. But it fails.