Answered

Attach multiple items to an email via forms

(0) Share

Report

Posted on by LukeSykes

I have followed this guide

Emailing File Attachments from Forms with Power Automate – What Me Pa..Panic? (dontpapanic.com)

However unfortunately it sends an email for each item uploaded, and each subsequent email also has the attachment for the previous email attached:

Email one: Attachment One

Email two: Attachment One and Two

Email three: Attachment One, Two and Three

and so on.

How can I prevent this please?

This is my schema if it's useful?

{

@Pstork1

"type": "array",

"items": {

"type": "object",

"properties": {

"name": {

"type": "string"

"link": {

"type": "string"

"id": {

"type": "string"

"type": {},

"size": {

"type": "integer"

"referenceId": {

"type": "string"

"driveId": {

"type": "string"

"status": {

"type": "integer"

"uploadSessionUrl": {}

"required": [

"name",

"link",

"id",

"type",

"size",

"referenceId",

"driveId",

"status",

"uploadSessionUrl"

]

}

Categories:

Building flows

flow.png

I have the same question (0)

All responses (17)

Answers (1)

LukeSykes on at

Like (0)

Report

@Pstork1

Hi Paul

Please can you let me know how to collect the schema?

Was this reply helpful? Yes No
Pstork1 68,717 Most Valuable Professional on at

Like (0)

Report

Run it once with a schema of {}. Then take the output of the parse JSON in the run and use that to generate the schema usingthe built in button.

Was this reply helpful? Yes No
LukeSykes on at

Like (0)

Report

Excellent - thank you

Was this reply helpful? Yes No
LukeSykes on at

Like (0)

Report

Hi Again @Pstork1

For some reason, doing this sends multiple emails like mentioned in my original post, so if i attach 3 items it sends

Email one: Attachment One
Email two: Attachment One and Two
Email three: Attachment One, Two and Three

Was this reply helpful? Yes No
Pstork1 68,717 Most Valuable Professional on at

Like (1)

Report

Move the Send an email action outside the loop that appends the documents to the array. Having it inside the loop sends one email as each document is added. You have to add all the documents first and then send the email

Was this reply helpful? Yes No
LukeSykes on at

Like (0)

Report

PERFECT!!!

Thank you so much

Was this reply helpful? Yes No
LukeSykes on at

Like (0)

Report

how can I make this still work if there is no attachment on the form? It fails at the Parse Json action

Was this reply helpful? Yes No
Pstork1 68,717 Most Valuable Professional on at

Like (0)

Report

If you give them the option to not upload a file then you need to check whether an attachment exists or not before doing the Parse JSON. If it doesn't have any attachments skip the parse JSON and the loop and just send the email. The attachment array at that point will be empty.

Was this reply helpful? Yes No
LukeSykes on at

Like (0)

Report

Ok

So I'm checking for that with a condition - problem is I want it to send the email either way.

The form has a drop down where you select which staff list you want to send the email to, there are 7.

Does that mean building 14 switches? 7 for if there is an attachment under 'If Yes' in the condition and 7 under 'If No' for if there isn't one?

Was this reply helpful? Yes No
Pstork1 68,717 Most Valuable Professional on at

Like (0)

Report

No, You check to see if the question where you upload a file is empty or not. If its not empty you need to create the array. If it is empty then you skip creating the array (the parse json and loop actions). Then send the email normally. You just add a condition to check for attachments and put the parse json and the loop inside the yes of that condition. Then send the email after the condition. That has nothing to do with who you are sending the email to.

Was this reply helpful? Yes No