Jul 22 2022 08:42 AM
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
Jul 22 2022 09:01 AM
Jul 25 2022 06:26 AM
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
Jul 25 2022 07:47 AM - edited Jul 25 2022 07:54 AM
@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.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)