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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Collecting Responses a...
Power Automate
Answered

Collecting Responses and file through MS Forms and then emailing Response and file

(0) ShareShare
ReportReport
Posted on by 26

Hi All,


I am trying to automate a process for work, and i seem to be able to get individual flows/tasks to work, but am running into issues when trying to get it to work as a cohesive flow.

 

We have a form that people fill out, and one of the questions allows (but doesn't require) the responder to upload an excel file. When someone fills out the form, I want to email their responses and the file they upload (if they upload).

 

Here is what I have tried so far:

1. Generate an HTML file of the form responses, convert to PDF and email the PDF. I have this working just fine, but I can't seem to figure out how to get and attach the file that is shared through the form.

 

2. I have converted the Form response to a sharepoint list. I have been able to generate an HTML table from the list and email it, but I get the entire list instead of just the information specific to the new response.I have also been able to get the uploaded file as an attachment to the list item, but I have not been able to figure out how to get the attachment from the list to attach to the email.

 

Any help or guidance is appreciated.

Categories:
I have the same question (0)
  • v-mengmli-msft Profile Picture
    Microsoft Employee on at

    Hi @GlenAnderson ,

     

    To get the information in a new response, you need to use "When a new response is submitted" as the trigger and "get response details".

    vmengmlimsft_1-1702603639432.png

    How to get attachments to the SP list and attach it as attachments to the email?

    You can create an array and put file content in it, there is a nice video for your reference:

    Power Automate - How to retrieve SharePoint list attachments and send email? (youtube.com)

     

     

    Best regards,

    Rimmon

  • GlenAnderson Profile Picture
    26 on at

    Hi Rimmon, I am able to get the flow to work if I pull all items from the list, but I really just want to pull in the new item. When I use the get item function (see screenshot) I get the error "The 'from' property value in the 'select' action inputs is a type of 'Integer'. The value must be an array.

     

    GlenAnderson_0-1702618588440.png

     

  • v-mengmli-msft Profile Picture
    Microsoft Employee on at

    Hi @GlenAnderson ,

     

    The Value in Select action must be an array, "ID" returns a number.

    Please replace it with "Value".

    vmengmlimsft_0-1702618965730.png

    In addition, you can get data of Item from outputs of trigger, so there is no need to add "Get Item".

     

    Best regards,

    Rimmon

     

  • GlenAnderson Profile Picture
    26 on at

    Hi Rimmon, My flow doesn't have the body/value dynamic input. If I change the dynamic input to "Body" i get the error that it is an object and not an array.

  • v-mengmli-msft Profile Picture
    Microsoft Employee on at

    Hi @GlenAnderson ,

     

    If you can't select body/value, please try expression:

    triggerOutputs()?['body/value']

     

    Best regards,

    Rimmon

  • v-mengmli-msft Profile Picture
    Microsoft Employee on at

    Hi @GlenAnderson ,

     

    There is another way to convert outputs of trigger to an array:

    vmengmlimsft_0-1702625258261.png

     

     

    Best regards,

    Rimmon

     

  • GlenAnderson Profile Picture
    26 on at

    HI Rimmon I am using "When an item is created", but now I am getting the error: 

     

    The 'from' property value in the 'select' action inputs is of type 'Null'. The value must be an array.

  • v-mengmli-msft Profile Picture
    Microsoft Employee on at

    Hi @GlenAnderson ,

     

    Could you please show me some screenshots?

     

  • GlenAnderson Profile Picture
    26 on at

    GlenAnderson_0-1702624084357.png

     

     

    GlenAnderson_1-1702624124282.png

    GlenAnderson_2-1702624178557.png

     

     

  • v-mengmli-msft Profile Picture
    Microsoft Employee on at

    Hi @GlenAnderson ,

     

    I have just modified my reply for your reference.

     

    Best regards,

    Rimmon

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 791

#2
Valantis Profile Picture

Valantis 568

#3
Haque Profile Picture

Haque 535

Last 30 days Overall leaderboard