First, Thanks for this video! The only bad thing about this method is it doesn't account for if someone does NOT attach a file. For me, if a file isn't attached to the form, automate produces an error and does not send an email to recipients. I have to admit, in 2024 this has to be the most unnecessarily annoying and complex way to simply send an email and attachment to a form submission. This process should be drag and drop, or bare minimum a list of dropdown exceptions. As users, we should not be coding and scripting these functions. Microsoft needs to do better.
Hello everyone, I believe I have figured out the issue. 1) In the append to array variable, you should not have quotations around the "Contents Byte" object { "Name": "item()?[‘name’]", "ContentBytes": [File Content] #comment: brackets added for clarity. This is a sharepoint object } 2) To fix the "File couldn't be accessed issue" I've found that it is best to not try to get the content using the link path. Instead, replace "item()?['link']" with item()?['name'] and concatenate it with the path to the SharePoint folder. EG: Site Address: 'My Example Share Point Site' File Path: '/Shared Documents/Apps/Microsoft Forms/Example Form/Path_To_Files/item()?['name']' The file path being the folder which contains the files which were submitted by the form. This will be different based on the user. Hope this helps.
Thank you, this corrected the issue of me not being able to accurately see the file content. Now I just need to figure out how to attach other Attachment fields. I have 3 separate areas that ask for an attachment based on yes/no choice. Example: Do you have and approval document? "Yes" >> Attach Approval, Do you have a visitor request form? "Yes" >> Attach Visitor Form. Anyone have a suggestion on how to do this?
@@robbeckwith7120 you’re welcome. I really wish the author of this video would take it down and reupload because his process fundamentally does not work.
I created a sample of this and the attachments will not open even though the flow passed. When I receive the email first with a PDF file and then a Word document I am unable to open them. The PDF gives me a warning that the file is corrupted, and the Word file will not open either. Any ideas on how to fix this?
Thanks for the great video. The file attachments are coming over to Outlook; however, I'm not able to open the files (.jpg, word.docx, excel.xlsx, pdf). When I try to open the files, it says, "We found unreadable content" or says, "The file cannot open because the file format or file extension is not valid. Verify the file has not been corrupted and that the file extension matches the format of the file." How can I overcome this? Any help would be greatly appreciated.
I don't have the "issue files" option when inputting the expression for "apply to each". Also, my form has several questions that require attachments (both photos and videos), are there additional steps I need to add to the flow in order for all of the attachments to write to SharePoint and be attached to an email?
Great video, thanks for sharing. I have made a tweak to my flow which add it’s to the details to a sharepoint excel sheet. My only issue I face is is if someone submits a response with no attachments it fails, any ideas?
Problem!! Requesting for the solution !! Lot of people facing this issue including me (see the below comments). The file attachments are coming over to Outlook; however, I'm not able to open the files (.jpg, word.docx, excel.xlsx, pdf). When I try to open the files, it says, "We found unreadable content" or says, "The file cannot open because the file format or file extension is not valid. Verify the file has not been corrupted and that the file extension matches the format of the file." How can I overcome this?
I am creating a form and a flow for my managers, can I exclude myself from receiving the submission emails? Hopefully I am wording this question correctly. Thank you
Thank you! This flow works perfectly fine when a form is submitted with attachments. But it fails when no attachments are included. Any suggestions, please?
This was really helpful, but an attachment is optional in my form; therefore, the flow fails when there is no attachment. How will I still get an email if there is no attachment?
Everything worked great except the attached document which was a pdf is blank. Also when the pdf was uploaded it added my name to the end of the file name. Once I get the email and open the file I get an error in Adobe that says There was an error reading the a stream. I tried opening from local outlook and web and both places it was blank. I also checked the location of the document and all the information is there. Any idea?
Hey Beth - If you are using Microsoft Forms images should work just fine. As for File number limit, you will have to use the drop-down menu and ensure you have it set the way you want. Same goes for Single File Size Limit. All you need to do is click on the question in Microsoft forms and a selection menu will appear. Hope this helps!
Hi there, I am trying to use this same consept for a approval. (I know in the "Append to arry variable" the content does not have "bites" at the end.) When I test the flow, it errors out at the approval. Says "'CdsApiAttachmentSizeLimitExceeded'. Error Message: 'Attachment file size limit exceeded." Do you know where i go to change the file size limit? Thanks for this video! Super helpful
First, Thanks for this video! The only bad thing about this method is it doesn't account for if someone does NOT attach a file. For me, if a file isn't attached to the form, automate produces an error and does not send an email to recipients. I have to admit, in 2024 this has to be the most unnecessarily annoying and complex way to simply send an email and attachment to a form submission. This process should be drag and drop, or bare minimum a list of dropdown exceptions. As users, we should not be coding and scripting these functions. Microsoft needs to do better.
Absolutely. It’s annoying that it’s not easier to attach files.
Hello everyone, I believe I have figured out the issue.
1) In the append to array variable, you should not have quotations around the "Contents Byte" object
{
"Name": "item()?[‘name’]",
"ContentBytes": [File Content] #comment: brackets added for clarity. This is a sharepoint object
}
2) To fix the "File couldn't be accessed issue" I've found that it is best to not try to get the content using the link path. Instead, replace "item()?['link']" with item()?['name'] and concatenate it with the path to the SharePoint folder. EG:
Site Address: 'My Example Share Point Site'
File Path: '/Shared Documents/Apps/Microsoft Forms/Example Form/Path_To_Files/item()?['name']'
The file path being the folder which contains the files which were submitted by the form. This will be different based on the user.
Hope this helps.
THANK YOU! 🤩
Thank you, this corrected the issue of me not being able to accurately see the file content. Now I just need to figure out how to attach other Attachment fields. I have 3 separate areas that ask for an attachment based on yes/no choice.
Example: Do you have and approval document? "Yes" >> Attach Approval, Do you have a visitor request form? "Yes" >> Attach Visitor Form.
Anyone have a suggestion on how to do this?
Magic! your suggestions here in points (1) and (2) solved the corrupted file content issue I had. Can upload and read pdf, Word and Excel all ok.
@@robbeckwith7120 you’re welcome. I really wish the author of this video would take it down and reupload because his process fundamentally does not work.
God bless you! I wish I could give this comment 1,000 thumbs up.
This seriously helped me out today, thank you!
I created a sample of this and the attachments will not open even though the flow passed. When I receive the email first with a PDF file and then a Word document I am unable to open them. The PDF gives me a warning that the file is corrupted, and the Word file will not open either. Any ideas on how to fix this?
I have same issue did you manage to solve it?
@@yveskhadra2729I'm having this same issue!! :( Has anyone solved it?
Me as well. Same issue
Hi, This is great and worked perfectly. Can I ask what we do if there was an attachment in the microsoft form as well?
Thanks for the great video. The file attachments are coming over to Outlook; however, I'm not able to open the files (.jpg, word.docx, excel.xlsx, pdf). When I try to open the files, it says, "We found unreadable content" or says, "The file cannot open because the file format or file extension is not valid. Verify the file has not been corrupted and that the file extension matches the format of the file." How can I overcome this? Any help would be greatly appreciated.
Yeah, I ran into the same issue, too.
ya me too... looking forward for his reply. Appreaciated
Hey Shawn Barnes, i ran same issue bro, can you help me to fix it? thank you
Any resolution?
hi any resolution to this, i got the same issue
Thanks Bro, you helped me out
I don't have the "issue files" option when inputting the expression for "apply to each". Also, my form has several questions that require attachments (both photos and videos), are there additional steps I need to add to the flow in order for all of the attachments to write to SharePoint and be attached to an email?
He named his upload file question as “issue files”. In your case, it would be different.
Providing that this is being done with images, is there a way to embed them instead of attach them?
Hello there, is there any option to do the same but with 2 attachment fields?
I have 2 sepparated attachment fields (field 1 and 2)
Thank you!
Thanks for the video. Do you know how many max email that power automate can send per day?
Great video, thanks for sharing. I have made a tweak to my flow which add it’s to the details to a sharepoint excel sheet. My only issue I face is is if someone submits a response with no attachments it fails, any ideas?
Hey,
I am getting an not found error in get file content using path
Same here. I don't believe this works the way it was described a year ago.
Problem!!
Requesting for the solution !!
Lot of people facing this issue including me (see the below comments). The file attachments are coming over to Outlook; however, I'm not able to open the files (.jpg, word.docx, excel.xlsx, pdf). When I try to open the files, it says, "We found unreadable content" or says, "The file cannot open because the file format or file extension is not valid. Verify the file has not been corrupted and that the file extension matches the format of the file." How can I overcome this?
I am creating a form and a flow for my managers, can I exclude myself from receiving the submission emails? Hopefully I am wording this question correctly. Thank you
use conditions
Hi thank you for the video, it is really helpful, however, I am not able to open the attachment in email.
What about using OneDrive for Business (which is where MS Forms stores file attachments by default).
Thank you! This flow works perfectly fine when a form is submitted with attachments. But it fails when no attachments are included. Any suggestions, please?
You can create two separated flows, one for the responses and an action for those, and another one for the attachments
How to I allow the null value?
Hi, why I can't open my attachments from mail? when I do all automations
What if the attachment is not opening? even if is correctly attached?
This was really helpful, but an attachment is optional in my form; therefore, the flow fails when there is no attachment. How will I still get an email if there is no attachment?
how u have taken issue files option
@@salonibichkar5237 I'm not sure I understand. Could you provide more detail?
Create a condition that checks for null value in the submission field. then create second email that doesn't include attachment.
Everything worked great except the attached document which was a pdf is blank. Also when the pdf was uploaded it added my name to the end of the file name. Once I get the email and open the file I get an error in Adobe that says There was an error reading the a stream. I tried opening from local outlook and web and both places it was blank. I also checked the location of the document and all the information is there. Any idea?
Same problem here!! :( Any idea why files will attach but not open from the email?
Facing 404 error for get file content with path. I copy the path from raw output into browser, the file is exist. Anyone help? Thanks
I am having trouble with format - I am trying to upload pictures instead of files. Also, how do we add multiple images?
Hey Beth - If you are using Microsoft Forms images should work just fine. As for File number limit, you will have to use the drop-down menu and ensure you have it set the way you want. Same goes for Single File Size Limit. All you need to do is click on the question in Microsoft forms and a selection menu will appear. Hope this helps!
how can i take issue file option
@@thesixsigmaengineer
I followed along to this, and when I go to my email to open the file, it says the file format is not supported. Any suggestions? Thanks
It's showing me time out error, how to deal with that?
How do you find your site address?
I can't figure out how to do this but with one drive.
I followed all of the steps and the emails are ending but the image attachments are now blank.
It worked, but the attachment is reflecting an error that we don't support the file format. Can you please help on this.
did you manage to solve it
??
Facing the error " Failed to load PDF document ". Please help here someone
This does not work. The attachments do not open correctly
Hi there, I am trying to use this same consept for a approval. (I know in the "Append to arry variable" the content does not have "bites" at the end.) When I test the flow, it errors out at the approval. Says "'CdsApiAttachmentSizeLimitExceeded'. Error Message: 'Attachment file size limit exceeded." Do you know where i go to change the file size limit? Thanks for this video! Super helpful