Skip to main content

Notifications

Power Automate - Building Flows
Suggested answer

Creating a HTML table with the current row of a SQL data base

(0) ShareShare
ReportReport
Posted on by 4

Hey there! I've been creating a new power automate flow to send emails for suppliers about purchase orders. I'm having a hard time when creating a HTML table to send the info of the order, which is in a row of my SQL data base. When I send the email, it sends the whole data from the SQL, instead of only the current row. Anyone knows how to deal with it?

rich text editor imagerich text editor image
  • eliotcole Profile Picture
    eliotcole 4,196 on at
    Creating a HTML table with the current row of a SQL data base
    Sorry, now I'm more confused than ever, mate ... apologies.
    Why are you adding Selects, and loops?
    It might help us to have a little more information on what you're seeing and trying to do, I think.
    The images are being squashed, and it's hard to know what you're dealing with in terms of information ... sorry. :(
  • Suggested answer
    MS-15011409-0 Profile Picture
    MS-15011409-0 4 on at
    Creating a HTML table with the current row of a SQL data base
    RE: @eliotcole I tried putting a filter array, to get the exact purchase order I want in the Foreach action, but the result is always blank, I'm struggling on finding why is that.



  • eliotcole Profile Picture
    eliotcole 4,196 on at
    Creating a HTML table with the current row of a SQL data base
    Hi, Murilo ( sorry, I cannot @ you in this forum :weary: )
     
    You need to trim the results down from the body/value that you are referencing before using them in your 'Tabela Info Item' action.
     
    I recommend either a Filter action, or find a way to select one specific item from the SQL DB in question and make an array from that single item. :)
     
    The easiest way, though, is to use the Filter action.
    Filter the body/value to whatever will result in what you need to see in the table, then replace the body/value in your 'Tabela Info Item' action with the output (body) of the Filter action. :)

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,567

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard