Power Platform Community Forum Thread Details

Hi everyone,

I have a sharepoint list called "Anidado_Productos" with several records:

From which I display data in my App through 5 dropdown controls:

Segmento is the leading control. The user selects one Segmento and all of the other 4 fields should display options only related to it. Lest's say: If "Ades" is selected, then the Corredor dropdown control should show "Tasty", "Core","-". After that, the third dropdown Consumo should show "Familiar" & "personal" if "Tasty" was selected, or "Familiar" only if "Core" was selected. In the end, Marca should display only the options that correspond to the previous field and the same goes for Empaque when a given Marca is selected.

Now, the code used for Segmento is as follow:

Sort(Distinct(Anidado_Productos;segmento);Result)

Then, the code I used for Corredor is this one:

If(!IsBlank(DD_Segmento_4.Selected.Result);Distinct(Filter(Anidado_Productos;segmento=DD_Segmento_4.Selected.Result);Corredor);Sort(Distinct(Anidado_Productos;Corredor);Result))

After that, I'm not quite sure how to proceed with the Consumo, Marca and Empaque dropdowns. I tried repeating the previous formula and modify the fields they call but, for example, If I filter Corredor, then the complete set of Consumo options appear, ignoring whichever Segmento I choose.

Maybe the answer is simple but I'm quite stuck at this point.

Thank you in advance for your help.

Categories:

Building Power Apps