Power Platform Community Forum Thread Details

Edited to add: It seems that overnight, after I posted this, Issue ID 6315394: System Administrator cannot access custom table in multi-Business Unit environment was created which seems to acknowledge this issue and offer some other workarounds.

I just had a very odd experience and am wondering if anyone else has experienced the same or has any advice on a possible solution.

I needed to make a few throwaway tables to use for testing, so I went to a sandbox environment and made a new solution.
I used the new Copilot-based table designer (New > Table > Tables) and gave it a basic prompt to get it to make 3 tables with relationships between them.
It made the tables as I expected, so I verified there were the normal 5 rows of 'test' data in them and clicked Save.
Once the tables were saved, I opened one up to edit the choices for Status Reason, which can't be done in the Copilot editor.

At this point, I noticed the below message when I tried to look at the table data:

Screenshot of Error Message saying "You don't have permission to view this data"

The problem here is that I have the System Administrator role in this environment, so I pretty much never should see that, especially on a newly-created table without any field level security profiles.

Sure enough, when I go into PPAC and check the grants for System Administrator in this environment, this table does not have any grants (permissions are set to 'None' for all three of the new tables I made with the Copilot designer). I also can't change the grants of the System Administrator role, which is honestly not something I had ever tried before today at any rate.

Screenshot of the System Administrator table privileges for the tables in question

No other environment I checked had any tables which show under the "Show Only Unassigned Tables" filter, which is expected behavior as System Admin should get granted all of them by default.

I think I ran into a bug where the Copilot table creation did not correctly add the grants to System Admin. Obviously I can just remake the tables manually, or create and assign myself a security role to grant the data, but both of those are workarounds and not a solution to the actual issue at hand.

Anyone else seen this, or have an alternative theory on what happened?

Categories:

Microsoft Dataverse with Power Apps