Hi @apca ,
Assuming "Projekt" is a single Choice field, consider applying the below to the Items property of your dropdown:
With(
{
_data: Distinct(
Filter(
'Your data',
'Projekt abgeschlossen'
),
Projekt.Value
)
},
Filter(
Choices([@'Your data'].Projekt),
!(Value in _data)
)
)
------------------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.
If you like my response, please give it a Thumbs Up.
Imran-Ami Khan
