ClearCollect(
colGuia,
{ AGA: "CARDIO", Especialitat: "ANESTESIOLOGIA I REANIMACIÓ", ThirdLevel:"Item 1"},
{ AGA: "CARDIO", Especialitat: "DERMATOLOGIA" ,ThirdLevel:"Item 2"},
{ AGA: "CARDIO", Especialitat: "ENDOCRINOLOGIA I NUTRICIÓ" ,ThirdLevel:"Item 3"},
{ AGA: "CARDIO", Especialitat: "ENDOCRINOLOGIA I NUTRICIÓ",ThirdLevel:"Item 4" }, // duplicate on purpose
{ AGA: "CARDIO", Especialitat: "APARELL DIGESTIU" ,ThirdLevel:"Item 5"},
{ AGA: "NEURO", Especialitat: "DERMATOLOGIA" , ThirdLevel:"Item 6" },
{ AGA: "NEURO", Especialitat: "ENDOCRINOLOGIA I NUTRICIÓ", ThirdLevel:"Item 7" },
{ AGA: "NEURO", Especialitat: "ANESTESIOLOGIA I REANIMACIÓ", ThirdLevel:"Item 8" },
{ AGA: "TRAUMA", Especialitat: "CIRURGIA ORTOPÈDICA I TRAUMATOLOGIA", ThirdLevel:"Item 9" },
{ AGA: "TRAUMA", Especialitat: "MEDICINA FÍSICA I REHABILITACIÓ", ThirdLevel:"Item 10" },
{ AGA: "TRAUMA", Especialitat: "APARELL DIGESTIU", ThirdLevel:"Item 11" }
);
Level 1 Combo Box (CB_1)
Item Property : Distinct(colGuia,AGA)
Level 2 Combo Box (CB_2)
| Items Property |
With(
{
src: Filter(
colGuia,
AGA = CB_1.Selected.Value
)
},
Sort(
Distinct(
src,
Especialitat
),
Value,
SortOrder.Ascending
)
)
|
| Button Visible Property |
If(IsBlank(CB_2.Selected.Value),false,true)
|
| Button OnSelect Property |
|
Level 3 Combo Box (CB_3)
| Items Property |
With(
{
src: Filter(
colGuia,
Especialitat = CB_2.Selected.Value
)
},
Sort(
Distinct(
src,
ThirdLevel
),
Value,
SortOrder.Ascending
)
)
|
| Button Visible Property |
If(IsBlank(CB_3.Selected.Value),false,true)
|
| Button OnSelect Property |
|
✅ Please click Accept as solution if my post helped you solve your issue and help others who will face the similar issue in future.
❤️ Please consider giving it a Like, If the approach was useful in other ways.
🏷️ Please tag me @MS.Ragavendar if you still have any queries related to the solution or issue persists.
