Announcements
I have 2 SharePoint list
List1
================
User email
CustomID
Details
List2
===============\
Column1
Column2
Column3
Now if the logged in user().email found in list1 user email field take the customID column value and lookup in List2 and display those in PowerApps gallery
Hello @jayakumark ,try this
Set(VarID, LookUp(List1, 'User email'=User().Email, ColumnID));Filter(List2,ColumnID=VarID)
Please accept as a solution if it works for you.
This is half way working(returning only 1 line in gallery) as the first lookup returning array values i mean multiple customID matching to the user().email ,so we need to filter an array of values.
Oh okay,
ClearCollect(ColID,Filter(List1,'User email'=User().Email).ColumnID); ForAll(ColID,Filter(List2,ColID in ColumnID))
Let me know how it goes...
Thanks,
How can i use this filter in gallery?i couldnt validate as the source is showing as collection now.
ForAll(ColID,Filter(List2,ColID in ColumnID))
Hi @jayakumark ,
Try this as the Gallery Items
With( { wUser: Filter( List1, 'User email' = User().Email, ) }, Ungroup( ForAll( wUser As aUser, Filter( List2, CustomID = aUser.CustomID ) ), "Value" ) )
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Visit my blog Practical Power Apps
Wow. It worked. Thanks A lot
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Haque 85
WarrenBelz 76 Most Valuable Professional
Kalathiya 38 Super User 2026 Season 1
