Skip to main content
Community site session details

Community site session details

Session Id : j5inkV0K/5DaNJJeKYKZt5
Power Automate - Building Flows
Unanswered

Send survey in email using MSForm

Like (0) ShareShare
ReportReport
Posted on 4 Jun 2021 19:58:13 by 6,048 Super User 2024 Season 1

I have a working flow. A modification in SharePoint list triggers it. It sends my student email after every session with details like Recording link of session, Topic Name, Topic Description. 

My requirement:

Send survey in that email. If it can be embedded then best, if not then link of the survey. Once student completes the survey. The answer given in the survey should be updated in the same SharePoint list.

Thank you in advance.

  • ScottShearer Profile Picture
    25,236 Most Valuable Professional on 07 Jun 2021 at 00:11:59
    Re: Send survey in email using MSForm

    @zmansuri 

    I think a bit more information is required to suggest a solution.  First, There needs to be a way to identify what list item is associated with a given survey response.  

    • Is there only one row of data with your students name in the SharePoint list?
    • Is the column in which the students name is stored a person or group column?
    • If there is more than one row of data with a students name in the SharePoint list, can you tell me what columns exist in the SharePoint list contain data that is also returned by the survey?  For example, the course name and students email?

    Once you can supply additional information, you'll create a Flow virtually identical to the one suggested by @vikulkar .  The difference will be that the query filter will be different and contain two parameters.

     

     

  • zmansuri Profile Picture
    6,048 Super User 2024 Season 1 on 06 Jun 2021 at 18:18:18
    Re: Send survey in email using MSForm

    Thank you for responding.

    'Get item' will get the whole list. I need that particular record that submitted the response. so i can append those survey response to the same SharePoint list. The list that triggers the flow in the first place

  • vikulkar Profile Picture
    on 06 Jun 2021 at 15:45:43
    Re: Send survey in email using MSForm

    Hi @zmansuri ,

     

    First, you can create a MS-Form with the necessary fields like topic, survey, rating etc.

    You can then include the MS-forms link in the email and once the students fill the details, then you can have a flow as shown below to update the same SP list.

     

    FlowFeedback.PNG

     

    In the above flow, we are using getItems along with filterQuery to filter based on Topic and then updating the correct item in SP List.

     

    Thanks and Regards,

      Vikas K

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

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Loading complete