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

I have the same question (0)

All responses (6)

Answers (2)

Verified answer

fgonzalez515 296 on at

Like (0)

Report
Copy link

Link copied!

Thanks @Mira_Ghaly

Was this reply helpful? Yes No
Verified answer

Mira Ghaly 11,415 Moderator on at

Like (0)

Report
Copy link

Link copied!

@fgonzalez515

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

Was this reply helpful? Yes No
fgonzalez515 296 on at

Like (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
----------------------------------------------------------------------------------------------

Was this reply helpful? Yes No
Mira Ghaly 11,415 Moderator on at

Like (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/

Was this reply helpful? Yes No
fgonzalez515 296 on at

Like (0)

Report
Copy link

Link copied!

Hi @Mira_Ghaly

Value of Select corresponds to Get Items DTE

Was this reply helpful? Yes No
Mira Ghaly 11,415 Moderator on at

Like (0)

Report
Copy link

Link copied!

@fgonzalez515

Can you share how your lists are structured?

Was this reply helpful? Yes No