Answered

Entity 'systemuser' With Id = Does Not Exist on Add Row in to Table

(0) Share

Report

Posted on by PattersonCA1

This is in a managed solution (production). This flow is meant to clean up some pieces after an update. The rest of the update has worked as expected.

I am getting this error message when trying to add a record to a table:

Entity 'systemuser' With Id = <GUID> Does Not Exist on Add Row in to Table.

I am not trying to do anything fancy, I am only making the value of the text upper case.

I have tried changing the connection reference to a new connection reference for the same account. I have tried deleting the step and recreating it. I deleted the ensuing unmanaged layer to ensure that wasn't the issue from the beginning. The account being used is the main (only) service account used to administer this solution.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (1)

PattersonCA1 75 on at

Like (0)

Report
Copy link

Link copied!

I have been able to determine that this is a permissions issue. But I am not sure why. This worked when I published from development (unmanaged) to stage (managed). This was approved and the same package was then published to production (managed). All 3 environments use the same exact service account, and it has System Administrator in all 3 locations. However, all tables that are new are not able to be edited by this admin account. They can be edited perfectly fine in stage, which should be exactly the same except for the data.

When I look at the solutions, the tables all appears as expected as managed within the solution. Any ideas what could cause this permissions disconnect?

Was this reply helpful? Yes No
Verified answer

PattersonCA1 75 on at

Like (1)

Report
Copy link

Link copied!

This was resolved. It was due to a business rule that was in place to change the owner of the record to the service account which had a different GUID between environments.

Was this reply helpful? Yes No