Skip to main content

Send Multiple Attachments in Single Email added from Microsoft Forms using Microsoft Flow ( Power Automate)

Recently in forms a new feature has been introduced. Now users can able to add Attachments in Microsoft Forms.

Scenario :-
When a new response is submitted in Forms using the Flow we are sending an email with that attachments.

Mentioned below are the Steps :-

Step 1 :- Here is my sample Form.




Step 2:-
Login to the Flow with your school or work account and create flow like this.
When a new response is Submitted -> Get response Details
Step 3 :-
Click on New Step and add Compose. Add the file Upload as input to the Compose.



Now try to run the flow and copy the output of the compose and paste it Notepad for your reference. [You can remove the compose once you copied the code]

Step 4:-
Add the Parse JSON action card and in the Content add the File upload from dynamic content click on Generate from Sample and past the code and click on done. It will generate the JSON Schema automatically.



Step 5:-
Now initialize a variable and set the type to Array.


Step 6 :-
Add Apply To Each and add the body from dynamic content.Now search for Get File Content Using Path (One drive For Business Connector) choose the Respective folder and choose any file name.

Then remove that file name in the Get file content using Path and add Name from the dynamic content . Whenever a new Form is Created by default a folder will be created in the One drive. [Nan Form is Microsoft Form name].

Step 7:-
Add Append to Array Variable and set the value like below. Name should be enclosed in Double quotes ("").

body('Get_file_content_using_path').$content
[if this is not working you can try the below option]
body('Get_file_content_using_path')['$content']



Step 8:-
Get out of the Loop click on New Step and add Send an Email. In the Attachments section click on Switch to input array and add the variable name from the dynamic content.


Step 9:-
Now you will see the output like below. You can add multiple attachments in Forms and you will get the multiple attachments in the Email.


Happy Learning 😄😄👍


Comments

Popular posts from this blog

Creating News Application using Flow and Power Apps ( Part -1 )

Create a Flow to fetch the latest news from Public API Step 1 :-                      Login to Power Automate using work or School account . Add a PowerApps Trigger - > add HTTP Action card. **You can find public API which are available online for free. Here is the Top Free News API's. News API, Bing News Search API, Bloomberg API etc.... In this Tutorial I am using News API to fetch the latest news. Just Login to News API and generate API Key. Once you Login to the News API there you will see news from different sources. Choose any one of the source. Once you generate the API Key , redirect to the Flow Portal in HTTP Action Card choose the method as GET and paste the URI [ if you choose any one of the source you will get url with API key included in that]. Choose Authentication mode as None. Step 2 :-                     Now Run the Flow. Copy the Output of HT...

Creating News Application using Flow and Power Apps ( Part -2 )

 Creating PowerApps Screen to view the latest  news. This is continuation of  Previous Article  . Please have look into it if you missed my previous article.  Step 1 :-                      Login to the PowerApps -> Create an app from Blank using Phone Layout.Add Header and Footer using labels -> Add a Refresh Icon from Icons menu. Set the Refresh Icon OnSelect property to this code.   ClearCollect(test12,'Flowname'.Run()); -- test12 is collection name. --Once user press Refresh icon internally it calls the Flow , get the data from Flow in JSON format and stores the data in collection . **You can either write this formula in OnSelect property/ App OnStart property.** Step 2 :-                      Add a Blank Vertical Gallery -> Inside that add another Gallery, choose the layout as Image,Title,Subtitle. Reason for adding...