You’re offline. This is a read only version of the page.
2
it's possible to compare the items between two galleries and display them if the Site label has the same value. Here’s a basic way to achieve this in Power Apps:
Assume two galleries, Gallery1 and Gallery2, are linked to two different data sources. Each gallery has a text label showing the Site label.
Add a label to your screen where you want to display the matching Site labels.
Use a formula to compare the items in the two galleries. Here's an example of how you can do it:
Share
Report
All responses (
Answers (
ForAll(Gallery1.AllItems,
If(
!IsBlank(
LookUp(Gallery2.AllItems, SiteLabel = ThisRecord.SiteLabel)
),
Concat(ThisRecord.SiteLabel, Text(ThisRecord.SiteLabel) & ", ")
)
)
ForAll(Gallery1.AllItems, ...): Loops through all the items in Gallery1.LookUp(Gallery2.AllItems, SiteLabel = ThisRecord.SiteLabel): Searches for the item in Gallery2 where the Site label matches the current item in Gallery1.Concat: Combines all the matching Site labels from the galleries.ThisRecord.SiteLabel: Refers to the Site label in the current record of Gallery1.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
