Solved: Table View Related Tables

Table View Related Tables

We have 10 custom tables. Some of these tables have up to 4 many-to-1 Lookup columns with each other. I have been adding Related table fields to some of these table's views. I have now encountered tables with views (editing) that do not list all the related tables, so I cannot add the related table fields to the view, even though the table lists the relationships. No table is close to the limit of 10 related table references (per table). These same tables do have fields referenced in other table's views. It is like I hit some limit based on number, not a table. I exported the solution and imported it into a different environment; same problem. No errors encountered. The only thing in the solution besides the tables are 4 Choices and a model driven app including all tables and no customizations (create only). This appears to be strictly a Dataverse issue.

Does anyone know why this might be occurring?

Thanks.

Categories:

Microsoft Dataverse

Tables

Found the problem. After hours of trying to determined what I might have done wrong, I deleted the Lookup column in the Dataverse table that was not appearing in the pick list and then created it again (exactly the same), and it now appears as expected. It appears something went wrong during the creation of the column/field, though no error was reported and the solution verified all MS tests (solution export process). My guess is that the process involves asynchronous methods and something failed but everything else continued independently. It appears that it did this 3 more times (3 other columns) on another table. The error is captured in an export file and appears when imported, but is not repeatable by recreating the tables from scratch.

The moral of this story is that Power Apps appears to be half-baked software, so don't expect it to work every time the same way. Power Apps may be reliable at some time in the future, not that I will hold my breath, but if something doesn't seem to be right, delete it and do it again. This is one of those times where doing the same thing and expecting a different result is not insane, it is a real possible solution.

I guess I didn't see that one coming. I thought that columns get created the same way every time. How crazy is that?

Quick Links

Subscribe to this forum!