Multiple Email Attachments from One Drive on PowerAutomate

[zak3]

Hello everyone,

I'm trying to include attachments in an automated email following the advice and tutorials from the community. However, when I try to enter the "name" of my variable in the step below,

the name of my document doesn't appear.

I'm afraid I may have made a mistake, but I really don't see where I could have gone wrong.

Here is my attachments :

and this is my flow 

Thank you in advance for your kind responses. Best regards.

P.S. I also followed the advice of this young lady:

https://www.youtube.com/watch?v=0gnC9_UbFF4

[creativeopinion]

@zak3 It looks like you have your actions nested multiple times from your screenshot. The logic of your flow will need to be adjusted.

Can you toggle OFF the New Designer, expand all your actions and upload a full screenshot of your flow. It'll provide more insight as to the current logic of your flow. 

In the meantime, you might find these YT Tutorials helpful: 

5 Power Automate Troubleshooting FAQs and Helpful Tips for Creating Better Flows

In this Power Automate tutorial, I explore 5 frequently asked questions that pop up when troubleshooting a flow. If you’d like to to level up your Power Automate flow skills and learn how to troubleshoot your Power Automate flow—this tutorial is for you!

IN THIS VIDEO:

✅ How to troubleshoot a false Condition action result

✅ How to get dynamic content when it isn’t selectable from the list of dynamic content

✅ How to troubleshoot an Apply to Each action that isn’t looping through

✅ How to troubleshoot a skipped Apply to Each action

✅ How to troubleshoot a Filter Query

✅ How to use a SharePoint yes/no column in a Filter Query

✅ How to use Compose actions to troubleshoot a Power Automate flow

✅ How to troubleshoot multiple emails being sent

✅ How to troubleshoot multiple Teams messages being sent

----

3 Mistakes YOU 🫵 are Making with the Apply to Each Action in your Microsoft Power Automate Flow

In this video tutorial I’ll go over how to avoid these common mistakes when using the Apply to Each action in a Power Automate flow:

1️⃣ Looping through a Single Item

2️⃣ Creating Unnecessary Nested Loops

3️⃣ Looping through an Unfiltered Array

At the end of the video I share a few helpful insights when it comes to using the Apply to Each action in your flow.

IN THIS VIDEO:

✅ How to avoid the Apply to Each action with a single item array

✅ How to use the item() function to access dynamic content in an array

✅ How to prevent unnecessary nested Apply to Each action loops

✅ How to use the Select action

✅ How to convert an array to a string with the Select action

✅How to use the Filter Query field

✅ How to count the number of items in an array

✅ How to use a condition control

✅ How to use the concurrency control

✅ How to set a top count

✅ How to use Compose actions for troubleshooting

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube
👉 Tips and Tricks on TikTok and Instagram

[zak3]

It looks like this.

I started getting familiar with Power Automate this morning, but even after watching your video, I can't seem to find the solution. My case is quite unique because I have interdependent questions that stem from previously answered ones, so I don't see how to modify the logic of my flow.

[creativeopinion]

@zak3 Those tutorials were just recommendations—from your original post I had no idea your flow was for an MS Form. If you can provide more insight to the intended logic of your flow and how your form is set up—it'll be easier to provide recommendations.

You might find these tutorials helpful:

How to Get a Microsoft Form RSVP Response into a SharePoint List

IN THIS VIDEO:

✅ How to get a Microsoft Form Response into SharePoint

✅ How to get a Microsoft Form ID

✅ How to get a Microsoft Form response

✅ How to Build a Microsoft Form with Conditional Fields

✅ How to used Branching in Microsoft Forms

✅ How to format Microsoft Form multiple choice responses for a SharePoint multi-choice column

✅ How to parse a Microsoft Form multiple choice response as string of text

✅ How to convert a text response to a number

✅ How to use the Switch action

✅ How to create a custom email confirmation for a Microsoft Form submission

✅ How to Create a Custom View in a SharePoint list

✅ How to use the Compose Action

✅ How to write Power Automate Expressions

----

How to Get Microsoft Form File Uploads Attached to an Email 📧

In this Microsoft Power Automate Tutorial I’m going to cover where file uploads from your Microsoft Forms are saved. I’ll also show you how attach the uploaded files to an email and how to dynamically name the files and customize the recipient of the email based on the selections made in your Microsoft Form. I will also cover how to handle responses that don’t include any file uploads.

IN THIS VIDEO:

‌✅‌ Two types of MS Forms

‌✅‌ Where Microsoft Personal (OneDrive) Form File Uploads are Saved

‌✅‌ Where Microsoft Group Form File Uploads are Saved

‌✅‌ How to Add a File Upload Question to an MS Form

‌✅‌ How to get a Microsoft Form ID

‌✅‌ How to get a Microsoft Form Response

‌✅‌ How to Get the Dynamic Content Microsoft Form File Upload Content

‌✅‌ How to handle Single and Multiple Microsoft Form File Uploads

‌✅‌ How to use a Scope action to Organize and Group Your Flow Actions

‌✅‌ How to Get the File Content from an MS Form File Upload

‌✅‌ How to Collect All Files Uploaded to a MS Form and Attach to an Email

‌✅‌ How to Handle MS Form Response When a File Isn’t Uploaded

‌✅‌ How to Create an Email Key

‌✅‌ How to Send an Email to a Specific Recipient Based on Form Selection

‌✅‌ How to Create a Dynamic Output Based on Form Selection

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube
👉 Tips and Tricks on TikTok and Instagram

[zak3]

I am in the case of a Forms questionnaire aimed at stores wishing to open different e-commerce solutions. Among these stores, some already have a first solution and want a second one, others want to change the current one, and still others have no solution and want to open their first e-commerce. In this context, the emails and attachments associated with them will be completely different. Therefore, I would like that depending on each case, an email be sent with several attachments sourced from OneDrive.

[creativeopinion]

@zak3 Can you clarify the need for nesting multiple switch actions inside each other?.. Could you share a screenshot of the full flow? It's hard to see what's going on in your flow with what you've shared so far.

[zak3]

Sure, I'll clarify. The need for nesting multiple switch actions inside each other arises when we have complex branching logic or multiple conditions to evaluate. This allows us to handle different scenarios or outcomes based on various combinations of conditions.

Regarding the screenshot, I'll provide you with a full view of the flow to give you a better understanding of its structure. Please find the screenshot attached.

In this last flow I'll tried to manage my attachements but i'ts actually don't work 

[creativeopinion]

@zak3 Could you provide me with some examples of the various combinations of conditions? I don't have enough info to go on. The more details you can provide the easier it is to provide recommendations.

[zak3]

Hello, 

Certainly, here are some examples of different combinations of conditions:

1. Example 1:

   • Condition 1: If the store already has an existing e-commerce solution.
   • Condition 2: If the store wants to change its existing solution.
   • Condition 3: If the store wants to open a second e-commerce solution.

2. Example 2:

   • Condition 1: If the store does not yet have an e-commerce solution.
   • Condition 2: If the store wants to open its first e-commerce solution.
   • Condition 3: If the store has specific requirements for its first e-commerce solution.

Condition 1: If the store already has an existing e-commerce solution.

• Yes:
  • Condition 1.1: If the store wants to change its type of e-commerce or wants to open a new type of e-commerce on its store.
    • Condition 1.2: Specify the type in each case.
• No: Has the store validated the type of its first concept?
  • Yes: Which type of e-commerce was validated
  • No: Email send with the instruction for validation whith a third part

In each of these cases a mail with instructions and attachements are send. Let me now if you have interrogations.

[creativeopinion]

@zak3 Unless I'm missing something, does your flow require a condition? After reviewing your condition it seems as if you only want to send an email if the answer to the question: Has the store validated the type of its first concept? is equal to No.

If that's the case, it might make more sense to adjust your flow logic to output which email(s) need to be sent out. Meaning you would adjust your flow to collect the responses from your form that would result in an email being sent. 

Can you clarify if a person would receive one or multiple emails?

Also, it's not indicated in your previous post but what do you need to do with the information returned in: 

• Condition 1.2: Specify the type in each case.

 Does the person receive an email as well?

[zak3]

Yes the case, the person(s) would receive one specific mail but with severals attachement's.

For your second question yes in the condtion 1.2, each selected case trigger a specific email with some specific's attachement's.

I'm sorry if I'm not enough clear.

[creativeopinion]

@zak3 The logic is still not totally clear. I think you need to look at your flow from the end result.

• How many emails will a recipient receive? Are there cases where a recipient will receive multiple emails or will they always receive a single email?
• If they will receive a single email then you will need to determine the content of the email and it's attachments based on the responses from the form.

For example, take a look at this section of my latest YT Tutorial where I cover a scenario where you could either have a Condition action with a Yes/No branch or simply use an expression to output dynamic text. Keep in mind this is a very simple flow example but hopefully illustrates how you don't need to have multiple condition actions if you just adjust the logic of your flow. 

[zak3]

In that case, each response triggers the sending of a single specific email with its predetermined attachments, so it seems that true/false conditions are not relevant.

So yes, it will receive only one email.

Everything is already specified, and there are no "false" cases since these are unique and identified possibilities. I can simplify the logic of your flow by avoiding the use of unnecessary conditions. Instead, I can use actions that directly send the emails corresponding to each response of the form.