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

(0) Share

Report

Posted on by MS-15011409-0

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?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

eliotcole 4,388 Moderator on at

Like (0)

Report
Copy link

Link copied!

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. :)

Was this reply helpful? Yes No
Suggested answer

MS-15011409-0 4 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
eliotcole 4,388 Moderator on at

Like (0)

Report
Copy link

Link copied!

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. :(

Was this reply helpful? Yes No