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.
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
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>
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'.
WarrenBelz
637
Most Valuable Professional
stampcoin
570
Super User 2025 Season 2
Power Apps 1919
473