Forum Discussion
Solved
SharePoint list JSON link with multiple values column
Hi all, I have created a JSON format in SPO list which am I using to filter some values in another SPO list. Everything works fine, but the Test column is multiple value column. So when there is ...
Michal_Pral How to do you want to pass the filter value when [$Test] column has multiple values?
If you want comma separated values, you can do so like:
join([$Test], ',')Documentation: JSON Formatting syntax reference
Please click Mark as Best Response & Like 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.
Michal_Pral How to do you want to pass the filter value when [$Test] column has multiple values?
If you want comma separated values, you can do so like:
join([$Test], ',')
Documentation: JSON Formatting syntax reference
Please click Mark as Best Response & Like 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.
Hi ganeshsanap ,
The [$Test] column is a addional field of lookup column with allow multiple values. Well thanks a lot that is exctly what I was looking for, but it has one mistake.
When I use it like this
join([$Test], ',')
The values are not separated with comma but with semicolon. Whatever I paste beetwen the 'apostrophes' it does not work and the values are always separated with ; semicolon (I have tried even with %3B%23). Is thare any other syntax? It is not the first time that I have to use different syntax then Microsoft is saying for my location which is czech republic. For example when creating formula for Calculated column Microsoft is says use: =IF([Column1]=15, "OK", "Not OK") but for my it only works with semicolon =IF([Column1]=15; "OK"; "Not OK")
Michal_Pral Can you show us the updated/current JSON you are using with join() operator?
I am not sure about regional/language settings in your case. But, it works with comma/semicolon or any other separator for me.
Please click Mark as Best Response & Like 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.
Hi ganeshsanap ,
Here is the full JSON, I have tried:
join([$TEST], '%3B%23')
join([$TEST], ',')join([$TEST], '')
join([$TEST], ', ')
join([$TEST], '+')
result is always ; semicolon{ "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "button", "style": { "border": "solid", "background-color": "#E5F6FC", "border-color": "#81CEEA", "border-width": "1px", "cursor": "normal" }, "children": [ { "elmType": "a", "style": { "padding-right": "8px" }, "attributes": { "class": "ms-fontColor-themePrimary ms-fontColor-themeDarker--hover", "href": "='https://mycompany.sharepoint.com/sites/mysite/Lists/mylist/AllItems.aspx?FilterField1=Prvek%5Fx003a%5Fzkz%5Fonly&FilterValue1=' + [$Customer] + '&FilterType1=Lookup&FilterFields2=Prvek%5Fx003a%5FNadpis%5Fx0020%5F%5Fx0028%5F&FilterValues2=' + [$Title] + '%3B%23' + join([$TEST], '%3B%23') + '&FilterTypes2=Lookup&viewid=47564490%2D235c%2D4e79%2Da403%2D2086a4dc2e3d'", "target": "_blank" }, "txtContent": " TEST v PD" } ] }
