web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / CREATE NEW TABLE BY JO...
Power Automate
Unanswered

CREATE NEW TABLE BY JOINING COLUMNS

(0) ShareShare
ReportReport
Posted on by 296

Hello Community,


I have four Sharepoint Lists called "OC", "OBRAS", "PROVEEDOR" and "RECURSO"

fgonzalez515_0-1648267907160.png

 

How can I create this new table in HTML TABLE?

fgonzalez515_1-1648267936650.png

 

Categories:
I have the same question (0)
  • v-xiaochen-msft Profile Picture
    on at
    Re: CREATE NEW TABLE BY JOINING COLUMNS

    Hi @fgonzalez515 ,

     

    I did a sample for you.

    vxiaochenmsft_0-1648608501247.png

    vxiaochenmsft_1-1648608530200.png

    vxiaochenmsft_2-1648608634509.png

    vxiaochenmsft_3-1648608647232.png

    vxiaochenmsft_4-1648608659924.png

    vxiaochenmsft_5-1648608666733.png

    vxiaochenmsft_6-1648608673242.png

    vxiaochenmsft_7-1648608730304.png

    [
    "CodRecurso1",
    "CodRecurso2"
    ]

     

    vxiaochenmsft_8-1648608749552.png

    {
     "Proveedor": @{body('Filter_array')[0]['NombreObra']},
     "Recurso": @{body('Filter_array_3')[0]['NombreRecurso']},
     "Obra": @{body('Filter_array_2')[0]['NombreProveedor']},
     "Fecha": @{items('Apply_to_each')['Fecha']},
     "OC": @{items('Apply_to_each')['OC']}
    }

     

    vxiaochenmsft_9-1648608763591.png

    vxiaochenmsft_10-1648608785272.png

     

    Best Regards,

    Wearsky

  • fgonzalez515 Profile Picture
    296 on at
    Re: CREATE NEW TABLE BY JOINING COLUMNS

    @v-xiaochen-msft 

    Thanks for you help.

    I would like to ask for your help, for this last.

    How can I create my Html Table when I have empty items or no information?

     

    fgonzalez515_0-1648619188282.png

     

     

     

  • Verified answer
    v-xiaochen-msft Profile Picture
    on at
    Re: CREATE NEW TABLE BY JOINING COLUMNS

    Hi  @fgonzalez515  , 

    Firstly, please use 

    items('Apply_to_each')?[items('Apply_to_each_2')]
    instead of 
    items('Apply_to_each')[items('Apply_to_each_2')]
     
    Secondly , you could add if() function in append action.
     
    {
    "Proveedor": @{body('Filter_array')[0]['NombreObra']},
    "Recurso": @{if(not(empty(body('Filter_array_3'))), body('Filter_array_3')[0]['NombreRecurso'],'')},
    "Obra": @{body('Filter_array_2')[0]['NombreProveedor']},
    "Fecha": @{items('Apply_to_each')['Fecha']},
    "OC": @{items('Apply_to_each')['OC']}
    }

     vxiaochenmsft_1-1648624755164.png
    vxiaochenmsft_0-1648624733889.png
    vxiaochenmsft_3-1648624864226.png

     

     

    Best Regards,

    Wearsky

  • fgonzalez515 Profile Picture
    296 on at
    Re: CREATE NEW TABLE BY JOINING COLUMNS

    @v-xiaochen-msft 

    Thanks

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 497 Moderator

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 477 Super User 2025 Season 2

#3
chiaraalina Profile Picture

chiaraalina 242

Last 30 days Overall leaderboard