Convert form response to PDF AND send all uploads from the form as attachments in the same email

Like (0) Share

Report

Posted on 15 Mar 2024 12:42:06 by A_Wilc

Hi,

I have created a flow to turn a form submission into a PDF and attach it to an email - this worked fine by itself

I also need to to have all documents uploaded to the form to be attached to the email - I can also get this working fine by itself.

I can't work out how to get the PDF and the uploads all on to one email as attachments. Please can you help?

thanks

Anna

Categories:

Business Process Flows

I have the same question (0)

All responses (7)

Answers (0)

Andrew_J 1,962 Moderator on 15 Mar 2024 at 13:12:42

Like (0)

Report

Re: Convert form response to PDF AND send all uploads from the form as attachments in the same email

@A_Wilc

Hopefuly we can resolve this, you second paragraph reads:

I also need to to have all documents uploaded to the form to be attached to the email - I can also get this working fine by itself.

So the above is basically saying the PDF (one file) created by the completion of the form is uploaded to OneDrive or SharePoint. This works fine.

Now on to your thrid paragraph

I can't work out how to get the PDF and the uploads all on to one email as attachments.

So you want to attach ONLY the PDF file that was created by the submission of the form to an email and send to one or muliple recipents. This is what you need some help with.

Please let me know if that is your requirment so I can help you more.

Regards,

Andrew

Was this reply helpful? Yes No
A_Wilc on 15 Mar 2024 at 13:24:02

Like (0)

Report

Re: Convert form response to PDF AND send all uploads from the form as attachments in the same email

Hi Andrew,

Thank you for getting back to me.

I need the PDF and all attachments uploaded to the form to be attached to an email that goes to one recipient.

So when you have asked the following:
So you want to attach ONLY the PDF file that was created by the submission of the form to an email and send to one or muliple recipents. This is what you need some help with.

No, I want to attach the PDF file created by the form submission and any attachments that were uploaded as part of the form to a single email going to one person.

I hope that makes sense

Thanks
Anna

Was this reply helpful? Yes No
Andrew_J 1,962 Moderator on 15 Mar 2024 at 13:45:51

Like (0)

Report

Re: Convert form response to PDF AND send all uploads from the form as attachments in the same email

@A_Wilc

I understand now so the the form has a file upload section that then stores these in OneDrive of you or your other user. The form responce PDF file is also saved to the same location. I am assuming that all of this is being undertaken in one flow. I think your flow needs to stop there.

I think from your post you know how to get the multiple attachments. A seperate flow will be required to send them out. If you need help then the below might help:

https://www.youtube.com/watch?v=9G9GNeknemg

However I can see a problem, the second flow will start the second a file hits OneDrive so will send muliple emails. So do we stick with one flow and put a large delay in say five minutes between the uplaod of the files and PDF creation to allow the files to be written to OneDrive. Then maybe delete the files from OneDrive once they have been sent so the directory is clear for the next submission of the form. Again will the form be filled out in quick sucession or will there be minutes, hours or days between its use.

Anyway I hope that helps.

Regards,

Andrew

Was this reply helpful? Yes No
A_Wilc on 15 Mar 2024 at 14:05:24

Like (0)

Report

Re: Convert form response to PDF AND send all uploads from the form as attachments in the same email

THanks,

The flow itself it working fine, it's just getting both kinds of attachments on to the one email.

I think my problem is with this section of my 'Send an email V2' action. I can do it this way (see image below) and the email sends perfectly with the attachments from the file upload section of the form attached

Or i can do it this way:
And the email sends perfectly with the PDF attached by getting the dynamic content from the 'Convert File' action.

How can I do both, please?

Thanks so much, your help is really appreciated
Anna

Was this reply helpful? Yes No
Andrew_J 1,962 Moderator on 15 Mar 2024 at 14:36:17

Like (0)

Report

Re: Convert form response to PDF AND send all uploads from the form as attachments in the same email

@A_Wilc

I understand I think we are getting there slowly.

So the flow runs okay apart from the attachment issue. When the flow runs what information is displayed in the APPEND TO ARRAY VARIABLE item. Is this gathering all the files you expect such as the uploads and PDF. Or are any missing.

Looking at other posts on this issue, the right way to go is the first image above, but that misses the PDF. Again is the PDF in the OneDrive folder. Are all the files you are expecting to see in folder, there. I am only asking to confirm this in my mind.

Regards,

Andrew

Was this reply helpful? Yes No
A_Wilc on 15 Mar 2024 at 14:48:28

Like (0)

Report

Re: Convert form response to PDF AND send all uploads from the form as attachments in the same email

Thank you for your patience, I'm self taught and new at this so i just don't have the foundation knowledge.

"So the flow runs okay apart from the attachment issue. When the flow runs what information is displayed in the APPEND TO ARRAY VARIABLE item. Is this gathering all the files you expect such as the uploads and PDF. Or are any missing."

Yes the flow runs fine apart from the attachment issue. I used append to array variable to get the uploads from the form only - this works fine if I just ask the flow to attach the uploads to the email. I just don't know how to also get my PDF onto the email.

Should i be using compose to get the PDF and uploads together somehow, then i could use 'outputs' in the attachment section of the email???

Thanks
Anna

Was this reply helpful? Yes No
Andrew_J 1,962 Moderator on 15 Mar 2024 at 15:14:05

Like (0)

Report

Re: Convert form response to PDF AND send all uploads from the form as attachments in the same email

@A_Wilc

That was helpful, I think you need to look at the following:

The above is incorrect, you need to change the body to file content. An also look at the dynamic content for for the name. The below should help.

Hoefully this should take care of things maybe you can go and have drink later if you get lots of green ticks.

Regards,

Andrew

Was this reply helpful? Yes No