6
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?
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:
@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.
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?
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
Share
Report
All responses (
Answers (
