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

 

Highlighted
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