web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Get name from MS Forms...
Power Automate
Unanswered

Get name from MS Forms response and send email with forms response to linked email address

(0) ShareShare
ReportReport
Posted on by

Hello. 

 

I would like to build an automation which

  1. Gets the name from MS forms response
  2. Makes an email (or PDF) from this MS forms response (so not the data from all response, just this specific one)
  3. Sends this email to an email address that is linked to the specific name form step 1

For clarification this is what I would like to achieve:

Shift 1 makes certain decisions that can influence the operation of shift 2. With this form the operator of shift 2 can evaluate the decisions shift 1 has made. Shift 2 fills out this form, which should only be sent to the operator of shift 1. So in the steps above step one gets the name of shift 1, gathers the data of shift 2's reponses and sends this data to the operator of shift 1. 

 

 

Categories:
I have the same question (0)
  • creativeopinion Profile Picture
    10,502 Super User 2025 Season 2 on at

    @MatthijsLVNL Take a look at this YT Tutorial: How to Get a Microsoft Form RSVP Response into a SharePoint List

     

    I cover the following in this video tutorial:

    How to get a Microsoft Form Response into SharePoint

    How to get a Microsoft Form ID

    How to get a Microsoft Form response

    How to Build a Microsoft Form with Conditional Fields

    How to used Branching in Microsoft Forms

    How to format Microsoft Form multiple choice responses for a SharePoint multi-choice column

    How to parse a Microsoft Form multiple choice response as string of text

    How to convert a text response to a number

    How to use the Switch action

    How to create a custom email confirmation for a Microsoft Form submission

    How to Create a Custom View in a SharePoint list

    How to use the Compose Action

    How to write Power Automate Expressions

     

    Hope this helps!

    If I helped you solve your problem—please mark my post as a solution .
    Consider giving me a 👍 if you liked my response! If you're feeling generous— ️  Buy me a coffee: https://www.buymeacoffee.com/acreativeopinion

    👉 Watch my tutorials on YouTube
    👉 Tips and Tricks on TikTok

  • Andrew_J Profile Picture
    1,962 Moderator on at

    @MatthijsLVNL,

     

    I think I understand what you what you want to do.

     

    I assume your users are internal and sign in with thay M365 account.  If this is the case then when thay fill out the form the form responce captures thair email address in the background.  So when looking at forms and responces remember to get the user account information from their profile.  There are pleant of videos that could help you with this, see one post below:

     

    https://powerusers.microsoft.com/t5/Building-Flows/Microsoft-Forms-Get-the-quot-Display-name-quot-fro-Office-365/td-p/136474

     

    I would keep your form as is, but write the data to a SP list so you have the data all in one place and can keep track of this for a managment point of view.  Once the Shift 1 fills out the form the SP list is written to with the data and that flow stops.  See above but subsitute the excel for a SP list.

     

    The next flow will start with when an item is created which will start the creation of the PDF file with all the information in it and send this to the Shift 2 person.  The flow ends.

     

    https://powerusers.microsoft.com/t5/Building-Flows/Generate-PDF-from-SharePoint-list-item/td-p/195965

     

    The above will genrate a lot of files in a persons onedrive so I would store the PDF file created in the SP list item then delete the file in ondrive.  The above will involve the premium plan to use the word template action.  I assume you can add this plan to the Shift Manangers plans.

     

    The only issue I have is the shift leaders name, what happens if they fall ill, or are on leave, or there is an issue with getting to site due to an acident on the roads.  Can the process work if this is the case.  Does a mananger need to be copied in or deputy to the emails to make sure everyone knows about the issues.  But that is whole different question altogether.

     

    All my responces are ment to point you in the right direction in my view and not meant to do the work for you.

     

    Regards,

     

    Andrew

     

     

     

     

     

     

     

     

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 519 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 296 Moderator

#3
abm abm Profile Picture

abm abm 232 Most Valuable Professional

Last 30 days Overall leaderboard