Cascading Dropdowns in Power Apps from SharePoint list or Excel

Подписаться 130 тыс.

Просмотров 136 тыс.

50% 1

This video is a step-by-step tutorial on how to create Cascading Dropdowns in Power Apps from SharePoint list or Excel as a data source. We will utilize the PowerApps cascading dropdown inside a form control in Power Apps and apply cascading dropdown filter experience to a gallery control.
We will build the PowerApps dependent dropdown experience from scratch.
Video covers the following:
✅ How to create Cascading Dropdowns in PowerApps
✅ Cascading Dropdowns within a form control
✅ Cascading Dropdowns for filtering gallery data
Table of Contents:
00:00 - Intro
00:30 - Cascading dropdowns data source - SharePoint list and Excel
02:41 - Build cascading dropdown controls from Excel
05:28 - Build cascading dropdown controls from SharePoint list
07:20 - Add cascading dropdowns in a form control connected to SharePoint list
12:28 - Filter data using cascading dropdown controls
20:27 - Subscribe to Reza Dorrani's channel
#PowerApps #CascadingDropdowns #SharePoint

Опубликовано:

21 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 334

@likeminas 3 года назад

Keep dropping these gems brother!

@RezaDorrani 3 года назад

Thank you. I will keep trying my best.

@koyelsarkar675 2 года назад

I can't tell you how much thankful I am for your this post. Exactly, what I was looking for. Thanks a lot again.

@RezaDorrani 2 года назад

You are most welcome. Thanks for watching.

@cooldee11 2 года назад

Thank you Reza for the detailed video, this will help me transition from InfoPath to PowerApps smoothly. Well explained👏🏾👏🏾👏🏾👌🏿

@RezaDorrani 2 года назад

Glad it was helpful!

@kristinafronheiser6272 2 года назад

You saved my butt today! Thank you for making this video. Extremely helpful!!!

@RezaDorrani 2 года назад

Glad to know the video was helpful. Thanks for watching.

@shaiksamad1562 3 года назад

Reza .. You really making life simple by sharing your tips... You are my super hero..🦸‍♂️

@RezaDorrani 3 года назад

Thank you for your kind words.

@xclone2k 3 года назад

Great Video Reza, Thank you for sharing!

@RezaDorrani 3 года назад

Thanks for watching

@jessy.rozario 11 месяцев назад

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.

@RezaDorrani 11 месяцев назад

You’re most welcome

@jessy.rozario 11 месяцев назад

@@RezaDorrani Any idea of not saving cascade data to SharePoint ? all other fields are saving though.

@RezaDorrani 11 месяцев назад

@@jessy.rozario No idea as I have not come across the issue. I recommend checking or posting your query on forums powerusers.microsoft.com

@sundrapillay6668 3 года назад

Thanks Reza always interesting to watch and learn from your video's

@RezaDorrani 3 года назад

You are most welcome Sundra

@BigBocian 2 года назад

Thank you Reza. Exactly what I was looking for! :)

@RezaDorrani 2 года назад

You are most welcome!

@AI-Health-posts 3 года назад

Thanks Reza for this video. Clean and simple explanation.

@RezaDorrani 3 года назад

My pleasure!

@kaiyang8669 2 года назад

This is absolutely great content, thanks for sharing!!!

@RezaDorrani 2 года назад

Glad you enjoyed it!

@vickyrokryou 3 года назад

Very detailed explanation. Thank you Reza 👍

@RezaDorrani 3 года назад

Thank you for watching

@marialimadeoliveira7489 2 года назад

Perfect video. Thank you!

@RezaDorrani 2 года назад

You're most welcome!

@rajamahendrareddyvangala114 3 года назад

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.

@RezaDorrani 3 года назад

Great to hear that. Check out my forma tutorial - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-aVEaRpAlaTA.html

@jainraj75 3 года назад

Thank you very much ..really very nice and thanks for detailed explanation :)

@RezaDorrani 3 года назад

You are most welcome

@edwinjonah 3 года назад

This is so useful, thanks!

@RezaDorrani 3 года назад

Your most welcome

@vishnupriya2841 2 года назад

Got to know the way of handling of text and choices types of drop downs. Thanks a lot to highlight it

@RezaDorrani 2 года назад

My pleasure

@aravindswamy9952 3 года назад

TQ Reza....This video Helped me Well, Thanks For Detailed explanation :)

@RezaDorrani 3 года назад

Glad to hear that

@veraborzykina6291 2 года назад

Thank you so much! Really useful😊

@RezaDorrani 2 года назад

Glad it was helpful!

@vasileiosstamatis882 2 года назад

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

@RezaDorrani 2 года назад

I did a full series on Dataverse for Teams including live videos. Check ru-vid.com/group/PLTyFh-qDKAiFG_FxWr-ACSmP39_84IUWl

@akkaradechsrithongchai7766 2 года назад

Yesssss , Thank you RD

@RezaDorrani 2 года назад

👍

@from-heaven 2 года назад

Thank you so much, you helped a lot!

@RezaDorrani 2 года назад

Thanks for watching

@AmitKumarPune 3 года назад

Very nice scenario. Happy to see your videos. Kindly make some videos on Power Automate as well.

@RezaDorrani 3 года назад

Thank you. I do have around 28 videos on Power automate and more coming. Power Automate (flows) ru-vid.com/group/PLTyFh-qDKAiEs0rhQuR7fwSv5_63FHr_0

@marcosvillalon3098 Год назад

Muchas gracias brother!

@RezaDorrani Год назад

Thank You!

@shaikhrijwan9322 Год назад

You are super sir..... Your teaching techniques are so amazing 👌👌

@RezaDorrani Год назад

Thanks a ton

@wernermosimann7673 3 года назад

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?

@RezaDorrani 3 года назад

Yes possible. Beauty of data cards in a form control is they can be changed per your needs.

@lucaslegz 2 года назад

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…

@RezaDorrani 2 года назад

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.

@ikennaakupuome9595 3 года назад

Really nice and well explained

@RezaDorrani 3 года назад

Thank You

@danelemon5959 2 года назад

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?

@RezaDorrani 2 года назад

100% All of my videos are for community. Feel free to use them as you want.

@oluwatobiyusuf 2 года назад

Thank you Reza for this

@RezaDorrani 2 года назад

You are most welcome

@azharkhan-br4qm 3 года назад

Thank you very much for this video....

@RezaDorrani 3 года назад

You are most welcome

@liangfu2479 Год назад

Very useful,Excellent work!

@RezaDorrani Год назад

Thank You

@muru4541 3 года назад

It's really nice video I learned new today

@RezaDorrani 3 года назад

So glad to hear that and thanks for watching

@jimmysnaps4600 Год назад

Those who have issue while writing on second dropdown Filter('TicketCategoryType, Department= drpDept.Selected.Results).'Request type' try writing "Value" instead of "Results"

@RezaDorrani Год назад

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

@jasonpettigrew107 2 года назад

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...?

@RezaDorrani 2 года назад

You could use the Patch function to do that. Switch(dropdown.selected.value, “marketing”, patch to marketing list, “it”, patch to it list)

@jamescole3925 2 года назад

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?

@RezaDorrani 2 года назад

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

@curtshea4360 Год назад

Did you find a solution for this?

@yangbo151 3 года назад

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.

@RezaDorrani 3 года назад

Yes, users would need read access.

@khaldoonalbeik2852 10 месяцев назад

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?

@RezaDorrani 10 месяцев назад

Formula would be different but it can work. I did another video on cascading as well where I may have shown that.

@arvindeleon4527 3 года назад

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!

@RezaDorrani 3 года назад

Yes, it will work. You can populate the data using Distinct function as shown in the video.

@riturajsingh169 2 года назад

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 2 года назад

Your request will be my video in 2 weeks time :)

@ghyootceg Год назад

@@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 ! ;-)

@RezaDorrani Год назад

@@ghyootceg Default values - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-bjvigaL68ts.html Combo Box - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-zPM0Q53L3sE.html

@jaineshprajapati5704 2 года назад

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

@RezaDorrani 2 года назад

I believe approach will be similar to the one showcased in the video. I have not give cascading a try though with Dataverse

@sueamin2788 Год назад

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 Год назад

You could by using filter function on items property of dropdown. Seems a very specific use case though. I have no references on this.

@marieraymond6512 Год назад

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.

@RezaDorrani Год назад

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.

@marieraymond6512 Год назад

i got it to 3 levels! It is alot.This is the military and they have alot of levels to their staff.

@TheElayris 3 года назад

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?

@RezaDorrani 3 года назад

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 - ru-vid.com/group/PLTyFh-qDKAiE7C_2lVNAPzgHXsBykG0Tf

@valeriecowen4618 2 года назад

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?

@RezaDorrani 2 года назад

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

@valeriecowen4618 2 года назад

@@RezaDorrani Thank you!

@inesreis7490 Год назад

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?

@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

@senapolat9927 10 месяцев назад

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?

@RezaDorrani 10 месяцев назад

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

@tesselma 3 года назад

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!

@RezaDorrani 3 года назад

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

@kupid9 2 года назад

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

@rajvirkaur8695 3 года назад

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?

@RezaDorrani 3 года назад

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

@edgardoruiz2157 Год назад

Here is your like and your subscribe good man, this video helped a lot, thanks

@RezaDorrani Год назад

Thanks for the sub!

@arupdutta8880 Год назад

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??

@RezaDorrani Год назад

I did not understand your question. I recommend posting your query with screenshots on the forums at powerusers.microsoft.com

@DroneEyes 3 года назад

One great video after another ... could you please upload this Power App file somewhere so it can be shared?

@RezaDorrani 3 года назад

Here you go - github.com/rdorrani/PowerApps/blob/master/HelpDesk-CascadingDropdowns_20210218143903.zip

@DroneEyes 3 года назад

@@RezaDorrani Thank you very much!

@marcosifuentes2985 Год назад

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

@RezaDorrani Год назад

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.

@kimyrodriguez1 5 месяцев назад

Great

@RezaDorrani 5 месяцев назад

Thanks

@pratikdarak8863 3 года назад

Hi Reza, Could you please help me with Multiselect cascade dropdown option. Thanks in advance

@RezaDorrani 3 года назад

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/

@kamranmasroor6395 3 года назад

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.

@RezaDorrani 3 года назад

I have added this request to my backlog

@NarnawareSunil 3 года назад

@@RezaDorrani yes.. i too have this question.. what if both are choice columns.. instead of one being the single line of text..

@RezaDorrani 3 года назад

@@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/

@1Pt21Jigawatts 3 года назад

@@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.

@jennifergonzalez5356 Год назад

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?

@RezaDorrani Год назад

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

@riteshshukla4351 3 года назад

Hi!! Very useful and great tips provided, Can you share another video with some different examples?

@RezaDorrani 3 года назад

Can you give examples of the different examples 😀

@riteshshukla4351 3 года назад

@@RezaDorrani Sure!! :)

@BambangSetiawansetia Год назад

Hi Reza,, thanks for your video. can you help me why the data i select using cascade is not filled in my list?

@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

@shaikzuber7945 3 года назад

Waiting

@RezaDorrani 3 года назад

Hope you enjoy the video

@ghazalsarbazi6863 3 года назад

that was great but what of one the lookup fields is people type how to fetch that?

@RezaDorrani 3 года назад

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/

@md.fazlulkarim 3 года назад

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.

@RezaDorrani 3 года назад

I believe its 500 which is the delegation limit. Alternate solution would be to use a gallery so user can select the value.

@md.fazlulkarim 3 года назад

@@RezaDorrani Tank you for confirming. I could not find any document that confirmed this. However I can take your reply as 'official document' ;)

@RezaDorrani 3 года назад

@@md.fazlulkarim :)

@sarahdavies3582 3 года назад

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 ?

@RezaDorrani 3 года назад

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.

@mog1888 2 года назад

Would this work in the grid view of the list? Thank you

@RezaDorrani 2 года назад

It would. Code would differ though based on grid design.

@klaudia8323 3 года назад

Is it possible with data from people column? I see you have card Assigned to, does it work like other dropdowns?

@RezaDorrani 3 года назад

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/

@melvinhines3194 4 месяца назад

Hi Reza, is there a video on how to do this using modern controls?

@RezaDorrani 4 месяца назад

@ABHEEE1 11 месяцев назад

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.

@RezaDorrani 11 месяцев назад

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.

@andrewchen3412 Год назад

Is there a video on how you got the browse gallery layout to look like that?

@RezaDorrani Год назад

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-bnC8u3gdWss.html

@sophiadcosta-braganza5954 2 года назад

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?

@RezaDorrani 2 года назад

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

@sophiadcosta-braganza5954 Год назад

@@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..

@RezaDorrani Год назад

@@sophiadcosta-braganza5954 Awesome 👏

@roald6212 7 месяцев назад

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

@RezaDorrani 7 месяцев назад

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.

@RyanGaroogian 2 года назад

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.

@RezaDorrani 2 года назад

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

@RyanGaroogian 2 года назад

@@RezaDorrani Thanks Reza I will request assistance through that community site.

@hermanodame3302 3 года назад

Hello, How about the people field, how do you select that and patch?

@RezaDorrani 3 года назад

Check ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-g9ChYuTdNd4.html

@sanchitagrawal8602 Месяц назад

Thanks for this video, how can I add "Yes" & "No" in the dropdown control without using any table/list or any dataset

@RezaDorrani Месяц назад

["Yes","No"]

@sanchitagrawal8602 Месяц назад

@@RezaDorrani thanks but again the question is where should I give these values? In OnSelect or somewhere else

@RezaDorrani Месяц назад

directly on items property since you want to hardcode

@Disaenz10 3 года назад

Reza hi, is this cascading dropdown only available with Power Apps? Could it be done with only a sharepoint list? Thanks!

@RezaDorrani 3 года назад

Cannot be done with just a modern SharePoint list.

@kalharijayasinghe8413 2 года назад

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

@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

@Shilpis_Kitchen 11 месяцев назад

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

@RezaDorrani 11 месяцев назад

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

@_Raj- Год назад

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.

@RezaDorrani Год назад

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

@_Raj- Год назад

@@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.

@RezaDorrani Год назад

@@_Raj- Please post the issue with screenshots on forums. Your use case is not something I have shown in a video.

@kevlarcardhouse252 Год назад

Hey. I've made an app that uses a dropdown by pulling data from a separate list. However, if someone tries to edit an entry, the 2 fields involved in a cascading dropdown refresh. Does anyone know if there is a way to make it so that if it's not a new entry, it keeps the details that were originally chosen?

@RezaDorrani Год назад

If it's an existing entry, then it should hold the previous values. For new entries, typically you would want the user to select. As for your issue, I will have to look at your App in action to provide guidance. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

@ashishkulkarni8193 3 года назад

Hi Reza, What would be formula for 3rd drop-down dependent on 2nd drop-down where the data source is excel file?

@RezaDorrani 3 года назад

Similar to formula for 2nd which is based on 1st.

@ashishkulkarni8193 3 года назад

@@RezaDorrani Thank You for your reply!! Can we use Distinct and Filter in same formula?

@RezaDorrani 3 года назад

@@ashishkulkarni8193 Yes. Note that distinct returns a collection with column Result. So make sure to apply filter function accordingly.

@jazzwings1 2 года назад

Hi, Reza hope You are ok, one question, I'm trying this same example, but when I get to the Department filter formula, it gives me a "incompatible types for comparison error". I already made sure the columns are the same as your example, but I cant find what is the problem. Any help is appreciated

@RezaDorrani 2 года назад

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

@karanashokkamble1407 3 месяца назад

Can you please create similar video for cascading dropdown using modern controls?

@RezaDorrani 3 месяца назад

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.

@Cartoonhotpot Год назад

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.

@RezaDorrani Год назад

I don’t think this scenario is for such a use case. I have not tried it so not sure.

@Cartoonhotpot Год назад

@@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?!

@RezaDorrani Год назад

@@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

@QQ_HH 3 года назад

Hi Zera, how.cam I add All item option to dropdown if current items are filter from list instead of a choices collection ? I can't make it

@RezaDorrani 3 года назад

The items you filter from list, put it in a collection and then add the All option

@damselindisguise5357 11 месяцев назад

Is there a way to build a cascading dropdown where the values inputed will be displayed onto the sharepoint list?

@RezaDorrani 11 месяцев назад

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.

@SamSung-xw9ns 3 года назад

While clicking the dropdown list it should display the selected text from the drop down .how could I do. pls help me out!!!

@RezaDorrani 3 года назад

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

@robertkersey8843 2 года назад

how do u get distinct values from the second filter?

@RezaDorrani 2 года назад

Can you share the time in the video where I show this?

@melonychavez4286 10 месяцев назад

Help Needed - SPO-Customized Form & Cascading Lists I have a customized form with a cascading list selection. A specific "Status" selection appears based on the selection of "Location". When creating the MS List, it contains a text column for both Location and Status. In developing the customized form (OOB) for SPO lists, I developed a separate list for the Location/Status dropdowns and then connected those data fields to populate the Location/Status to the primary list. When the form is in edit mode, everything works great. when saving the Location/Status does save properly in the primary SPO list; however, upon opening the form again, the Location stays constant but the "status" defaults automatically to the first selection option on the list no matter what. How do I fix this?

@RezaDorrani 10 месяцев назад

I have not come across this issue and hence not sure what is the cause for your issue. Helping here on chat without being able to reproduce the issue is challenging. It would be best to post your issue/query with screenshots on the forums at powerusers.microsoft.com

@arunkumargangadharan6644 2 года назад

Hai, i have a doubt. I had created a form using SP list which has a choice column. Now i want to create a binary value based on that choice field in another column. I used if condition but it's not working any suggestions plz

@RezaDorrani 2 года назад

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

@abbsyogos 11 месяцев назад

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

@RezaDorrani 11 месяцев назад

I did this video a long while ago and do not have the app anymore. The video is the best reference I have.

@dizzy2858 2 года назад

hi reza, what should I do when my dropdown does not show all the rows from my sharepoint list. currently, the sharepoint list has 2048 rows, but it is only showing till 2039th.

@RezaDorrani 2 года назад

Dropdown cannot load more than 2000 records (delegable limit). Better option would be to use combo box control where user can search for data. Check ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-zPM0Q53L3sE.html

@MadRockway 3 года назад

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.

@RezaDorrani 3 года назад

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/

@MadRockway 3 года назад

@@RezaDorrani, can you share any article related or base structure of the formula? It will be very helpful for me now.

@RezaDorrani 3 года назад

@@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.

@sawansoni6818 Год назад

choice dropdown depends on choice dropdown by using share point list in power app. please explain

@RezaDorrani Год назад

dropdown values are populated from choice column in SharePoint

@rafaelrosado4566 3 года назад

if I want the "choise" to be in alphabetical order (ascending) ?? where do i put the ascending? Thank you

@RezaDorrani 3 года назад

You can use the sort function along with the Choices function.

@rafaelrosado4566 3 года назад

@@RezaDorrani thanks, I will try!

@Sleepwell245 7 месяцев назад

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

@RezaDorrani 7 месяцев назад

Distinct is not a delegable function and there is no way around it as far as I know.

@GeoClips 3 года назад

Hello Reza im having a issue trying to apply this steps on my flow. when i change the type of my colum from Text to Dropbox get this error "body/value/0/PuntodeCambio"be type "Object", but is type "String"."

@GeoClips 3 года назад

well I exclude this colum from the view on sharepoint and flow works jeje

@RezaDorrani 3 года назад

Looks like you got it to work.

@jeffmcguire2072 3 года назад

Great! Can you show me how to import an excel table with dropdowns into Sharepoint online, so it retains the Choices formatting?

@RezaDorrani 3 года назад

Export table with dropdowns? I did not understand the question.

@jeffmcguire2072 3 года назад

@@RezaDorrani You know, multiple choice answers

@RezaDorrani 3 года назад

@@jeffmcguire2072 But what about retaining formatting? Not sure what that means.

@jeffmcguire2072 3 года назад

@@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.

@RezaDorrani 3 года назад

@@jeffmcguire2072 There are limitations. One of them is the multi choice column.

@izumi45 Год назад

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?

@RezaDorrani Год назад

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

@akcreative8956 2 года назад

how do i change a dropdown value based on selection of another dropdown? any help highly appreciated.

@RezaDorrani 2 года назад

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

@akcreative8956 2 года назад

@@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

@RezaDorrani 2 года назад

@@akcreative8956 I do not have a video tutorial on this use case. I would recommend you check on the forums at powerusers.microsoft.com

@kambhampatisreenivarao8757 Год назад

Hi Reza, While reselect parent drop-down value then how to reset second drop-down value.

@RezaDorrani Год назад

If parent dropdown is changed, then dependent drop down should change automatically

@kambhampatisreenivarao8757 Год назад

@@RezaDorrani I am getting new select dependent values in the second drop-down but I want "reset" the dependent value (I am using combobox)

@RezaDorrani Год назад

@@kambhampatisreenivarao8757 Not sure. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

@kambhampatisreenivarao8757 Год назад

@@RezaDorrani Thank you very much for replied

@87midhunraj Год назад

Hi Reza, Is it possible to get selected items from a dropdown list based on the current user ?

@RezaDorrani Год назад

Not sure I understand the question. What is correlation between selected items and current user?

@87midhunraj Год назад

@@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 ?

@RezaDorrani Год назад

@@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.

@87midhunraj Год назад

@@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...🤗