Answered

Grabbing data from an excel sheet

(0) Share

Report

Posted on by MikeDee

I created a flow to grab data from and excel sheet and send the contents to my mail but it keeps sending each row as a separate email. Also I cant get it to send the rows in a tabular format. Does anyone have a fix for this. I attached a screenshot of the flow

All responses (3)

Answers (1)

Hardesh15 7,087 Super User 2024 Season 1 on at

Like (1)

Report

Re: Grabbing data from an excel sheet

@MikeDee If it solves your problem. please mark as accepted solution.

Please 'Thumbs Up' the posts that helped you and 'Mark as Solution' if my post answered your question.

@Hardesh
MikeDee 6 on at

Like (0)

Report

Re: Grabbing data from an excel sheet

It was helpful
Thank you
Verified answer

Hardesh15 7,087 Super User 2024 Season 1 on at

Like (1)

Report

Re: Grabbing data from an excel sheet

@MikeDee This ishappening because Apply to each is sending email for each row value.

Use one select after List row present a table and pass value in it. Add key and value in select action as per your need. After that use Create HTML table action and pass output of select action into.

Use create html table output in your email body.

Please 'Thumbs Up' the posts that helped you and 'Mark as Solution' if my post answered your question.

@Hardesh