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

(0) Share

Report

Posted on by Community Power Pla...

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!

Categories:

Microsoft Dataverse

All responses (1)

Answers (1)

Verified answer

ChrisPiasecki 6,389 Most Valuable Professional on at

Like (1)

Report

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

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.