Forum Discussion
Formatting Table Data in Microsoft Forms
Hi, RobElliott
The form itself does not use a table. It would be more of a case of someone pasting in a table into question 2 in your example.
It might look something like this:
I'm guessing that nothing can be done to change the format of this response so that it outputs neatly in an email form. We have an outside company that send us queries. When those queries are sent (currently using a Google Form), they appear in our inbox as an email. Sometimes, this customer needs to send us information in a table format - they don't use the Google Form to send tables because of the messy email output but this means we cannot capture table queries with all of the other non-table queries that arrive.
Regards, Nicky
Hi there
As Nickyl has already seen, there's presently no way to format tables in Microsoft Forms responses and so it would end up being unformatted plain text.
Unfortunately, I do not believe there is an easy workaround to the issue short of manual manipulation to fix the data and then a workflow to send the email, which would defeat the purpose of automation.
Rob's detailed example is for taking a forms response and formatting it into a HTML table for use when sending emails which is handy when you need to have a more organised layout in your emails to read the data.
Cheers
Damien
Damien_Rosario I use HTML tables to separate answers from questions, which works well. However, I encounter an issue when the text is lengthy. It displays as a continuous block of text in an email, making it difficult to read. How can I automatically insert new lines after a dot '.' or a dot and a space '. ' or any other separator to improve readability?
Hi mpawelko
You could try and word-wrap the output.
Give this resource a go and see if it resolves your issue?
How to Wrap text in Html - javatpoint
Best wishes
Damien
