cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Cascading Dropdowns based on Lookup columns in a SharePoint Form

Hallo,

 

Need some help. I am creating powerapps from my sharepoint data and want to create cascading dropdown list in powerapps based on my lookup columns in sharepoint.

My sharepoint data is

 

list 1(floors): one column with floor list

 

list 2(Equipment): Column1: Equipment list

                            : Column2: Lookup column to Floors in list one

 

list 3(Readings): Column 1: Lookup column to Equipment from list 2

                           Column 2 : Lookup column to Floors from list 1

                           Column 3 : Readings

 

i am creationg powerapps from list 3

 

i powerapps i took two dropdowns , ddfloors and ddequipments

 

ddfloors: Items: Floors

ddequipment: Items: Filter(Equipment, Floors = ddfloors.Selected.Value)

 

so now , ddequipment is showing me error (green underline in ddfloors)

my question is, how we solve error and get cascading dropdown list in powerapps?

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Cascading Dropdowns based on Lookup columns in a SharePoint Form

Are you sure there is an error? The green underline you are referring to usually identifies a control in the formula and the corresponding control on the screen will be highlighted with that color. If there was an error you would normally see a red squiggly line and it you hover over it you get an error message.



--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
4 REPLIES 4
Super User
Super User

Re: Cascading Dropdowns based on Lookup columns in a SharePoint Form

Are you sure there is an error? The green underline you are referring to usually identifies a control in the formula and the corresponding control on the screen will be highlighted with that color. If there was an error you would normally see a red squiggly line and it you hover over it you get an error message.



--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
Anonymous
Not applicable

Re: Cascading Dropdowns based on Lookup columns in a SharePoint Form

yes, you are right. green underline was not an error. Cascading finally worked. thank you.

but for improvement, I am doing same cascading with 2 List. 

List1: it has all data without lookup columns

List2: to store new data

 

I follow all the steps with same filters, so far it is not showing any error. But it is taking so much time and still it is processing.

 

Do you think it will work? does it take too long for data filteration or is it some kind of error?

Shibu
Level: Powered On

Re: Cascading Dropdowns based on Lookup columns in a SharePoint Form

Try the below filter

 

Filter(Equipment, Floors.value = ddfloors.Selected.Value).Equipment

eslon
Level: Power Up

Re: Cascading Dropdowns based on Lookup columns in a SharePoint Form

can you tell me how you did that? I am trying to, but no success

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

SecondImage

PowerApps Monthly Community Call

Next Wednesday, September 18th at 8am PDT

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Users Online
Currently online: 4 members 2,704 guests
Recent signins:
Please welcome our newest community members: