Unanswered

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

(0) Share

Report

Posted on by 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.

Categories:

General topics

I have the same question (0)

All responses (15)

Answers (1)

v-mengmli-msft on at

Like (0)

Report

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

Was this reply helpful? Yes No
GlenAnderson 26 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
v-mengmli-msft on at

Like (0)

Report

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

Was this reply helpful? Yes No
GlenAnderson 26 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
v-mengmli-msft on at

Like (0)

Report
Hi @GlenAnderson ,

If you can't select body/value, please try expression:
triggerOutputs()?['body/value']

Best regards,
Rimmon

Was this reply helpful? Yes No
v-mengmli-msft on at

Like (0)

Report

Hi @GlenAnderson ,

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

Best regards,
Rimmon

Was this reply helpful? Yes No
GlenAnderson 26 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
v-mengmli-msft on at

Like (0)

Report

Hi @GlenAnderson ,

Could you please show me some screenshots?

Was this reply helpful? Yes No
GlenAnderson 26 on at

Like (0)

Report

Was this reply helpful? Yes No
v-mengmli-msft on at

Like (0)

Report

Hi @GlenAnderson ,

I have just modified my reply for your reference.

Best regards,
Rimmon

Was this reply helpful? Yes No