web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps The specified column i...

Power Apps

Unanswered

The specified column is not accessible in this context

(0) Share

Report

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 Img

All responses (1)

Answers Img

Answers (0)

v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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

Join the conversation