Microsoft365 Update List Item Activity

Hi,
I had issue with updating SharePoint list items in a loop.I got error for the activity. So, I thought of trying to update the list item without actually changing anything in it. I just kept " Update List Item" activity inside my For each List Item activity (below image). But still I get “Invalid Request” Error for Update List Item activity.
The App ID i use have Write Access to the site. Then what else could be the issue? Even a direct “Update List” Item inside a loop also isn’t working.

@besakkiappan46

looks like the user from which you are trying to update does not have…ideally even in azure app we control access via users

also to update list you need specific set of permissions in azure app

site level permissions are needed

cheers

I’m not using the user details anywhere. Under the scope, I use AppID,secret and tenant ID.
I try to access the List using APIs only. So what User access you mention here?
However, The Bot ID also has edit access to the Site.

@besakkiappan46

In the axure app site level scopes are provided?

Cheers

The Azure app is being handled by a different team.
I contacted the person to enable Write Access to the SharePoint Site. Earlier, I was getting Access denied issue. But once he Provided Write Access to App ID, I was able to get Items from list. Only Update List item is causing issue here.

So, Can you please tell me What exactly I need to check with him in Azure App?

@besakkiappan46

As per above provided screenshot check if those site level read or write access is also given

You can check office365 setup page as well in UiPath docs

Cheers

Actually, The Site was earlier not part of the App ID. He added the SharePoint Site and Provided ReadWrite Access to it. He also provided “full control” access to the site. Still it didn’t work.

@besakkiappan46

If possible ask him to provide a screenshot of the permissions page we can validate

Cheers

he could give me only this. Could we decipher anything from this?
image

@besakkiappan46,

This Sites.Selected decipher to that, whatever sites user have access provided by admins of those sites, will be available as is.

The available roles are which admin can provide:

Role Name Meaning
read Read-only
write Adds Write and related bits
manage Adds Manage Lists / Designer and related bits
fullcontrol All permissions

You can check if the bot’s id have the respective sites access or not and if it’s there, what’s level or type of access it have. So it’s no more Active directory application level access. It’s user specific access.

Thanks,
Ashok :slight_smile:

@besakkiappan46

Can he provide site.write.all

Or the user used from the robot should be having the required access

Cheers