Hi everyone,
I am a complete newbie in Dataverse and excited to be sinking my teeth in.
I have looked around a fair bit for a security solution and just haven't been able to find an answer. Hope you can help.
I have two tables one is a list of users and the second is a list of records.
In the user table, it includes their email, name, and location code. Some users will have multiple location codes.
In the second table, the location code is included with other info, you would find for sales.
What I need is the security filter to only show information in table two based on the location codes in table one.
Any help would be fantastic, if someone is aware of a video going through the process even better.