You’re offline. This is a read only version of the page.
58
I have a custom Choice column used on a few tables, which needs to be removed (not used)
On every table I have removed the column/field from all views and forms.
However when I try to delete the column, I cannot due to a relationship dependency. Although no dependent table is displayed.
Why would a relationship depend on a Choice column? And how to resolve in order to delete the column?
In my case there is a choice field called Fund which is the no longer required (a Fund is a pool of funding which has a particular focus).
A choice field Fund has been added to on two tables
The Allocations Table also has a lookup column for selecting the relevant Project which has created a relationship (each allocation is for one project and one project can have many allocations).
When I try to delete the Fund choice field from the Allocations table the dependency lists the 'project' entity relationship although no dependent table is shown - see clip below
If I view the above relationship under the Relationships screen, it is named 'Projects' so I am concerned that deleting this relationship will delete the required lookup and relationship with the Projects table.
Similarly when I try to delete the Fund choice field from the Projects table a dependent relationship is also shown as preventing the delete - see clip below:
The wierd part is why would a choice column have a dependent entity relationship?
Thank you Gulshan! (😀 whilst having toast!)
So grateful to all the folk who regularly contribute - ya'all rock!!
Thanks Wendy.
Apologies for a short reply earlier as I was getting ready for work and was accessing the forum on mobile whilst having my toast. I'm sorry I didn't explain that the magic happens in classic designer but I'm glad you managed to figure that out. It is indeed a pain that the modern designer doesn't give clarity and doesn't allow us to go directly to the dependencies. There was an idea submitted on idea forum some time ago regarding this and I posted on my LinkedIn asking people to upvote that idea. Please add your vote too. Here's the link to that:
https://ideas.powerapps.com/d365community/idea/5239bf30-53c8-42b8-aea6-c1185938c429
Thanks.
Gulshan
Thank you so much for your prompt reply. I am not sure where you can find (or how to create) the field mapping for a relationship in the Modern View but that is exactly what the issue was!
Thanks to @Z_Lukowski I figured this out from his reply to the following post: Can't delete a table. Where did these relationship... - Power Platform Community (microsoft.com)
So I followed his instructions as follows and used the Classics View:
1) On Top Left part of the screen Click the cog Icon
2) Advanced Settings
3) Customization Column -> Solutions (assuming youve already pulled your table into ANY solution
4) Click on your solution
5) Find your Table (it will be called Entity)
Then I found the column to delete and when I received the error message I clicked on the links provided in the error message to see dependent relationship. In the Classic view you can now click on the relationship (cannot in Modern View) and then view the field mappings which did indeed include the Fund choice field.
Thank you so much to all the contributors to this platform who have helped resolve MANY issues for me 🙂
Please check in the entity relationships if there is any field mapping that exists involving Fund.
#1
WarrenBelz
146,618
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,962
Most Valuable Professional
Share
Report
All responses (
Answers (
