Forum Discussion

SarahCool's avatar
SarahCool
Copper Contributor
Oct 23, 2023

format column json href link to list with 2 filters

I'm trying to format a column in a library so it's a link to a list with a filter based on the ID of the library and a fixed filter from a choice field.

 

This is what I try for the href property: 

"href": "https://nseuropebe.sharepoint.com/Lists/Approval%20history%20PO/AllItems.aspx?FilterField1=Category&FilterValue1=Company%20policy&FilterType1=Choice&FilterField2=DocID&FilterValue2=' + [$ID]"
 
It looks like this when I press the link: 
 

DocID should be a number.

 

 

When I use only one filter it works:
"href": "='https://nseuropebe.sharepoint.com/Lists/Approval%20history%20PO/AllItems.aspx?FilterField1=DocID&FilterValue1=' + [$ID]"
 
developer
Document Library
Lists
SharePoint Online

2 Replies

  • luis-ribeiro's avatar
    luis-ribeiro
    Brass Contributor
    Oct 23, 2023

    Hi SarahCool 

     

    I believe you are missing a "='" in the first expression and as consequence it is evaluated as string and not evaluate as a formula/expression to concatenate the values.

    Regards

     

Resources