Syntax Filter gallery / Exclude a certain value with Operator "Not equal"

(0) Share

Report

Posted on by bob_taylor_pp

203

Hi Community

I can't figure out the Syntax if I want to exclude the value HR from 'Zuständige Abteilung' when filtering.

Filter( 'Mitarbeiter Onboard Tasks';Aufgabenbesitzer.Email = "johndoe@tesla.com" && Aufgabenstatus.Value = "Offen" || Aufgabenstatus.Value = "In Bearbeitung" || Aufgabenstatus.Value = "Wartestellung" || !("HR" in 'Zuständige Abteilung'))

I am grateful for any help.

Greetings

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

SpongYe 5,715 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
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! 🍻

Was this reply helpful? Yes No
anandm08 1,936 Super User 2024 Season 2 on at

Like (0)

Report
Copy link

Link copied!
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)) )

Was this reply helpful? Yes No
bob_taylor_pp 203 on at

Like (0)

Report
Copy link

Link copied!

Not working. Datasource is Sharepoint Column of type look up. Could there be a problem with the region regarding syntax?

Was this reply helpful? Yes No
bob_taylor_pp 203 on at

Like (0)

Report
Copy link

Link copied!

Not working. Datasource is Sharepoint Column of type look up. Could there be a problem with the region regarding syntax?

Was this reply helpful? Yes No