web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Email with apostrophe ...
Power Apps
Answered

Email with apostrophe - cannot access Dataverse "The user is not a member of the organization"

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi all,

 

I am having a problem where a specific user cannot access Dataverse tables using Power Apps.

 

The error they are having is as follows:

"You don't have permission to view this data. Server response: <table> failed. The user is not a member of the organization".

 

The user has permission to access the table however the only difference from other users is that they have an apostrophe in their email address. From the wording of the error could this be an issue with how the data is being queried through the app? the issue appears to be triggered by a simple Filter function.

 

I was wondering if anyone has experienced this error and was able to resolve this.

 

Many thanks!

I have the same question (0)
  • Verified answer
    ChrisPiasecki Profile Picture
    6,424 Most Valuable Professional on at

    Hi @Anonymous,

     

    While I can't be certain that it's the root cause, it is recommended to remove special characters including an apostrophe from the user's mail or proxyaddress attribute in your organization's on-premise Active directory as it can cause issues across M365 and related services.

     

    More info: https://docs.microsoft.com/en-US/office365/troubleshoot/active-directory/email-address-contain-underscore  

     

    Additionally, can you confirm the user is assigned a security group that has access to the table in question?

     

    ---
    Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 514

#2
WarrenBelz Profile Picture

WarrenBelz 419 Most Valuable Professional

#3
Valantis Profile Picture

Valantis 295

Last 30 days Overall leaderboard