Power Automate permissions to create item in SharePoint list

Question

I have an Instant Workflow with the following setting:

SharePoint

Run-only users will be asked to provide their own connection to this connector.

I have a 'Create Item' action in the workflow with a 'System Account' connection. The System Account has full access to the site.

When user account has edit access to list, the item gets created. When user access is changed to read on the list, the workflow errors with 'Access Denied'. I thought as the 'Create Item' action has the system account, this shouldn't be a problem and an item should have been created.

1. Why is this?

2. How can I get it to work without giving the user edit access?

Answer 1

As you are using Run-only users permissions for SharePoint connector, all actions with standard SharePoint connector will run with individual user permissions.

As users are having read permissions in SharePoint list, they cannot create new items in the list.

You can try either of below solutions:

1. Run all SharePoint connector actions using system account connection
2. Grant Contribute or higher permissions to users on the SharePoint list.

Contribute permissions are enough for creating / updating / deleting SharePoint list items.