Filtering List items from one collection using values in an array from another collection

Hi community,

Need help again

I have created a listview of people from the collections called ‘Calendar’ by generating children with the variable friendsattending which has the list of all people that have registered to attend the event ( Shown below).

I want to filter the list so that logged-in users only see their friends by comparing the email of friends of the logged-in users vs the email of all users registered for the event using the fieldname ‘friends’ in the user’s collection – which is an array of the list of friends for each user. This field name has a data type made up of the image, display_name, and email fields

Not sure how to go about achieving this as everything I have tried do so far isn’t working. Any help/guidance will be appreciated.

Thanks.