
Announcements
Hello, I have two tables in dataverse with a many to many relationship created and I want to filter the "Projects" to get only those ones where the current user email is related, I tried this two things
Hi @Giovanni2414g ,
What are result and error of your formula?
What is the type of AppUsers column?
Have you tried this?
Filter(
Projects,
'PM/TL'.EncorianEmail = User().Email||
User().Email in AppUsers.EncorianEmail
);
Best regards,
Rimmon