web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Building a flow to sen...
Power Automate
Answered

Building a flow to send different attached emails to different email address

(0) ShareShare
ReportReport
Posted on by

Currently, i have a MS Form that is collecting the receiver's email address.

Upon submission, i would like the attached form to be routed to the receiver email address.
below is the current flow. However, i believe it is not working correctly. any kind advice on where is my mistake? 
Thanks in advance! xD 

Gerald_T_0-1675675161204.png

 

 

 

Categories:
I have the same question (0)
  • fchopo Profile Picture
    8,003 Moderator on at

    Hi @Gerald_T 

    Current flow is sending one email per every file you have in the onedrive folder you specifed (e.g if you have 10 files, 10 emails will be sent to user "send to" in the form).

    What I don't get is your question. What do you want to achieve?

    Best,
    Ferran

  • Community Power Platform Member Profile Picture
    on at

    I would want the user to upload a file through MS FORMS.

    Then this file will be sent to another person's email. 

    Currently, i set the upload limit to 1. so that every time, only 1 file will be sent to another user. 

  • fchopo Profile Picture
    8,003 Moderator on at

    Hi @Gerald_T 

    You could do something like the following:

    1) Get response details

    2) Get information about the attached file in forms. This information is in JSON format, so you could parse it using this schema:

    {
     "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"
     ]
     }
    }

    3) Build the path where the file will be stored -> /Apps/Microsoft Forms/<Name_of_Form>/Questions/<Name_of_File>

    4) Get the file content using path in Onedrive.

    5) Send the email to the user.

     

    attachment-form.png

     

    As there could be multiple files (although we know there's only one), Power Automate adds the "apply to each" action.

    Hope that helps!

    Ferran

     

  • Verified answer
    Community Power Platform Member Profile Picture
    on at

    How did you get the file sample to appear in the Parse Json? 

    Gerald_T_0-1675701378097.png

    These are the available options to me only.

    Thanks for your help!!! 🙂 

  • Community Power Platform Member Profile Picture
    on at

    Bumpping this, still looking for an answer :C 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 501 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 323 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard