Announcements
Hi Community
I can't figure out the Syntax if I want to exclude the value HR from 'Zuständige Abteilung' when filtering.
Hi @bob_taylor_pp
Here is a modified version of your code:
Filter( 'Mitarbeiter Onboard Tasks', Aufgabenbesitzer.Email = "johndoe@tesla.com" && (Aufgabenstatus.Value = "Offen" || Aufgabenstatus.Value = "In Bearbeitung" || Aufgabenstatus.Value = "Wartestellung") && Not("HR" in 'Zuständige Abteilung') )
If you have any questions or feedback, please let me know. Have a great day! 😊-----------------------PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]
I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻
hi @bob_taylor_pp ,
try this
Filter( 'Mitarbeiter Onboard Tasks', MitarbeiterOnboardTasks.Aufgabenbesitzer.Email = "johndoe@tesla.com" && Or( MitarbeiterOnboardTasks.Aufgabenstatus.Value = "Offen", MitarbeiterOnboardTasks.Aufgabenstatus.Value = "In Bearbeitung", MitarbeiterOnboardTasks.Aufgabenstatus.Value = "Wartestellung" ) && IsBlank(Search(MitarbeiterOnboardTasks.'Zuständige Abteilung', "HR", SearchMode. insensitive)) )
Not working. Datasource is Sharepoint Column of type look up. Could there be a problem with the region regarding syntax?
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 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 528
WarrenBelz 426 Most Valuable Professional
Valantis 306
