cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
xilef
Level: Powered On

Cannot add Many-to-Many relationship to 'SystemUser' entity

The following error occured when I was trying to connect a custom entity with the 'SystemUser' entity:

 

The entity could not be updated: Entity systemuser cannot be in a custom entity association.

 

Any suggestion?

 

Thanks.


Accepted Solutions
Community Support Team Rank
Community Support Team

Re: Cannot add Many-to-Many relationship to 'SystemUser' entity

Hi @xilef,

I have made a test, and the issue is confirmed on my side.

It seems that the CDS in PowerApps recognize the Task Entity (Standard/System Entity) as a custom Entity rather than a System Entity when creating a Many-to-Many relationship.

When I created a Many-to-Many relationship between "System User" Entity and "Account" Entity (Standard Entity), it works well.

If you want to get further help in this issue, please consider take a try to submit an assisted support ticket through the following link:

https://powerapps.microsoft.com/en-us/support/pro/

 

Best regards,

Kris

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

All Replies
xilef
Level: Powered On

Re: Cannot add Many-to-Many relationship to 'SystemUser' entity

Sorry, it it not between a system entity and a custom entity, it it between two system entity I can not have n:n relationship. The two system entities are: 'Task' and 'SystemUser'.

xilef
Level: Powered On

Re: Cannot add Many-to-Many relationship to 'SystemUser' entity

The following occured when I tried to add the relationship on 'SystemUser' side:

Unhandled exception: 
Exception type: System.ServiceModel.FaultException`1[Microsoft.Xrm.Sdk.OrganizationServiceFault]
Message: Entity systemuser cannot be in a custom entity associationDetail: 
<OrganizationServiceFault xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.microsoft.com/xrm/2011/Contracts">
  <ActivityId>7aa69045-e522-43ef-a0be-81cb6cb7789d</ActivityId>
  <ErrorCode>-2147204302</ErrorCode>
  <ErrorDetails xmlns:d2p1="http://schemas.datacontract.org/2004/07/System.Collections.Generic" />
  <Message>Entity systemuser cannot be in a custom entity association</Message>
  <Timestamp>2018-12-29T08:51:37.2157235Z</Timestamp>
  <ExceptionRetriable>false</ExceptionRetriable>
  <ExceptionSource i:nil="true" />
  <InnerFault i:nil="true" />
  <OriginalException i:nil="true" />
  <TraceText i:nil="true" />
</OrganizationServiceFault>

 

Community Support Team Rank
Community Support Team

Re: Cannot add Many-to-Many relationship to 'SystemUser' entity

Hi @xilef,

I have made a test, and the issue is confirmed on my side.

It seems that the CDS in PowerApps recognize the Task Entity (Standard/System Entity) as a custom Entity rather than a System Entity when creating a Many-to-Many relationship.

When I created a Many-to-Many relationship between "System User" Entity and "Account" Entity (Standard Entity), it works well.

If you want to get further help in this issue, please consider take a try to submit an assisted support ticket through the following link:

https://powerapps.microsoft.com/en-us/support/pro/

 

Best regards,

Kris

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.