Lookup between two SharePoint lists and filter Powerapps gallery

[Syndicate_Admin]

Hi All, 

I have two separate SharePoint lists 'GI_Deployemt Data' and 'App_Contacts_Focals'. 

Gallery items in 'GI_Deployemt Data' need to be filtered as per the persons area from 'App_Contacts_Focals'. 

App_Contacts column is a Person type column with multiple selection field. I'm not sure how to filter items based on App Contacts using CurrentUser email and for those Domain (Title column). 

SharePoint List 

[v-jingzhang]

Hi 

This is out of the scope of Power Query. You may go to Building Power Apps - Power Platform Community 

to seek for professional suggestions about this problem. 

Best Regards,
Community Support Team _ Jing