Unanswered

How should I capture content from a spreadsheet directly into an email using Power Automate (cloud version)?

(0) Share

Report

Posted on by OliVA2023

Hello,

I am trying to grab content from a spreadsheet on Sharepoint and literally just copy/paste it into an email to be sent each morning.

I am using Power Automate (cloud version), but nothing I have tried so far works well.

The file is found here: /Shared Documents/IT Service Desk/Morning reports/Morning report template.xlsx

The sheet I want to copy from is called 'Overview'. I literally just want to copy everything as it is there and paste it into an email.

Thanks in advance for any suggestions.

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (0)

Chriddle 8,443 Super User 2025 Season 2 on at

Like (0)

Report

Use Excel's Get items and put it's output into an HTML table

Was this reply helpful? Yes No
OliVA2023 20 on at

Like (0)

Report

Thank you for your reply. As far as I can see, there is no 'Get items' operation in Power Automate except under Sharepoint, which asks me to point to lists rather than documents. There is nothing under Excel under 'Get items'.

Was this reply helpful? Yes No
Chriddle 8,443 Super User 2025 Season 2 on at

Like (0)

Report

You're right, it's called List rows present in a table

and the data must be in a table.

Was this reply helpful? Yes No
OliVA2023 20 on at

Like (0)

Report

Thanks again for your help.

I have tried this operation (see below) but whatever output I choose from 'List rows present in table' turns the 'Create HTML table' operation into an 'Apply to each'. I don't appear to be able to include its output in any emails.
The error message I get is below.

Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The inputs of template action 'Send_an_email_(V2)' at line '1 and column '1458' is invalid. Action 'Apply_to_each' must be a parent 'foreach' scope of action 'Send_an_email_(V2)' to be referenced by 'repeatItems' or 'items' functions.'.'.

Was this reply helpful? Yes No
Chriddle 8,443 Super User 2025 Season 2 on at

Like (0)

Report

This should not happen 😉

Was this reply helpful? Yes No
OliVA2023 20 on at

Like (0)

Report

Thank you, I have now managed to get basic tables to copy over from the spreadsheet into an email.

I wonder now - is there a way to format these tables at all (aside from customising the columns)? All I am getting so far is a very basic and dreary text table.

Was this reply helpful? Yes No
Chriddle 8,443 Super User 2025 Season 2 on at

Like (0)

Report

Unfortunately not out of the box.
However, you can use string replacements on the HTML, add CSS, or create the HTML table from scratch without using the action.

Was this reply helpful? Yes No