You might be getting unwanted tables in your solutions – here is one reason why

By | June 14, 2021

Have you ever noticed a table in your solution that you had never added there intentionally? It is kind of a stowaway table – you did not want it there, you did not authorize it to be there, you did not even notice it there until, of course, it was all in production… and, yet, there it is. Creating a nice managed layer in your production environment.

It’s extremely easy to get such tables in your solutions whenever you add a lookup field to another table. For example, below is an empty solution:

image

I would add “Opportunity” table, and I’ll do it so that no metadata/components from the opportunity entity will actually be added”:

image

Then I’ll add a lookup to the contact table:

image

And I’ll save my changes:

image

Back on the main solution screen, there are, now, two tables:

image

And, if you look at what’s been added to the solution for the contact, you’ll see everything there:

image

It’s easy to fix – just remove that extra table from the solution manually. It might have been better if it had not been added at all, so here is an idea you might want to upvote: https://powerusers.microsoft.com/t5/Power-Apps-Ideas/Do-not-add-referenced-table-to-the-solution-automatically-when/idi-p/953352#M33840

Leave a Reply

Your email address will not be published. Required fields are marked *