Hi there,
I have two entities having one-to-many relationships (Referential).
I want to make a gallery control for the header entity and then nest the 2nd gallery within that gallery and apply some filter rules to show records from the child entity only relevant to that item in the gallery 1.
PowerApps let me do it but it doesn't return/display any records for the 2nd gallery (even if I don't do any filtering). If I replace the Items property of the gallery 2 with a static array, such as ["1","2","3"], it shows these options.
I'm not sure where I have done wrong? Or PowerApps is not supporting it?
I'm running on 3.19094.22. Thanks in advance.
Yes you can use nested galleries. In the nested gallery items property your filter should look something like this. ID=ThisItem.ID
------------------------------------------------------------------------------OfficePowerUser.com------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members. If you thought this post was helpful, please give it a Thumbs Up.
Hi @BluRonnie ,
Based on the needs that you mentioned, I think the nested Gallery could achieve your needs.
I have made a test on my side, please consider take a try with the following workaround:
Set the Items property of the Outer Gallery (Gallery1) to following:
'Primary Entity' /* <-- Type your first Entity */
Within the Outer Gallery, add a nested Gallery (Gallery2), set the Items property to following:
Filter('Related Entity', LookUpField.'Unique Identifier Column' = ThisItem.'Unique Identifier Column')
Note: I assume that the 'Primary Entity' has a One-to-Many relationship to 'Related Entity'.
Please take a try with above solution, then check if the issue is solved.
Best regards,
Thanks for the reply. But I'm still not able to have it display anything in the nested gallery.
As you can see, my gallery 1 is used for parent entity (Transactions)
Gallery 1 Items
Gallery2 is a nested gallery for displaying the related entity (Transaction Notifications)
Gallery2 Items
The bottom part of the screen is the gallery5 which display the related entity (Transaction Notifications), as you can see, for the first records in both Gallery 1 and Gallery 5, there is a match between the GUIDs for Transaction and Transaction Noficiation's lookup field value. but the nested gallery still doesn't display any records. Not sure if it is to do with the delegation warning?
User | Count |
---|---|
196 | |
124 | |
87 | |
49 | |
42 |
User | Count |
---|---|
284 | |
163 | |
138 | |
75 | |
72 |