Relate() with a Gallery selected item

(0) Share

Report

Posted on by Community Power Pla...

Hey everyone,

Happy new year!

I am having an issue with the Relate() function and galleries. I have a "Demandes" table that has a one-to-many relation with a "Articles" table. In a collection "TempArticles", I have all the articles that I want to connect to a single Demande that is selected via a Gallery called "GalleryForms_1".

Here is the code:

ForAll(
 TempArticles As tempsarticle;
 Relate(
 GalleryForms_1.Selected.Articles;
 LookUp(
 Articles;
 Articles = tempsarticle.Articles
 )
 )
)

But this piece of code doesn't work properly... I figured the selection with the gallery doesn't pull the relationship correctly but didn't find any workaround on this (even by using a LookUp() on the "Demandes" table).

Thank you for helping me out with this issue. Have a nice day!

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-xiaochen-msft on at

Like (0)

Report
Hi @Anonymous ,

I did a test for you but I can't reproduce your problem. It worked.

TestL19S ----TestL20S (Many-----One)

Before:

Add a button control and set its Onselect property to:

ForAll( Col As A, Relate( Gallery1.Selected.TestL19S, LookUp( TestL19S, TestL19 = A.TestL19 ) ) ) //TestL19 is a guid column.

Select Skill1 record in gallery and click on the relate button.

After:

What did i miss?

Best Regards,

Wearsky

Was this reply helpful? Yes No