Breaking news from around the world
Get the Bing + MSN extension
Now Available in Community - MBAS 2019 Presentation Videos
Catch the most popular sessions on demand and learn how Dynamics 365, Power BI, Power Apps, Power Automate, and Excel are powering major transformations around the globe. | View Gallery
2019 release wave 2 Discover the latest updates and new features to Dynamics 365 planned through March 2020
Release overview guides and videos Release Plan | View virtual launch event
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Talent TechTalks | Upcoming TechTalks
I have a custom entity which is linked to itself with 1:N
After I have created a record in this entity, I want to link it with it self, but I can only find other records then this one in the lookup field.
Is this a bug ?
You should be able to refer same record in a lookup field of same record type. Do you have any dependent Lookup filter on lookup field ? Also i have seen this issue with customer lookup field where it does not allow you to choose same record. But this should work for all custom lookup field you have in the entity.
actually I have not set any settings on the lookup field. also no lookup filter.
Try to do it with an async workflow.
can you copy past record name in the lookup field and see whether that resolve the record or not? I had same requirement in the past it worked without any issue. Also i just tested this to verify and it works fine as you can see iin screen shot. Do you have custom view to set on the lookup if show check the filter criteria in that view that may be restricting to select same record in a lookup.
I have tried a different thing:
Created a record A and record B
Linked record B to record A as parent
now If I try to link record A to record B as parent, it says:
This lookup creates a parental relationship between records and you attempted to link this record to itself. This is not allowed because it would create a circular reference. You can link this record to other records of the same type, but not the same record.
You should be able to do it if the Type of Behaviour on the Relationship that has been created when you created the lookup is set to Referential.
I have tried it, but still no success.
The below was a simple test (2015 Update 1). There's a 1:N with itself, the record 'Test 1' has the Lookup set to itself. If the relationship is set to Parental (I suspect it would be the same if any of the Actions were set to Cascade), it will give an error.
Is also working for the scenario where record A has parent set to B, and B has parent set to A.
While I can get the record to link to itself, I think it is an intermittent bug. I am getting there by typing the Parent in to the lookup (and sometimes I am getting a red x).
so you do also think, that this is a bug ?
No, I think it is probably by design (possibly to do with the hierarchy charts).
I think that doesnt make sense, since hierarchy chart is optional and should be set on the hierarchy settings
See the "Self-referencing one-to-many entity relationships" section in following
This says it is meant to apply to "Parental" relationships. However, they appear to have applied some filtering to the lookup that is removing the record from those available even for those relationships that have been explicitly defined as non-parental.
I couldnt even link the record with itself with a sync / async workflow.
Still the same error message:
Unfortunately, I still dont have any further progress on working with this issue. Anybody help ?
Business Applications communities