Showing results for 
Search instead for 
Did you mean: 
Resolver I
Resolver I

Filter and LookUp gives me a runtime error

Hello all experts!


I have two different Tables in dataverse respectively called Document and Site Members

These two tables have a relationship with a LookUp type called SiteID (SiteID stems from another table called Site).

So, Document table has a column called SiteID and Site Member table has a column called SiteID. 

- Document table have all the relevant document's that I wanna visualize in a Gallery,

- Site Member table have information of the logged in user such as email address

- Site table have a SiteID that have a relationship with both Documents and Site Members


What I'm trying to accomplish is to filter a Gallery based on your SiteID and show all records in Document that have the same SiteID as the Site Member.


In plain English, look into the current logged in users SiteID and  find me all the documents from the table Documents that have the same SiteID.


What I have done until now is to create a LookUp where I'm basically trying to identify the user (this is on App = OnStart property):



        'Site Members',
        'User Mail' = profileMail,
        SiteID.'Location Name'


after this, I have created a Filter on a Gallery:


    varStoreSiteID = SiteID.'Location Name'



This throws me a runtime error with: The left side of the 'Equal' operator must be a property of the entity.


Can anyone tell me what I'm doing wrong or even better, is there a better solution than what I have done in my Table structure? 


Please note, profileMail is a global variable of the users Email address


Accepted Solutions
Resolver I
Resolver I

I don't have any explanation of why, but it suddenly stopped giving me any runtime errors, so now it works....

View solution in original post

Super User
Super User


If you reverse the conditional part of your call to Filter so that it looks like this, does that make a difference?

       SiteID.'Location Name' = varStoreSiteID


@timl I did try that based on an other post, but that didn't help unfortunately 

Resolver I
Resolver I

I don't have any explanation of why, but it suddenly stopped giving me any runtime errors, so now it works....

Helpful resources

Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,398)