Forum Discussion
automan25
Dec 17, 2022Copper Contributor
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)
- RobElliottSilver 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)