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):
Set(
varStoreSiteID,
LookUp(
'Site Members',
'User Mail' = profileMail,
SiteID.'Location Name'
)
);
after this, I have created a Filter on a Gallery:
Filter(Documents,
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
