Send emails with attachments from Powerapps

(2) Share

Report

Posted on by VO-16022037-0

Hello!

I am trying to send an email from a button trigger on powerapps but include attachments.

On PowerApps I am selecting multiple items from a gallery using a check box. OnCheck, I am collecting all checks and creating a collection called colPickUp which could have many rows with different items.

Inside a list, those items have attachments.

On PowerAutomate i was able to create the email and send it with the subject and body I want, but I am trying to figure out how to have a way to get attachments and then include them all in the email.

What I did was below:

I connected the sharepoint and the list name, but I was wondering how to get all of the IDs in the collection (or if that's even possible).

Example, if my collection has ID 1 on row 1 and ID 2 on row 2, I wanted to get the attachments on both ID's.

And then How can I send it through email? On powerautomate i have:

but not sure how to include the attachments.

Thanks!

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Suggested answer

Sunil Kumar Pashikanti 2,040 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi @VO-16022037-0,

If you're trying to send attachments from multiple SharePoint items in a single email, you’ve probably noticed that the Get attachments action only accepts one ID at a time. It doesn’t support passing a collection directly, but there’s a standard workaround.

Collect all attachments into an array as the flow runs, then pass that array into the email action at the end.

Steps
1. Initialize an array
At the start of the flow, add an Initialize variable action:

Name: varFiles
Type: Array
Leave it empty

2. Loop through selected items
Use an Apply to each loop over the IDs coming from Power Apps.

3. Get attachments (metadata)
Inside the loop, use Get attachments with the current item ID.
4. Get attachment content
Add a nested loop (since each item can have multiple files), and use Get attachment content to retrieve the file data.

5. Build the array
Use Append to array variable with this structure:
{
Name: DisplayName,
ContentBytes: Attachment Content
}

6. Send the email
After the loops (outside of loop):

Add Send email (V2)
In the attachments field, switch to “input entire array”
Use varFiles

Summary
Since SharePoint attachments are item-based, you need to fetch them per item and aggregate them yourself. Once they’re in an array, sending them in one email becomes straightforward.

✅ If this answer helped resolve your issue, please mark it as Accepted so it can help others with the same problem.
👍 Feel free to Like the post if you found it useful.

Sunil Kumar Pashikanti, Moderator
Blog: https://sunilpashikanti.com/posts/

Was this reply helpful? Yes No
Suggested answer

Valantis 4,814 on at

Like (1)

Report
Copy link

Link copied!

Hi @VO-16022037-0,

Good question. The key is passing all the IDs from Power Apps to the flow, then looping through them in Power Automate to collect all attachments before sending the email.

In Power Apps, when you trigger the flow from the button, pass the IDs as a JSON string:

YourFlow.Run(JSON(ShowColumns(colPickUp, "ID")))

This converts your collection to a JSON array like [1, 2, 3] and sends it to the flow as a text parameter.

In Power Automate:

1. Accept the IDs as a text input parameter
2. Add a Parse JSON action to convert the text back to an array. Use schema: { "type": "array", "items": { "type": "object", "properties": { "ID": { "type": "integer" } } } }
3. Initialize a variable (array type) called varAttachments
4. Add an Apply to each loop over the parsed JSON array
5. Inside the loop: Get attachments (SharePoint) using the current item's ID
6. Add another Apply to each loop inside for each attachment returned
7. Inside the inner loop: Get attachment content (SharePoint) using the attachment's ID and file name
8. Append to array variable: { "Name": attachment file name, "ContentBytes": attachment content }
9. After both loops: Send an email (V2) and in the Attachments field, use the varAttachments array

The Send email V2 action accepts attachments as an array with Name and ContentBytes properties, so this maps directly.

One thing to confirm: in your Get attachments action, connect it using the same SharePoint site and list, and set the Item ID to the ID from your loop's current item. If your column name in the collection is different from "ID", adjust the JSON column name accordingly.

Was this reply helpful? Yes No
Suggested answer

11manish 1,953 on at

Like (0)

Report
Copy link

Link copied!

Yes, you can send attachments from multiple selected SharePoint items, but you must pass only the selected item IDs from Power Apps to Power

Automate, then loop through those IDs in the flow to retrieve attachments from SharePoint, collect them into an array, and finally attach them to

the email before sending.

Power Apps collections cannot directly pass nested attachments, so the logic must be handled in Power Automate.

Was this reply helpful? Yes No
Suggested answer

Haque 2,399 on at

Like (1)

Report
Copy link

Link copied!
Hi @VO-16022037-0,

Based on the requirement - the core challange is pick up respective attachments from the SP list wheareas all items details are coming from PowerApps.

The collection you have created at the PowerAps side need to be passed to the PowerAutomate - and the do the neccessary housekeeping (pickup the attachment, build the email content and then send the email)

Here are the clean steps you can follow:

PowerApps: Pass Selected Item IDs to Power Automate: Collect selected items in a collection (e.g., colPickUp, that you have did already). Pass only the IDs to Power Automate as a JSON array:

YourFlow.Run(JSON(ForAll(colPickUp, ID), JSONFormat.None))

Power Automate: Receive and Parse IDs: Trigger: PowerApps or manual trigger with an input parameter for the array of IDs. Use Parse JSON action to parse the incoming array of item IDs.

Initialize an Array Variable for Attachments: Create an array variable (e.g., AttachmentsArray) to store all attachments for the email.

Loop Through Each Item ID: Use Apply to each on the parsed IDs array.

Get Attachments for Each Item: Inside the loop, use Get attachments SharePoint action with (Site Address, List Name, Current item) ID from the loop

Loop Through Each Attachment: Add a nested Apply to each on the attachments output.

Get Attachment Content: For each attachment, use Get attachment content action ( Configure: Site Address, List Name, Current item ID, Attachment file name)

Append Attachment to Array Variable: Append to AttachmentsArray an object with: json

{ "Name": "<attachment file name>", "ContentBytes": "<base64 content from Get attachment content>" }

Send Email with Attachments: Use Send an email action (Outlook connector). Fill in To, Subject, and Body fields as needed. In the Attachments field, pass the AttachmentsArray variable.

Important notes:

The base64 content from Get attachment content is ready to use directly - you don't need to do anything.

We need to make sure your PowerApps collection passes only the IDs to keep the payload light.

If attachments are large or numerous, be mindful of email size limits.

I am sure some clues I tried to give. If these clues help to resolve the issue brought you by here, please don't forget to check the box Does this answer your question? At the same time, I am pretty sure you have liked the response!

Was this reply helpful? Yes No
VO-16022037-0 24 on at

Like (0)

Report
Copy link

Link copied!

@Sunil Kumar Pashikanti @Haque @Valantis

I've gotten what you all sent here and that helped a lot! thank you!

However, I'm still having some troubles with the flow failing on different steps depending on what I try to fix..

Currently I have:

'PowerAppV2->Sendanemail(V2)'.Run(EmailListFlow.Text, SubjectEmailReqPick.Text, BodyEmailReqPick.Text, JSON(colPickUpID) )

1. On a button's OnSelect on PowerApps, I have:

2. When PowerApps Calls a flow

With 4 different text parameters:

- EmailList (with the emails I want to send)

- SubjectEmail

- BodyEmail

-colPickUpID (this is a collection with the ID's only, but the output ends up being something like:

3. Initialize Variable

4. Compose (which is what I'm having most trouble on)

This was an effort to converting the string of colPickUpID into an array

5. Big Loop - Apply to Each ID

The Outputs on "Apply to Each ID" is the outputs of compose from the step before

6. Get Attachments

Here I'm linking my sharepoint address and list. On the ID, I have the "apply to each ID"'s current item

7. Apply to each Attachment (inside the big loop)

The output selected in the Body of "get attachments"

8. Get attachemnt content, I have ID as current item from "apply to each ID" and File identifier as "get attachments, ID"

9. Append to array variable:

Name: Apply to each attachment, display name

Content Bytes: body(get attachments)

10. Lastly, the email

Where do you think could be the problem?

Thanks!

Was this reply helpful? Yes No