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.
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.
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?
