Power Platform Community Forum Thread Details

Hello Everyone!

Sorry for what I am sure is a newbie question (newbie here though!), but I am trying to create a flow where I push the Run button to trigger the flow, and the process will send an email to an email address listed in the Excel file and merge some of the different cells' content into a few spots in the body of the email. Is this even possible? I am searching through how-to content about sending emails using the triggered Run button, but I don't see a way to merge data from an Excel document into this email. Thanks!

Categories:

Building flows

Hi @NobodyInParticu ,

Don't be sorry, this is a nice question and we will be glad to help you 🙂

First: yes, it is possible to pull data from Excel and populate an email body with that. Ideally, this Excel data should be structured as an Excel table, to make it easy to read with Power Automate (in this article you will find some instructions about how to crate tables and integrate it with Power Automate: http://digitalmill.net/2023/07/17/integrating-power-automate-and-excel-tables/)

Also, did you already start to build your flow? If yes, please share an image of your current design. If not, I recommend you to initially add (1) a manual trigger, and a (2) a 'List rows present in a table' action.

If it is possible, please also share a sample of your Excel table (remove any sensitive content from the image) and list the columns that you will want to use into the email.