Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Unanswered

Flow only extracting portions of MS Form

(0) ShareShare
ReportReport
Posted on by 2

Hi,

 

I have a very simple flow where "whenever a form submission is made", "Get the response" then "create items on Sharepoint list". There are multiple fields where the data are extracted successfully but a number of them are empty. Upon looking into it further I can see that these fields are missing right at the "Get response" stage. It seems that the Flow is not able to read these fields properly. However nothing is different for these form questions, as all are text based.

 

Has anyone come across something similar and have a solution please? Thank you. 

  • creativeopinion Profile Picture
    10,383 Super User 2025 Season 1 on at
    Re: Flow only extracting portions of MS Form

    @Franky1 Can you share screenshots of your flow. When you say that the fields are missing right at the "Get Response" stage. Are you referring to the output from the Get Response Details action? If the fields appear empty in this action, then it would be assumed that those fields are optional and were not filled in. 

     

    If those fields are filled in and the flow isn't pulling in that information, can you switch to the Classic Designer (if you are using the new designer) and try to run a test again? The New Designer is still buggy especially when using it with the MS Form trigger and actions.

     

    In the meantime, you may be interested in these MS Form tutorials:

     

    How to Get Microsoft Form File Uploads Attached to an Email 📧

     

    In this Microsoft Power Automate Tutorial I’m going to cover where file uploads from your Microsoft Forms are saved. I’ll also show you how attach the uploaded files to an email and how to dynamically name the files and customize the recipient of the email based on the selections made in your Microsoft Form. I will also cover how to handle responses that don’t include any file uploads.

     

    IN THIS VIDEO:

    ‌ Two types of MS Forms

    ‌ Where Microsoft Personal (OneDrive) Form File Uploads are Saved

    ‌ Where Microsoft Group Form File Uploads are Saved

    ‌ How to Add a File Upload Question to an MS Form

    ‌ How to get a Microsoft Form ID

    ‌ How to get a Microsoft Form Response

    ‌ How to Get the Dynamic Content Microsoft Form File Upload Content

    ‌ How to handle Single and Multiple Microsoft Form File Uploads

    ‌ How to use a Scope action to Organize and Group Your Flow Actions

    ‌ How to Get the File Content from an MS Form File Upload

    ‌ How to Collect All Files Uploaded to a MS Form and Attach to an Email

    ‌ How to Handle MS Form Response When a File Isn’t Uploaded

    ‌ How to Create an Email Key

    ‌ How to Send an Email to a Specific Recipient Based on Form Selection

    ‌ How to Create a Dynamic Output Based on Form Selection

     

    -----

    How to Add Microsoft Form File Uploads to a SharePoint List Item

     

    In this Microsoft Power Automate Tutorial I’m going to cover how to add file uploads to a SharePoint list item. First, I’ll show you how to get the file name and content from the File Uploads from your Microsoft Form, then I’ll show you how to add those files to a SharePoint item.

     

    IN THIS VIDEO:

     Two types of MS Forms

     Where Microsoft Personal (OneDrive) Form File Uploads are Saved

     Where Microsoft Group Form File Uploads are Saved

     How to Add a File Upload Question to an MS Form

     How to get a Microsoft Form ID

     How to get a Microsoft Form Response

     How to Get the Dynamic Content Microsoft Form File Upload Content

     How to handle Single and Multiple Microsoft Form File Uploads

     How to use a Scope action to Organize and Group Your Flow Actions

     How to Get the File Content from an MS Form File Upload

     How to Collect All Files from Multiple File Upload Questions

     How to Handle MS Form Response When a File Isn’t Uploaded

     How to Attach an MS Form Single File Upload to a SharePoint List Item

     How to Attach Multiple MS Form File Uploads to a SharePoint List Item

     How to Attach MS Form File Uploads to an Email

     

    -----

     

    How to Get a Microsoft Form RSVP Response into a SharePoint List

     

    IN THIS VIDEO:

     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!

    👉 Level up your Power Automate skills by checking out my tutorials on YouTube
    👉 Tips and Tricks on TikTok and Instagram

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,524 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,906 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow