Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

Converting, saving, & emailing from Microsoft Forms | All steps working except the email feature.

Posted on by 2
Hello, 
 
I am new to Power Automate, and have found tutorial videos to help me get to where I am at in my Flow. Please explain anything I need to do to me like I am five, haha.
 
I have created a flow that triggers when a Microsoft Form response is created. The flow converts that response to HTML, saves it to OneDrive, uses the convert to PDF function in OneDrive, and then saves the final copy of the PDF to SharePoint. (This was the best method I could find to save to SharePoint and it works perfectly). 
 
My issue comes in when I try and email that final PDF to people from the Microsoft Form. I need to have the email step as part of this flow because I am pulling emails from the Microsoft Form responses as the recipients. I can pull the emails from the form responses correctly. However, when the file sends... it comes through in this weird WingDings looking HTML file. I have tried using the get file content action and it still happens. If I set the email up in a separate flow using the "when a file is added to SharePoint" as a trigger it sends the PDF, but that does not help because I have to preselect the email address(es) and I MUST pull the emails from the Microsoft Form Responses. 
 
I have tried multiple ways to attach the file. Just saving the PDF to OneDrive adding a get file content action and more. I know I cannot have two triggers in one flow, but it feels like that is what needs to happen. A trigger when the form is filled in and another trigger when a file has been added to SharePoint. I know I could just add all the responses to the body of the email, but it would be a lot easier to just send the PDF that gets created. 
 
Since it only allows me to attach 3 files I have attached the HTML file that gets emailed, a picture of my flow, and the email step. 
  • WW-04111542-0 Profile Picture
    WW-04111542-0 2 on at
    Converting, saving, & emailing from Microsoft Forms | All steps working except the email feature.
    Nived, 
     
    I am not sure how to reply to your comment or if I can. I have tried using IDs among other items (names, file content, etc.) from each of these steps: 
     
     
    I even tried adding a get file contents step after creating the file on SharePoint and using the information from that one.  No matter which I use, it attaches that odd WingDing html file or it gives me details like the path to the file or other things about the file, but not the file itself. 
  • Nived_Nambiar Profile Picture
    Nived_Nambiar 16,591 on at
    Converting, saving, & emailing from Microsoft Forms | All steps working except the email feature.
    Hi,
     
    so you are facing issue with attaching pdf file to email - if i am right
     
    so in that case, which file content you have used in your case ?
     
     
     

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

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,591

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,090

Leaderboard