Rookie trying to create a Flow - Excel Data Emailed Weekly

(0) Share

Report

Posted on by tbow1221

I have simple Excel file with a table and 6 rows and 2 columns.

Rows:

US Sales

Germany Sales

UK Sales

US Booking

Germany Bookings

UK Bookings

Columns: Dollar amounts

I want to retrieve the data from the excel file and email it once a week on Friday. I am using the List Rows Present in a Table action with the email. It works but sends me a separate email for each row and the data is plain text. Anyway to keep the format in Dollars and send one email that contains all rows?

Categories:

Building flows

All responses (4)

Answers (0)

Sort by

tbow1221

6 on at

Like (0)

Report

Copy link

Link copied!

This seems to work but the table contains two columns I would like to remove

@OData.etag	ItemInternalId
	ff79ac6e-6d21-4377-b57c-286a6222650c
	f76372ba-4b30-4a28-bd9b-363723c4397b
	0c0d32df-e8b7-4eb5-8f23-37e6fc9ebe0f
	554487f0-5a07-4e83-b650-d6cf2dccbe3e
	d135c0db-389f-4ad0-81dc-fa2fd3add585
	e8e41898-ee68-4f7c-a8dd-07ac8f713232

Any suggestions on how to exclude this data?

RobElliott 10,539 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

@tbow1221 I'm about to go into a meeting so for now I'll just post up the steps in the flow from when I answered the same question from one of our staff last week. Come back with any questions.

json(replace(string(outputs('List_rows_present_in_a_table')?['body/value']),'@odata.etag','odataetag'))

union(body('Select'),body('Select'))

The overall flow is therefore:

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.
tbow1221 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks Rob, I will take a look but may not be able to work on this until Tomorrow evening of Friday.
tbow1221 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Rob, I ended up having some extra time today and I walked through your example. The first output was every record repeated 6 times which is the exact number of rows I have, and I thought it was due to the select statement I used and so I removed that and now I get no data.

The Excel table is always going to be 6 records and the only thing that changes is the data in one column of the 6 records. I want to send the entire excel table to an HTML table. Can you help me with the select part of the flow?

Here is what it looks like without the select: