Showing json data in column more user friendly

Copper Contributor

Using plumsail to enter some data and then update a sharepoint list item.

On the plumsail form im using a data table and copy the data to a column in sharepoint. Is there a way to format the sharepoint column to show the data more user friendly? below is an example from plumsail and entry in sharepoint.

 

Plumsail data table entry

meyer1981_0-1658504103108.png

 

column in sharepoint

meyer1981_1-1658504337423.png

Basically the end result in sharepoint will look something like this.

meyer1981_2-1658504463901.png

 

much appreciated thanks

 

 

3 Replies
I would recommend to split Orders and Order items as 2 different lists and set Order number as a lookup column. As you add more data, having 2 lists makes more sense and also easy to maintain.

@meyer1981 

 

 

If you have SPFX knowledge then you can user  SPFX Extension - Field Customizer for column rendering part where you can control rendering of the column value.

 

Reference Link: https://docs.microsoft.com/en-us/sharepoint/dev/spfx/extensions/get-started/building-simple-field-cu...


Hope it will helpful to you

@meyer1981I would recommed either experimenting with JSON (there are good examples and code at https://github.com/pnp/List-Formatting) or use Power Apps as I did below. It uses 4 lists from SharePoint.

 

dashboard.png

 

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)