Don't generate Card in SharePoint Online List Gallery View (JSON)

Question

I have got a SharePoint list that i would like to display in a SharePoint Site.

Different Users should only see the elements that are meant for them. This is determined by the columns Zielgruppen (targit group) which is a Multiple lines of text field, and Zielpersonen (targit persons) which is a Person field.

If the User @me is not in Zielpersonen or the users Department (That's another question, how do I get the department of the User? Azure?) is not in Zielgruppen the Card should not be generated.

I've tried to change the display value to none but the card is still generated and takes up the space

"style": {
      "display": "=if ([$Zielgruppen] == '<<Users Department>>', 'flex', 'none')"
},

Answer 1

You can get department of people field using JSON formatting as well. Assuming internal name of your column is "Zielpersonen", you can get department like:

[$Zielpersonen.department]

So, try using this:

"style": {
    "display": "=if([$Zielgruppen] == [$Zielpersonen.department] || [$Zielpersonen.email] == @me, 'flex', 'none')"
},

You can get the correct internal name of your column by following this article: How to find the Internal name of columns in SharePoint Online?

Documentation: JSON formatting-syntax-reference