Forum Discussion
Formatting Table Data in Microsoft Forms
Hi Nicky Nickyl sorry for the delay in getting back to you. Firstly I assume you are using a table similar to the questions outlined in red in the screenshot below:
We always store our forms responses to a SharePoint list, and this can be done as part of the same flow that creates the table in the email and sends out the email.
The trigger is the Forms When a new response is submitted, immediately followed by the first action Get response details. Next we create the item in the SharePoint list with one column for each question in the form including one column for each of the table questions (Experience and Workmanship in this example):
In the following step we need to use the Get items and set the filter query to bring back just the item we created so that we can then create an HTML table from it:
An expression is added inside a Compose control to format the table. Then we send the email using the output of the compose as the body of the email.
Much of this won't be familiar to you I suspect, so don't hesitate to come back with any further questions.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
Can you please help me create something like this? I need more detailed step by step process, if that's okay.
Thank you,
Emilia
- ashika789Aug 03, 2020Microsoft
emiliadcruze were you able to come up with a solution for this? I'm running into the same problem and really struggling to find an answer!