cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jdvroum
Level: Powered On

Cascading dropdown with lookup field

Hello,

I would like to filter a dropdown with the value of one other dropdown.

This two dropdowns are created in SharePoint Online and are lookup columns. 

 

The first one it's called CHANNEL, second one: EMISSION and both are include in SCENE list.

 

On the second dropdown, I put this function in items :

Sort(Filter(Emissions; Chaines.Value = DataCardValue16.Selected.Value).Titre;Titre)

 

It's working fine for the filter but when I valide the form, the data is not record !

Do I forget something ?

Thanks for you help

3 REPLIES 3
KroonOfficeSol
Level 10

Re: Cascading dropdown with lookup field

@jdvroum

 

Maybe first try SortByColumns() instead off Sort(). 

 

Let us know if this solves the issue

 

Paul

Community Support Team
Community Support Team

Re: Cascading dropdown with lookup field

Hi @jdvroum,

 

Do you want to create cascading dropdown based on look up columns in SP list?

Is Emissions your look up columns’ list?

Are look up columns’ name in Emissions Chaines and Tire?

For look up coloumns, I think you should do some chages in your gallery screen and form screen.

You can try following workaround,I test as next:

 

Data Source:

20190212cascadingdropdown1(my SP list name)

CHANNEL(single line)

EMISSION(single line)

20190214datasource1.png

20190212cascadingdropdownlist2(my SP list name)

Chaines (look up from sp list1’s CHANNEL)

Tire (look up from sp list1’s EMISSION)

20190214datasource2.png

Then PowerApps->Create an app .(in 20190212cascadingdropdownlist2)

App Test:

In BrowseScreen1:

Add one button and rename it Button_Collection,and Button_Collection.OnSelect: ClearCollect(TEST1,'20190212cascadingdropdownlist2');ClearCollect(test2,AddColumns(TEST1,"C_Id",Chaines.Id,"C_Value",Chaines.Value,"T_Id",Titre.Id,"T_Value",Titre.Value))              

(you can change 20190212cascadingdropdownlist2 to your list name on your side)

20190214apptest1.jpg

In EditScreen1,

Unlock Chaines_DataCard2 and Titre_DataCard2 and then add two dropdown controls and rename them as Dropdown_C_Id and Dropdown_T_Id.

DataCardValue5.Items: test2.C_Value

Dropdown_C_Id.Items: Filter(test2,C_Value = DataCardValue5.Selected.C_Value).C_Id

Chaines_DataCard2.Updates: {'@odata.type' : "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",

        Value: DataCardValue5.Selected.C_Value,

      IdSmiley Very Happyropdown_C_Id.Selected.C_Id}

 

DataCardValue6.Items: Sort(Filter(test2,C_Value = DataCardValue5.Selected.C_Value).T_Value,T_Value)

Dropdown_T_Id.Items: Filter(test2,C_Value = DataCardValue5.Selected.C_Value).T_Id

Titre_DataCard2.Updates: {'@odata.type' : "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",

        Value: DataCardValue6.Selected.T_Value,

      IdSmiley Very Happyropdown_T_Id.Selected.T_Id}

20190214apptest2.jpg

Result Test:

20190214resultest1.jpg

20190214cascadinglookupdropdownresulttestgif.gif

20190214resulttest3.png

Hope this can be helpful.

Best Regards.

Yumia

 

jdvroum
Level: Powered On

Re: Cascading dropdown with lookup field

Hello,

Thank you for your answer. 

I'm not able to enter this function :

ClearCollect(TEST1,'20190212cascadingdropdownlist2');ClearCollect(test2,AddColumns(TEST1,"C_Id",Chaines.Id,"C_Value",Chaines.Value,"T_Id",Titre.Id,"T_Value",Titre.Value)) 

 

I have to add that my dropdown are configured to receive one or more choices. 

Julien

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

SecondImage

PowerApps Monthly Community Call

Next Wednesday, August 21st at 8am PDT

Top Community Contributors for July 2019

Top Community Contributors for July 2019

Let's thank our top community contributors

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

FifthImage

Dynamics 365 and Power Platform April 2019 Release notes

Features releasing from April 2019 through September 2019!

SixthImage

Power Summit Australia 2019

August 20-23rd 2019

Users Online
Currently online: 28 members 3,868 guests
Please welcome our newest community members: