Hy I hope someone can help me.
I have an SPO site where I have different columns and 3 of the are LookUp list (AT, AT:AT, and AT:UZEM) that gets it's data from another SPO list.
Main SPO List: EBKNMF
And it looks like this
The second one is EBKNMF_SEGED
In my applicaton I'd like to have 2 dropdown list one that is alredy working and list out all the AT-s from AT:AT colunm.
Name of the drp_box: Drp_szahely_at and the formula: Choices([@EBKNMF].'AT:AT'
In the second one I'd like to list out all the units (AT:UZEM) that are in the asett team (AT:AT) that the costumer choosed in the frist dropdown list.
I tried different approaches but the error always the same, that the resoult of the dropdown box is a value and the filterd are is a table and it can not be filterd by a value.
Distinct(Filter([@EBKNMF];'AT:UZEM'=Drp_szabhely_at.Selected.Value);'AT:UZEM')
I really hope somenoe can help me thanks in advace.
