I have a Power Page where I want every list to be filtered to only show records associated with the logged in user. The user is external to my organisation and is authenticated using Microsoft Entra on a B2B basis, and not Microsoft Entra External ID.
The user is in the Contacts table and I have a lookup column in each table that is the basis of the list. For example the goals table has a lookup column called "Contact" that has a m:1 relationship with the Contact table. The user can see their name at the top of the website showing they are logged in.
However, when I change the permissions for the list to Contact from Global Access the user cannot see anything.
Can I configure row-level access in this way given I'm not using Microsoft Entra External ID? If so, what am I doing wrong?