MS Forms with attachments , send email with

(1) Share

Report

Posted on by MistrYpsilon

Hello guys,

I need to build simple flow:

When somebody filled in MS Forms with/without attachments (images) it automatically sent Email with/without attachaments

I did it by myself without attachments, and for attachments I found Rez Dorrani video on youtube (275) How to save Microsoft Forms Responses & Attachments to SharePoint Lists or Libraries & Send Email - YouTube

and more a less I copy / paste "attachments" section from video time 29:48

- I setup everything same and finally I checked comments and there is same issue NotFound so I changed section: Get file content using path to comments :

You are spot on. It does not work for certain file types. Here is the fix.
Use "get file content by path" SharePoint action. And for the path use the following expression: concat('YoursiteURL/Shared%20Documents/Apps/Microsoft%20Forms/Training%20Survey/Question/',item()?['name'])
YoursiteURL - Your SharePoint Site URL
Training%20Survey - Form Name

but still I have same issue File not found, but when I checked Log , File Path is correct and if I put it to web-browser, image is open, so I do not understand, where is issue ?

Categories:

Building flows

I have the same question (0)

All responses (17)

Answers (1)

Sort by

abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @MistrYpsilon

I did tested this and do the following steps. I can see why you getting 404 error.

In Reza's video 32.03 it is using filePath item()?['link']

Steps:

Add a compose before the Get File content using path and use the expression
item()?['link']

Run the flow and check the flow history.

When I checked my run history it showed the below link

https://xxxxxx-my.sharepoint.com/personal/xxxx_xxx_xxxx_com/Documents/Apps/Microsoft%20Forms/Sports%20Survey%202022/Question/test.pdf

You may notice that it is slightly different that your Standard SharePoint Connect Site Address.

So under the 'Get File content using Path' > Site Address > click enter custom value and set the below address which is before the /Documents from the above URL

https://xxxxxx-my.sharepoint.com/personal/xxxx_xxx_xxxx_com

Next set File Path as expression item()?['link']

Once it set the site address correctly (personal site address) its all working correctly.

Hope it helps.

Thanks

Was this reply helpful? Yes No
v-dezhili-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @MistrYpsilon ,

You just want to get MSform attachments and send them via email?
I have another way to get MSform attachments for your reference.

Best Regards,
Dezhi

Was this reply helpful? Yes No
MistrYpsilon 49 on at

Like (1)

Report
Copy link

Link copied!

Hello @abm ,
thanks but its not works for me, I still have same issue

when I putted "Compose" action before Apply to each and Inputs: item()?['link'] (expression) save it ,run it , failed, when I open for edit again, this Inputs disappear and "Inputs" is empty (item()?['link'] (expression) missing )

I am not doing it under my personal, but under environment and shared space

Next set File Path as expression item()?['link'] I have it same I guess

Was this reply helpful? Yes No
v-dezhili-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @MistrYpsilon ,

Have you tried looking for these files in OneDrive?

Best Regards,
Dezhi

Was this reply helpful? Yes No
MistrYpsilon 49 on at

Like (0)

Report
Copy link

Link copied!

thanks for you input and time @v-dezhili-msft

but I have problem with "Get file content"

This operation violates admin data policy 'Global Standard Environment Policy', which restricts the use of business connector 'shared_microsoftforms' with non-business connector 'shared_onedriveforbusiness'.

Was this reply helpful? Yes No
MistrYpsilon 49 on at

Like (0)

Report
Copy link

Link copied!

@v-dezhili-msft
Yes I checked space: myURL/Shared%20Documents/Apps/Microsoft%20Forms/mySITE/Question/
and all files are correct uploaded

Was this reply helpful? Yes No
abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @MistrYpsilon

Could you please post a screenshot?

Mappings are :

@{body('Parse_JSON')} if you using the attachments via Parse JSON step

or

@{outputs('Get_response_details')?['body/r42736f8eb47c4d788b984cf528884b70']}

Above change the value 'r42736f8eb47c4d788b984cf528884b70' accordingly. This is the reference from MS Forms question response

@{items('Apply_to_each')['link']}

You are not mapping correctly hence you getting the error.

Thanks

Thanks

Was this reply helpful? Yes No
MistrYpsilon 49 on at

Like (0)

Report
Copy link

Link copied!

@abm
screen here

Was this reply helpful? Yes No
abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

That compose should be inside the apply to each and follow my earlier instructions.

Thanks

Was this reply helpful? Yes No
MistrYpsilon 49 on at

Like (0)

Report
Copy link

Link copied!

@abm
I put it inside to Apply to each, but still issue

Was this reply helpful? Yes No