Hi,
Is it possible to achieve the same formatting in a SharePoint list when using a Plumsail Public Form that has a DataTable included.
When submissions are received the Forms tab shows the data entries and the DataTable format is displayed as below.
Using PowerAutomate to also get the data into a SharePoint List works put the data is not formatted it is displayed as below.
On the desktop designer I understand that you can use the "Save To" SharePoint List Column name that adds formatting.
Can the same outcome be achieved when using the Plumsail Public Form as this doesn't have the "Save To" functionality.
Regards
Mark
Dear @mloveridge,
This is possible, but you'll need to customize the SharePoint form first, and use the Save To property of an identical Data Table control so it customizes the column for you. More on that here - Save Data Table, Ink Sketch, and Likert Scale to SharePoint — Public web forms
HI @Nikita_Kurguzov
Those were the guides I followed and can successfully replicate using the desktop designer in a SharePoint Site and List but the public form one has the data as previously shown. The SharePoint List that the PowerAutomate flow is writing to has the relevant columns set as multi lines of text.
If I understand you correctly I just need to point the desktop form designer to the same SharePoint List and columns so that they are customised as per document and then try the public form submission whereby the customisation will be effective.
Regards
Mark
Dear @mloveridge,
Yes, exactly - you need to customize the SharePoint form for the list, and add an identical Data Table control to the form, select Save To and specify the same column. The data in this column will still be saved in the same format, it will just become more readable from the List View.
Hi @Nikita_Kurguzov
Just literally tried the recommendation and it works as you suggested which is great thanks for the heads up, just hadn't realised that was the process. One further question, if for any reason any changes are made to the DataTable columns then the process will need to be repeated but I just observed the previously unformatted data entries did not show so is this likely to happen again?
It feels like you need to be absolutely certain with the data fields if you commit to this formatting?
Regards
Mark
Dear @mloveridge,
Pretty much yes, though you can always edit the data manually to adjust it to the new format.
