Forum Discussion
Showing json data in column more user friendly
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
column in sharepoint
Basically the end result in sharepoint will look something like this.
much appreciated thanks
- 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.
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-customizer
Hope it will helpful to youmeyer1981I 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.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
