The specified column is not accessible in this context

(0) Share

Report

Posted on by Giovanni2414g

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

Filter(

Projects,

'PM/TL'.EncorianEmail = User().Email||

User().Email in Projects.AppUsers.EncorianEmail

);

And..

ForAll(

Projects,

User().Email in ThisRecord.AppUsers.EncorianEmail

)

How can I perform that filter?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (1)

Answers (0)

v-mengmli-msft on at

Like (0)

Report
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

Was this reply helpful? Yes No