Skip to main content

Notifications

Power Automate - Building Flows
Answered

CREATE HTML TABLE WITH TWO ODATA

(0) ShareShare
ReportReport
Posted on by 292

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

  • Verified answer
    fgonzalez515 Profile Picture
    fgonzalez515 292 on at
    Re: CREATE HTML TABLE WITH TWO ODATA

    Thanks @Mira_Ghaly 

  • Verified answer
    Mira Ghaly Profile Picture
    Mira Ghaly 11,409 on at
    Re: CREATE HTML TABLE WITH TWO ODATA

    @fgonzalez515

     

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

     

  • fgonzalez515 Profile Picture
    fgonzalez515 292 on at
    Re: CREATE HTML TABLE WITH TWO ODATA

    @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

    fgonzalez515_0-1626497664683.png

    ----------------------------------------------------------------------------------------------

     

    fgonzalez515_1-1626497708105.png

     

     

  • Mira Ghaly Profile Picture
    Mira Ghaly 11,409 on at
    Re: CREATE HTML TABLE WITH TWO ODATA

    @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 Profile Picture
    fgonzalez515 292 on at
    Re: CREATE HTML TABLE WITH TWO ODATA

    Hi @Mira_Ghaly 

    fgonzalez515_0-1626479549003.png

     

     

    fgonzalez515_1-1626479584062.png

     

    Value of Select corresponds to Get Items DTE

  • Mira Ghaly Profile Picture
    Mira Ghaly 11,409 on at
    Re: CREATE HTML TABLE WITH TWO ODATA

    @fgonzalez515 

    Can you share how your lists are structured?

     

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,580

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,909

Leaderboard