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

[GlenAnderson]

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.

[v-mengmli-msft]

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".

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]

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.

[v-mengmli-msft]

Hi @GlenAnderson ,

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

Please replace it with "Value".

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]

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]

Hi @GlenAnderson ,

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

triggerOutputs()?['body/value']

Best regards,

Rimmon

[v-mengmli-msft]

Hi @GlenAnderson ,

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

Best regards,

Rimmon

[GlenAnderson]

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]

Hi @GlenAnderson ,

Could you please show me some screenshots?

[GlenAnderson]

[v-mengmli-msft]

Hi @GlenAnderson ,

I have just modified my reply for your reference.

Best regards,

Rimmon

[GlenAnderson]

Hi Rimmon,

Not sure that I follow your updated table creation. When I follow your steps, I dont get anything pulled into the Value column.

[v-mengmli-msft]

Hi @GlenAnderson ,

[GlenAnderson]

It generates the column name, but doesn't populate it with anything:

[v-mengmli-msft · Accepted solution]

Where did you get the outputs?

Please check the expression:

Best regards,

Rimmon

[GlenAnderson]

Thank you! That worked!

Now to figure out why my excel files are getting corrupted when being uploaded to sharepoint.