Unanswered

How to get all registered items of a user in sharepoint with Power Automate

(0) Share

Report

Posted on by jENNYg112

Hola, estoy construyendo un flujo donde tengo dos listas, una de USUARIOS y VENTAS. Ambas tienen un ID en común con el usuario pero quiero unir estas dos listas y obtener el nombre y todas las ventas registradas en una tabla html.

Algo como esto

.........................................

Nombre

........................................

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

Gracias por tu ayuda

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

Sort by

v-yetonggu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @jENNYg112 ,

Do you want to merge the 'Name' column in the USER list and the 'Sale' column in the SALES list into one html table with the same user ID?

If so,I did a test for your reference.

In my scenario:

HTML Table：

My USERS List:

My SALES List:

My Flow:

item()?['ID'] item()?['Name'] item()?['Sale'] body('Select_2') body('Select') item()?['ID'] items('Apply_to_each')?['ID'] item()?['Name'] { "Name":@{replace(replace(replace(variables('String'),'"',''),'[',''),']','')}, "Sale":@{items('Apply_to_each')?['Sale']} }

Note that if your column names are different from the column names in my test, please change the column names in the expression when you quote it.

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
jENNYg112 4 on at

Like (0)

Report
Copy link

Link copied!

Hi
I have a question, if each USER has more than two sales, is this also listed?
What can I do in that case?
Thank you very much for your help 😁

Was this reply helpful? Yes No
v-yetonggu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @jENNYg112 ,

Could you please post screenshots of your USERS and SALES lists?

This will help me better understand what you mean and help you solve the problem.

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
jENNYg112 4 on at

Like (0)

Report
Copy link

Link copied!

Sure, thanks for your help

Was this reply helpful? Yes No
v-yetonggu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @jENNYg112 ,

I did a test again.

Please check this test.

My USERS List:

My SALES List:

The Result:

My Flow:

item()?['IDUser'] item()?['Name']

item()?['IDS'] item()?['Sale'] body('Select_2') body('Select') item()?['IDUser'] tems('Apply_to_each')?['IDS'] item()?['Name']

body('Filter_array') { "Name":@{replace(replace(replace(variables('String'),'"',''),'[',''),']','')}, "Sale":@{items('Apply_to_each')?['Sale']} }

item()?['Name'] union(body('Select_4'),body('Select_4'))

outputs('Compose') item()?['Name'] items('Apply_to_each_2') { "Name":@{items('Apply_to_each_2')}, "Sale":@{body('Join')} }

Best Regards,

Sunshine Gu

If I solve your problem, please mark my reply as a solution so that I can help more people in the future.

Was this reply helpful? Yes No