Forum Discussion
SP List Column Formatting Not Populating Field
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. ...
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)
- Thanks for this clarification Rob. So I've tried Power Automate as well to grab that lookup column value and set it into the other column. But I can't figure out how to get the lookup column value. It doesn't show up as dynamic content from a Get Item against the list.
