Announcements
He shows me an error in Displayname, he cannot work there ?
Filter(Projekte; Branche = dd_Branche.SelectedText.Value).Mitarbeiter.DisplayName
Hi @Anonymous ,Try using below formula -
First(Filter(Projekte; Branche = dd_Branche.SelectedText.Value)).Mitarbeiter.DisplayName
i mean thsis code here:
Filter(Berater; Mitarbeiter.DisplayName in Filter(Projekte; Branche = dd_Branche.SelectedText.Value).Mitarbeiter.DisplayName)
pleae help 😞
Hi @Anonymous,Is allow multiple choices option enabled for "Mitarbeiter" column in "Projekte" list?
where i can find out ?
it is from sharepoint
Filter(Berater; Mitarbeiter.DisplayName in Concat(Filter(Projekte; Branche = dd_Branche.SelectedText.Value); Mitarbeiter.DisplayName; ","))
it worked, coudl you explain me what this code do inn detail ?
Hi @Anonymous ,"In" operator was not working with table (more than one record). When we use filter we get result in the form of a table. SO here I used concat which will result a string separated by "," with which we can use "in" operator.
so the return of the Concat function is just a basic string with all the entry of the dataset?
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 326 Most Valuable Professional
11manish 168
sannavajjala87 75 Super User 2026 Season 1
