web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Grabbing data from an ...
Power Automate
Unanswered

Grabbing data from an excel sheet

(0) ShareShare
ReportReport
Posted on by 6

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 excelFlow.PNG

Categories:
I have the same question (0)
  • Verified answer
    Hardesh15 Profile Picture
    7,087 Super User 2024 Season 1 on at

    @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

  • MikeDee Profile Picture
    6 on at

    It was helpful
    Thank you

  • Hardesh15 Profile Picture
    7,087 Super User 2024 Season 1 on at

    @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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard