Check out the announcement of Power Platform content at Microsoft Ignite! So, for SKU label I want to fetch the data that was on the SKU column in my excel, (all of them, one by one) to be more clear with this example will be: "SKU":@item()? My flow executes a an SQL query and I need to send and email with HTML table for each sales order. In this case, a manually triggered flow that Get Rows from each table. One retrieving all the data and another one with SELECT DISTINCT just for 2 columns: email and sales order (sorry in the image put it as Order ID).
Exactly, 2 get rows, different tables and consignee matches I used the second table to identify or to set the array parameters. Will use fake data as you know... sensitive stuff.
when inspecting the "append to array" steps, I see the following output. (Flow keeps adding apply to each all the time). Hi, I have created a flow that builds an HTML table based on an array (following one the examples form the forum. After the send email should be enough and you can fetch the email needed from the the 2nd table result with email item. This way other community members facing this same problem in the future will have the chance to find a solution faster. Please take this for a reference and try again with it. Check out the announcement of Power Platform content at Microsoft Ignite! Use filter data operation and defined the same condition - this will return array of records matching the filter collection. When the flow is run, I see the output in the "Create HTML table" step... As you can see, there are three items in the planner that are being appended to the array. I tried the advanced options for custom columns but enable to make it fly. I always do it in text/advanced mode. Power Platform and Dynamics 365 Integrations. Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. 6. The property 'columns' must be specified unless the 'from' property value is an array of objects. I'm assuming that the email address is included in the same table therefore, I have 2 queries. 3 and 7 corresponds to the index of the values. I get successful results by combining json() function and setProperty() function into an expression instead. In most common programming languages you will recognize the term array as a block of related data elements. Create an Array from Get Items and Convert Into an HTML Table in Power Automate. Thanks again for responding and supporting - much appreciated! @fermoreno This worked perfectly!! Hope this helps, if not please let me know.