Cascade Dropdown PowerApps Input Controls using SharePoint List Data

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

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

50% 1

This video will walk through the process of how to create cascade dropdown PowerApps input controls using SharePoint list data.
I will create two dropdown controls in PowerApps Form based on SharePoint list data. First Column will show the list of countries from the SharePoint list and second column will filter and only display the list of cities in the selected country.
Support me with your Amazon purchases, click here: amzn.to/3e6ZrSM
🔴 ** BE OUR FRIEND **
✅ Website: www.keapoint.com
✅ LinkedIn: h / 18782324
✅ Twitter: / kea_point
✅ Facebook: / keapointuk
🔎 HASHTAGS 🔎
#PowerApps
#CascadingDropdown
#SharePointList

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

22 фев 2021

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

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

Amazing information and video! Please keep it coming. Thank you!

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

Thank you! Will do!

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

Very clearly explained and demonstrated. Thank you. Also please make a video on different power app UI controls and how to use them on respective occasions.

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

Thanks. Sure I will

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

Really nice and useful👌👌

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

Thanks a lot 😊

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

Great videos! Quick and to the point. How do you create a form on power app where a set of fields are displayed based on an option button value?

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

You can use the field visible properties to hide/show fields.

@ozerius76 Год назад

simple and usefull......

@KeaPointTechTips Год назад

Thanks.

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

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

@ozerius76 Год назад

great work.

@KeaPointTechTips Год назад

Many many thanks

@josepablodecastroful Год назад

Great but, after that, how do you submit the result to another sharepoint list (mapping to the correct columns on the new list). To give context, I have a survey, I'm pulling up the cascading data from one list but want the responses to go to another list. Thank you in advance for all your help!

@KeaPointTechTips Год назад

Possible, you can make connections to multiple lists in powerapps.

@josepablodecastroful Год назад

@@KeaPointTechTips hi, thanks for replying back. Yes, I managed to create the connections, however, when I do the submit it does not copy the data from the cascading drop-down to the specified survey list.

@kasungayathra7209 Год назад

Hi. Need to connect office 365 user list and updated the seleted data in MS list. Do you have any idea regarding that?

@KeaPointTechTips Год назад

You can use PowerShell to export office 365 users data and then upload it to a SharePoint List.

@keyblade5916 Год назад

Can I do this in SharePoint too? Thanks

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

Can we do cascading with choice columns? If yes, please tell me how to do it.

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

Yes you can,. I will add this topic in my to do videos list.

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

How do I do if I want that the data that I select in a dropdown that came from another sharepoint list, that I want it enter the value selected in a label or text field to be able to save this value in another sharepoint list ?

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

Hi, This is possible but will need to practically implement it. I have no video which covers this scenario.

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

How do you patch the selected item to a sharepoint list? thanks!

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

This article will help you sharepains.com/2021/01/13/patch-field-type-sharepoint-power-apps/

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

Hi there, I made a cascading dropdown in power app using share point list and it is working fine. But I need to implement a search property also in cascading dropdown. Would you please help me

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

Check the answer to your question on this thread powerusers.microsoft.com/t5/Power-Apps-Ideas/Searchable-Drop-Down-control/idi-p/45475

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

@@KeaPointTechTips I used 'Allowed values' as control type. still there is no option for searching

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

Hi, just use ComboBox control instead of drop down and apply the same configuration.

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

How do I find somethin *like. So find all the countries that are like U, which would give United States, UK, Uganda then I can select the country I want

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

You can add search capability to the dropdown choice column in PowerApps. I will try and make a video this week.

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

Is there any way to pick up recent 2000 items from SharePoint to power app gallery. Because now it is taking 2000 items from begining

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

You can use a query something like this Lookup( YourListName, First( Sort( YourListName, ID, Descending ) ) )

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

Here I am using 'add columns ' property.(crewmembers is choice column)Because of delegation, search property is working only in first 2000 items. But I want the recent items.