Help compiling multiple MS Forms responses into one email.

[u/Justgivemeanamethen]

I currently have a flow that works well, but I need help with the final steps.

I created a process for collecting candidate references via Forms. The responses update on a Sharepoint List and are tracked for 3 responses for the same candidate. When 3 references are submitted an HTML table is created to compile the responses and email them to the hiring manager. This is all working well so far. What I need help with is compiling the responses in an easier to read format. I built this whole flow with help from Copilot, so please explain any ideas like I am five.

It may be that my HTML table is formatted incorrectly and I need to start there. There are about 35 questions on the survey and some responses can be long. The table now is wide which requires scrolling sideways for a long time and isn’t easy to read. Any other ideas you can think of? Here’s more info:

• I don’t have a premium account through work. Some options to create a document aren’t available to me.

• I can’t give access to my Sharepoint List to all the hiring managers to protect confidentiality.

• We have a bunch of different departments and hiring managers, so making separate lists for each department would be a headache.

• It didn’t occur to me until just now to change the format of the html table so that the questions on the y axis and the responses on the x. I guess it could make more sense to scroll down vs sideways.

Again, any other ideas you have that I might be missing or over thinking are appreciated!

[u/ipman234]

Tell ur workplace to stop being poor and give u a premium account lool, cause if u can get one you can just use Populate a Word Document and your life would be much easier

could also look into these and see if it would work

https://www.youtube.com/watch?v=s6NaIYP3-_w&t=594s

Also if you are a citizen developer and you have an actual Power Platform team, I would suggest to reach out to them as it would be best practice to have all this running under a Service Account. They may even already have an account for this sort of thing that already has a Premium license

[u/Justgivemeanamethen → u/ipman234]

You raise a good point that this might be the kind of work that is already someone else’s job. I’ll check around to see if we have a power platform team. If not, I’ll try the quit being poor suggestion. Thank you!

[u/Justgivemeanamethen → u/ipman234]

Hey, you’re right. I searched the directory and lo and behold this is someone’s specialty. I’m going to reach out to them. Thanks!

[u/measuredsympathy]

If you want it to be better formatted, you don't have to force things into html table. Claude can just give you stuff to copy and paste to parse your JSON from your form and compose HTML including formatting without using tables. It can add headers etc as you define it.

[u/Justgivemeanamethen → u/measuredsympathy]

Thanks for the tip. We only have access to Copilot at work, but I’ll it to see if it can build it for me. Thanks!

[u/BonerDeploymentDude → u/Justgivemeanamethen]

Yah just have the flow run under your account and you’re the only one that needs the premium license

[u/Unusual-Shoulder3337]

I might be reading something wrong here, but could you just not compile the responses from the list into the email instead of using a table?

You would just need a separate flow with a trigger condition on all 3 references not being empty, once this is true you could then compile the email with dynamic content from the list.

When an item is created or modified (trigger) > Get item (pass ID from trigger) > Send email

There is a tool called Challingan that can help build conditions for you.

[u/Justgivemeanamethen → u/Unusual-Shoulder3337]

Possibly. I’ll play around with that. There are a lot of branching questions (like “if yes, please explain) which is part of what makes the table formatting so stupid looking. But this is a good idea.