Forum Discussion
Cannot get values from Column JSON formatting fields not in view
I have a view that displays only 5 of the fields from a SharePoint record.
I am unable to access values from other fields that are not currently selected in the view in my JSON formatting logic.
If I include the field in the view, and hide the column, the JSON formatting cannot access it either.
Is there a way to get those values from JSON formatting logic?
I want to have access to all field values for json formatting (tooltip, etc) without having to show the columns in the list view.
3 Replies
What you want to do isn't possible with JSON formatting. The columns have to be visible in the view to be available for the formatting.
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, Microsoft Power Platform, WSP Global (and classic 1967 Morris Traveller driver)You can get the value by directly referencing the hidden column in the SharePoint list JSON formatting, e.g. $internalColumnName.
Calling [$internalColumName] while that column is "hidden" does not display the value.
