CREATE NEW TABLE BY JOINING COLUMNS

(0) Share

Report

Posted on by fgonzalez515

296

Hello Community,

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

How can I create this new table in HTML TABLE?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

v-xiaochen-msft on at

Like (0)

Report
Re: CREATE NEW TABLE BY JOINING COLUMNS

Hi @fgonzalez515 ,

I did a sample for you.

[
"CodRecurso1",
"CodRecurso2"
]

{ "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']} }

Best Regards,

Wearsky

Was this reply helpful? Yes No
fgonzalez515 296 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Verified answer

v-xiaochen-msft on at

Like (0)

Report

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']}
}

Best Regards,

Wearsky

Was this reply helpful? Yes No
fgonzalez515 296 on at

Like (0)

Report

Re: CREATE NEW TABLE BY JOINING COLUMNS

@v-xiaochen-msft
Thanks

Was this reply helpful? Yes No