Apr 21 2022 06:47 AM - edited Apr 21 2022 09:36 AM
The Setup
I am using Column Formatting JSON to set one column (Active Projects) equal to another column (Count). As you can see below, the JSON is working to set the column to appear equal.
I am using this JSON to accomplish this:
The Problem
The problem is that this isn't populating the actual data value of the field. If I attempt to call this field with Power Automate, or a web part, or anything, all of the values in the Active Projects column are empty. See below:
Why is the Column Formatting not filling in the actual field?
EDIT: I should add, because it will be brought up, I think, that I can't just use a calculated value as the Count column that I'm mirroring is a Lookup (Count Related) column.
Apr 21 2022 10:58 AM
@ZachJayy I think you've misunderstood what JSON does here; it changes the way a column or a row is displayed, it doesn't change the actual data. If you want to change the data you might consider using a flow in Power Automate.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
Apr 21 2022 11:40 AM