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.