Answered

Gallery dependant dropdown not working

(0) Share

Report

Posted on by Kieran056

Hello, thanks for looking.

I am following this tutorial at the minute https://youtu.be/m1MFJssXpxo and i would like to add a few cascading dropdowns.

In a normal form i have gotten this to work fine however when using a gallery im guessing things work a little different.

Currently i have 2 SP lists;

1 is my main list where inputted data is patched to (Main Data)

the other holds all the data for my dropdowns (Cascading list)

Following the above guide the gallery is linked to a collection which is why I thought it wasn't working, so I have created a new collection and loaded Cascading list into it, now I can get the first box to work great, the 2nd and 3rd not so much, below is the code I'm using:

Drp1: Distinct(DDData, Title)

Drp2: Distinct(Filter(DDData, Title = Drp_Title.Selected.Value), Feeder)

Drp3: Distinct(Filter(DDData, Title = Drp_Title.Selected.Value, Feeder = Drp_Feeder.Selected.Value), FSP)

Now if i change them to .Result i get an error saying it is not recognised, but on the dropdown list you can see 2 options but not the text

Has anyone got any suggestions for me to solve this?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

WarrenBelz 156,275 Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @Kieran056 ,

Firstly, the output of Distinct() is now .Value, not .Result, so what you have is correct

Distinct( DDData, Title ) Distinct( Filter( DDData, Title = Drp_Title.Selected.Value ), Feeder ) Distinct( Filter( DDData, Title = Drp_Title.Selected.Value, Feeder = Drp_Feeder.Selected.Value ), FSP )

The output of the last one (I am assuming a control name here) would be

drp_FSP.Selected.Value

What is it that is not working ?

Was this reply helpful? Yes No
Kieran056 20 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz thank you for taking the time to respond!

I've attached a picture to show what is happening, i copied your code over just incase there was a slight difference to mine but it returned the same result. I've attached it to this post 🙂

Basically the SSP is showing the correct data options in the dropdown, then when one is selected and i go to the next one it gives 4 options to select, which is correct, but the names are not displayed and when i select one of them the 3rd Dropdown gives zero options to select which is incorrect - but im suspecting that's because there's no visible information selected in the second dropdown

Was this reply helpful? Yes No
Verified answer

WarrenBelz 156,275 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Kieran056 ,

Before we go any further, please test with a Classic Combo Box or Dropdown.

Was this reply helpful? Yes No
Kieran056 20 on at

Like
a
(0)

Report
Copy link

Link copied!

That must've been the issue, swapped them to classic DD and it worked perfectly first time! Thank you for your help with that... just so i know for the future, do you know what i did wrong? because i dont :')

Was this reply helpful? Yes No
WarrenBelz 156,275 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Kieran056 ,

It is not you. Modern controls are mostly still in Preview and currently have. a lot of things that do not work as expected.

Was this reply helpful? Yes No