Get data from Excel and send per E-Mail

(0) Share

Report

Posted on by IPGeorgiev

Hi All,

I want to achieve the following:

When an E-Mail arrives in a specific folder it should be saved to the file system - achieved using automated flow "When a new email arrives" and "Create File" to system using gateway.

Power Automate Desktop -

1. Opens the saved excel file - DONE

2. Copy a specific range of cells - DONE

3. Launch Outlook - DONE

4. Send an E-Mail - NOT DONE

For 4) I have the following questions:

How can I paste that what I copied in step 2 in the body of this E-Mail? Is this even possible or is there another way to do the same (as an idea, but with different steps)

Many thanks in advance!

Best regards,

Ivan

Categories:

Power Automate Desktop

I have the same question (0)

All responses (6)

Answers (0)

PetrosF-MSFT on at

Like (1)

Report

Hi @IPGeorgiev

After copying the data, you could use the "Get clipboard text" Action to store the data into a variable. This variable could be passed to the body of the email.

Alternatively, you could use the "Read from Excel worksheet" Action to store the Excel data directly into a variable.

I hope the above helps!

Was this reply helpful? Yes No
IPGeorgiev 48 on at

Like (0)

Report

Hi @PetrosF-MSFT ,

many thanks for your time and the response!!

This does work , however it pastes the data from excel as a plain text, without any formatting etc.

Is it possible to keep to formatting (as it would happen in case you manually copy and paste the data from excel into outlook) or this is not possible?

Many thanks!

Best regards,
Ivan

Was this reply helpful? Yes No
PetrosF-MSFT on at

Like (1)

Report

Hi @IPGeorgiev

There are two ways to accomplish that:

The simple way:
Focus on the Outlook window (Focus window Action), wait for a couple of seconds (Wait Action), and send the key combination {Control}{V} (Send keys Action). This will paste the data on the Outlook window.

The advanced way:
In the Send Email through Outlook Action, enable the "Body is HTML" toggle button and send the data in HTML format.

I hope the above will be helpful!

Was this reply helpful? Yes No
IPGeorgiev 48 on at

Like (0)

Report

Hi @PetrosF-MSFT ,

I have tried the advanced way and here's what I get:

How the data looks like in Excel:

Heres how my flow looks like:

And this is what I get per E-Mail:

I guess I am missing something but not sure what 😞

Thanks in advance!!

Best regards,
Ivan

Was this reply helpful? Yes No
PetrosF-MSFT on at

Like (0)

Report

Hi @IPGeorgiev

Please have in mind that when you enable the "Body id HTML" button, this means that the body of the email accepts data in an HTML format.
Hence, you would need to modify your data accordingly in an HTML format, before adding them to the Action.

That solution is a bit more complicated as it requires some knowledge of HTML.

Was this reply helpful? Yes No
astanb 2 on at

Like (0)

Report

I need to do this exact same thing. But adding more complexity. I need to read data from four specific columns in multiple random amounts of excel files in one folder. That could have only one row with actual data or hundreds of rows. It would need to be something like. Read B2:B1000 if data copy when cell with no data is found go to column R2:R1000 if data copy when cell with no data is found go to column Y2:Y1000 if data copy when cell with no data is found go to column AG2:AG1000 if data copy when cell with no data is found go to next file in folder. When all files in the folder are read from past that into an email and send to predetermined recipients. But paste in the email in an excel style format.
Can this be done?

Was this reply helpful? Yes No