Fulfilling Requests Through Power Automate ServiceNow Connector

[CheeryFrog143]

I have been tasked with creating an automation using Power Automate to perform actions when certain requests are made in ServiceNow.  I'm not a ServiceNow admin and, unfortunately, our admin is not much help as the system was set up by consultants who are no longer contracted to us, so I'm kind of on my own.

I am able to successfully set up a connection to our dev instance and I can use the connector to query tables, but I'm having a terrible time getting all the information I need.  Hopefully someone can point me in the right direction.  Here are the steps that I need to perform.  So far, I've only been able to complete the first one.

1. Get a list of open catalog tasks with a specific description, assigned to a specific group but not assigned to anyone.
2. Iterate through the list of tasks.  For each task, Power Automate needs to:
3. Assign the task to itself.
4. Get the details (variables) of the task.  I've looked in the task, RITM and Request tables, but can't find them.
5. Pass those variables to the Power Automate Desktop flow to do the work.
6. Update the task as needed.
7. Close out the task and request.

If someone could please help me understand how the tables are related to each other, as I will need to update them directly.  Again, these are for requests, not incidents (almost every example out there is for incidents).

[KhushbooR]

Hello @CheeryFrog143 ,

I am facing same error. I don't want to give admin access to pw user.

[John Gilmore]

It sounds like you potentially have UI policies that are overriding dictionary/acl level write permissions. To resolve the API issue you will need to make sure the account using the API has acl write permissions if you aren't able to assign the account a role that gives them access.

This will require manual review of the write operation rules for each table/field it needs to update. You can do this by navigating to System Security > Access Control (ACL) and then using a name contains filter for the table (Name contains sc_task). This will filter the ACL list so that rules applying to that table are at the top. Any rule with starting with the table name is controlling access to the table (sc_task would be table level, sc_tash.* would be record level, sc_task.<field_name> is field level).

For the API to allow updating of a field the account must have access at the most granular level applied for the table. So if there is a field write ACL for the field it needs to update then it must have write permissions at the table, record, and that specific field level or any update request will be rejected. You will need to review ACLs and add the user as necessary for every table and potentially field you want to update via the API from Power Automate.