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

Community site session details

Session Id : 4fhN3Ju3hMHGD8rNwfoZCh
Power Apps - Microsoft Dataverse
Answered

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

Like (0) ShareShare
ReportReport
Posted on 29 Dec 2018 08:38:22 by 60

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.

  • Verified answer
    v-xida-msft Profile Picture
    on 01 Jan 2019 at 02:16:39
    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

  • xilef Profile Picture
    60 on 29 Dec 2018 at 08:53:30
    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>

     

  • xilef Profile Picture
    60 on 29 Dec 2018 at 08:40:46
    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'.

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

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 637 Most Valuable Professional

#2
stampcoin Profile Picture

stampcoin 570 Super User 2025 Season 2

#3
Power Apps 1919 Profile Picture

Power Apps 1919 473

Featured topics

Loading complete