Merge two collections without unique key

[DiscoStu1985]

Hi all,

is it possible to merge two collections (without unique key) in Power Apps like following example I have created in MS Access (pls see attached screenshot)?

The idea is to have a new collection with all possible combinations of products and activities.

Thank you for feedback and support!

Malte

[v-siky-msft]

Hi @DiscoStu1985 ,

Could you please try this?

Put the code to Button OnSelect to trigger manually or OnStart of App. The Collection MyCol is what you want.

ForAll(tbl_Product, ForAll(tbl_Activity, Collect(MyCol, {Product: tbl_Product[@Product],Activity: tbl_Activity[@Activity})))

 Hope this helps.

Sik

[timl]

Hi @DiscoStu1985 

Here's a post that I made about how to do this without using ForAll. Perhaps that might help you.

https://powerusers.microsoft.com/t5/Building-Power-Apps/Adding-rows-from-one-table-to-another/m-p/50... 

[DiscoStu1985 · Accepted solution]

Hi @v-siky-msft / Hi @timl 

thank you both for your quick responses.

I have tried the solution of  @v-siky-msft and the code works perfectly.

ForAll(tbl_Product, ForAll(tbl_Activity, Collect(MyCol, {Product: tbl_Product[@Product],Activity: tbl_Activity[@Activity})))

Only a "]" after "[@Activtiy" was missing 😉

ForAll(tbl_Product, ForAll(tbl_Activity, Collect(MyCol, {Product: tbl_Product[@Product],Activity: tbl_Activity[@Activity]})))

Thank you and all the best,

Malte