Forum Discussion

DeniseHD's avatar
DeniseHD
Copper Contributor
Jun 08, 2023

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

  1. To populate an excel ( this bit is happening ok) 
  2. 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 

 

 

microsoft forms
  • DingkunXie's avatar
    DingkunXie
    Jun 09, 2023

    DeniseHD 

     

    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.

  • DingkunXie's avatar
    DingkunXie
    Icon for Microsoft rankMicrosoft
    Jun 09, 2023

    DeniseHD 

     

    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.

    • DeniseHD's avatar
      DeniseHD
      Copper Contributor
      Jun 13, 2023
      Thanks 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
      • RobElliott's avatar
        RobElliott
        Silver Contributor
        Jun 13, 2023

        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

Resources