You’re offline. This is a read only version of the page.
I GOT IT!!!!!!!!!!!! Tks Guys
Distinct(Filter(tab_rel; Text(LookUp(tab_sweet;name_sweet = DataCardValue1.Selected.Result ; id_sweet)) in Text(id_sweet_rel)); id_type_rel).Result
I have 2 combobox and I would like to list the second (ex: tab_rel) with filter of the first combobox (ex: tab_sweet), but I dont know to do this.
The command Filter and Source only accept text, I'm converting to text and it isnt working.
Distinct(Filter(tab_rel; LookUp(tab_sweet;name_sweet = DataCardValue1.Selected.Result ; id_sweet) in Text(id_sweet_rel)); id_type_rel).Result
Exemple:
tab_sweet (id_sweet, name_sweet)
1, icecream
2, cooks
tab_type (id_type, name_type)
1, limon
2, chocolate
tab_rel (id,rel, id_sweet_rel, id_type_rel)
1, 1, 1 -- icecream x limon
2, 1, 2 -- icecream x chocolate
Help-me please.
#1
WarrenBelz
69
Most Valuable Professional
#2
mmbr1606
51
Super User 2025 Season 1
#3
MS.Ragavendar
36
Share
Report
All responses (
Answers (