Forum Discussion

automan25's avatar
automan25
Copper Contributor
Dec 17, 2022

Referencing Column Properties with JSON

Using JSON (column formatting) Is there a way to reference the available items in another choice column by their index number in the array?; something like [$MyColumn].[2] Note, I'm not talking about the items selected for that particular record, but all of the items available for that particular column.

  • automan25 no, that's not possible as JSON column formatting can only get that item's data, not scan across all items. That can be done with view formatting and samples are here. But even with that I don't think you can do what you are asking. Happy to be proved wrong.

     

    Rob
    Los Gallardos
    Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

  • RobElliott's avatar
    RobElliott
    Silver Contributor

    automan25 no, that's not possible as JSON column formatting can only get that item's data, not scan across all items. That can be done with view formatting and samples are here. But even with that I don't think you can do what you are asking. Happy to be proved wrong.

     

    Rob
    Los Gallardos
    Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

Resources