CREATE HTML TABLE WITH TWO ODATA

(0) Share

Report

Posted on by fgonzalez515

296

Hi Community,

I have two Odata.
1. Get Items DTE
2. Get Items Proveedores

Both Odata have in common the column of Codes.
I want to create an html table with the columns and items from Get Items DTE and with a column from Get Items Proveedores.

I want to send an html table by mail using Select, the problem I have is that it takes the Values only from one Odata and if I enter an item from the other Odata an Apply to each is generated, which does not help me since I need to send only one mail with an html table.

I need help from the community

Categories:

Building flows

All responses (6)

Answers (2)

Sort by

Mira Ghaly 11,415 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@fgonzalez515

Can you share how your lists are structured?
fgonzalez515 296 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Mira_Ghaly

Value of Select corresponds to Get Items DTE
Mira Ghaly 11,415 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

@fgonzalez515

Please check the below approach to do the joins between your 2 lists

https://sharepains.com/2020/03/20/create-joins-in-power-automate/
fgonzalez515 296 on at

Like
a
(0)

Report
Copy link

Link copied!

@Mira_Ghaly
I was able to unite the two Odata, but my Compose 3 stayed within the Apply to each. How can I get it out?
How can I bring my Compose 3 to a Create Html Table?
I show you my flow
----------------------------------------------------------------------------------------------
Verified answer

Mira Ghaly 11,415 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@fgonzalez515

You need to initalize an array at the beginning and append to an array compose 3.
Verified answer

fgonzalez515 296 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @Mira_Ghaly