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
Solved! Go to 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
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
Here's a post that I made about how to do this without using ForAll. Perhaps that might help you.
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
User | Count |
---|---|
198 | |
105 | |
88 | |
45 | |
43 |
User | Count |
---|---|
245 | |
105 | |
103 | |
65 | |
60 |