Forum Discussion

Copper Contributor

Dec 17, 2022

Solved

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...

SharePoint Online

RobElliott
Dec 17, 2022
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 https://github.com/pnp/List-Formatting/tree/master/view-samples. 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

Silver Contributor

Dec 17, 2022

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 https://github.com/pnp/List-Formatting/tree/master/view-samples. 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)