Microsoft 365 Activities - Update SharePoint List

Help Studio
, ,
1

Hi,
I’m trying to update list items from a Sharepoint list. I’m using Microsoft Office365 - Classic activities. I could see few activities related to SharePoint List. I used “get List Info” activity to get those Items and then used “Update List item”. But I get error “An Error occurred while sending the request” in “get List Info” activity.

So, What is the best approach to update list Items in SharePoint? Why I’m getting the above error for that activity. I used App ID,secret and Tenant ID provided by my organization under the Microsoft 365 Scope and all the SharePoint related activities are under the scope. Also, The Account has access to that URL as well.

Thanks in advance

2

@besakkiappan46

in the microsoft scope activity did you select the service?

Also better expand the locals panel and check

cheers

3

This is how my property looks like @Anil_G . I provided the App id,secret and tenant ID, selected the Authentication type. Also, it allowed only hard coded values in the IDs.

image
image275×846 25 KB

4

@besakkiappan46

may I know the version…you should be seeing this

image

also can you share exception details from locals panel?

cheers

5

I used 2.6.21 version of Microsoft365. I don’t see Services option in it. Also, I used Authentication type as “Application ID and Secret” .

I get “Access Denied” Error under “get List Info” activity now. Although my bot ID has access to that URL

6

@besakkiappan46

the permissions needs to be given in the azure app where you got the appid and secret

these are permissions required

image
image536×685 11.2 KB

and I hope permissions are not delegated

also try to fill the account name if they are delegated…as per error it is clear that the api access is missing from azure app

cheers

7

Thanks @Anil_G I’ll check and get back the access in Azure AD. I’ll keep this issue Open until then.

1 Like
8

The issue was with the Access to the SharePoint. Write Access was not available for this SharePoint site in Azure AD. Thanks @Anil_G

1 Like
9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.