Forum Discussion
Getting info from MS Forms as email in addition to populating an excel.. How to
I have a sharepoint page with embedded form and its used to make referrals for a clinic. The info on the forms really needs to go 2 places ( at least) afterwards
- To populate an excel ( this bit is happening ok)
- That form info needs to come in a readable format ( so not excel) to the people doing the clinic
I'm not a techie but need to get some advice to sort this so hope someone can guide me
Thanks muchly in advance
Maybe you can tell us what kind of readable format you want, and I can see if there are any relevant solutions that can meet your requirements.
- DingkunXieMicrosoft
Maybe you can tell us what kind of readable format you want, and I can see if there are any relevant solutions that can meet your requirements.
- DeniseHDCopper ContributorThanks DingkunXie
What I would need is the information in an outline like the actual form so either each question with its answer or a pdf of the same.
Is that possible?
The excel is just not helpful
Ask any further questions for clarity
Regards
Denise- RobElliottSilver Contributor
DeniseHD the best way to do this is with a flow Power Automate which will send an email to the people running the clinic with the questions and the answers as each form is submitted. It doesn't have to be a complex flow, something like the following simple example:
Rob
Los Gallardos
Microsoft Power Automate Community Super User