Sharepoint Choice Field Multi-Select Options

Question

I'm trying to format a multi-select choice field with JSON. Is there a way to get all of the available choices? for instance, you can retrieve the lookup value of a lookup field with:

"txtContent":"@currentField.lookupValue"

but I have a choice field, so I am looking for something like:

"txtContent":"@currentField.choices"

Thanks.

Answer 1

Hi @Pat Colan ,

Per my research, you could use the following JSON codes.

{  
   "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",  
   "elmType": "div",  
   "txtContent": "@currentField"  
}  

From this article Use column formatting to customize SharePoint: Just like number, text, and date fields, choice column formatting is one that places the value of the field inside a <div /> element.

Update:

Per my test, i didn't find out how to get all choice field with JSON. I suggest you create a flow as a workaround.

My test flow:

My test result:

---

If an Answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Thanks @CaseyYang-MSFT , but I know I can extract the field value answers with your code, what I want is to pull all of the options available for the field.

For instance, if a choice field has 4 options, and the user selects 2 of them, I want to be able to show all 4.

User Answer:                         Available Options:  
                                              Choice 1  
Choice 2                                Choice 2  
                                              Choice 3  
Choice 4                                Choice 4  

I just don't know how to pull the available options of the field.

Answer 3

I appreciate all the effort! It seems like this should be easily accessible with JSON, but your workaround using flow does work. Thanks.