JSON Filter Lookup on SharePoint

0
votes

I've problem with JSON script.

Which is I have 2 List on SharePoint : first list (marketing catalog) using JSON Script for status column and second list (catalog order) I've joined it with lookup column on second list (catalog order), but it show all status (active and non active), rather than i need only active is "show"

Thanks

for more detail I attached my screen shoot JSON Script to filter status

1
jsonsharepointfilter

1 Answers

0
votes

I am using Sharepoint on-premise 2019 (modern). Based on my information the possible way to achieve it is:

  1. You cannot "expand" your lookup column for Choice field (I assume that Status column in Marketing Catalog is Choice field).
  2. Add calculated column (for example StatusHidden) for Marketing catalog only to "copy" Status column as text field.
  3. In Catalog order list show additional field for Calculated column - StatusHidden
  4. In view for Catalog Order, filter items based on StatusHidden column equal to Active.