Jan 13 2021 12:40 AM
Hi everyone, I need help how to filter with lookup column which is on first list (Marketing Catalog) using JSON Script, and on second list (catalog order) using lookup column to join it.
And i want only status active is only show on second list (Catalog Order), can anyone help me?
I attach my picture for more detail
Thanks
Jan 13 2021 03:17 AM
Solution
You cannot filter list views using JSON formatting. You need to edit your list view and apply necessary filters based on lookup column.
Check this documentation: Use filtering to modify a SharePoint view
But for your case, In order to filter the 2nd list based on Status column, you should have the data (Active/Non Active) stored in column (Status), which is not possible using JSON formatting.
Workaround:
Please click Mark as Best Response if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
Jan 14 2021 11:26 PM
Hi, can you give me more detail with screenshoot because I've problem when add [TODAY] on StartDate
Thanks for your help
Jan 15 2021 01:34 AM
Add list view filters something like below:
If the post is useful, please consider giving it Like.
Jan 13 2021 03:17 AM
Solution
You cannot filter list views using JSON formatting. You need to edit your list view and apply necessary filters based on lookup column.
Check this documentation: Use filtering to modify a SharePoint view
But for your case, In order to filter the 2nd list based on Status column, you should have the data (Active/Non Active) stored in column (Status), which is not possible using JSON formatting.
Workaround:
Please click Mark as Best Response if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.