topic RE: Microsoft Graph - SharePoint VBO Challenges in Digital Exchange

Microsoft Graph - SharePoint VBO Challenges

Kamal2017 — Thu, 03 Feb 2022 10:14:00 GMT

Hi Team,

I am looking for your help on Microsoft Graph - Sharepoint connector web API - action 'Update List Item Column Value'. I am able to run this successfully with request payload in json format as per the ask. However it looks that it doesn't update the new value/s.

I tried it multiple times with success but the response recieved from that call still holding the old value/s.

Anyone know if this action really works or I am doing something incorrectly ?

------------------------------
Kamal Ahmed RPA Developer
Sr. Programming Analyst
BNY Mellon
Asia/Kolkata
------------------------------

RE: Microsoft Graph - SharePoint VBO Challenges

ewilson — Thu, 03 Feb 2022 13:06:00 GMT

@Kamal2017,

This seems to work for me on my test SharePoint site. One thing you might want to check is the properties of the field (aka Column) you're trying to update. They can be marked as read-only. They can also have an associated calculation that must be met for things to work properly. Not sure if these apply to your specific case, but you should verify.

In my case, I added a Single Text Line column, named Test Column, to an existing list of documents as pictured below:
After that, I used the Graph action to update the value of the column on the item Test1.xlsx to set the value to This is a test as shown below:

And this is the JSON I used:

{
    "TestColumn": "This is a test"
}

Please note, the name you use to reference the column in the JSON, is NOT the displayName (i.e. the displayed name of the column). It's the name (i.e. internal name). You can find the name of the column by enumerating the list's columns. We don't have an action in the connector for that, but you can add one easy enough. Just copy the Get List by List ID action and add /columns to the end of the URL Path:

/sites/[Site ID]/lists/[List ID]/columns

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

RE: Microsoft Graph - SharePoint VBO Challenges

Kamal2017 — Thu, 03 Feb 2022 14:31:00 GMT

Hi Eric,

Thanks for your response. I think i got few things from your suggestion and probably will try doing this.

Just a small update, I am trying to update a column value in a list (Table) and this is the json i am trying to use:
JSON (Request Payload) = {"@fields":{"Title":"Test"}}
Table: List with multiple columns - 30+ columns
Field Name: It looks to be same on the list as well as collection i got from action 'Get Items in List by Fields' (attached for ref.)

------------------------------
Kamal Ahmed RPA Developer
Sr. Programming Analyst
BNY Mellon
Asia/Kolkata
------------------------------

RE: Microsoft Graph - SharePoint VBO Challenges

Kamal2017 — Mon, 07 Mar 2022 09:03:00 GMT

Hi Eric,
@ewilson

Looking for your assistance on the above issue with MS Graph API for updating field/s on a list/table in SharePoint online.

------------------------------
Kamal Ahmed RPA Developer
Sr. Programming Analyst
BNY Mellon
Asia/Kolkata
------------------------------

RE: Microsoft Graph - SharePoint VBO Challenges

ewilson — Mon, 07 Mar 2022 15:00:00 GMT

Hi @Kamal2017,

Can you update me on your latest status? There were some suggestions I made that you were going to try. I take it they didn't help you move forward?

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

RE: Microsoft Graph - SharePoint VBO Challenges

Kamal2017 — Mon, 07 Mar 2022 15:28:00 GMT

Hi @ewilson,

Yes, you are right, i think i missed to post that updates. I am able to make this action call working with correct json and getting the success result however it is not reflecting the update on field/s made on the SharePoint. So, was wondering if this action really works or I am doing something wrong.

Attached is the action details.

------------------------------
Kamal Ahmed RPA Developer
Sr. Programming Analyst
BNY Mellon
Asia/Kolkata
------------------------------

RE: Microsoft Graph - SharePoint VBO Challenges

ewilson — Tue, 08 Mar 2022 01:54:00 GMT

@Kamal2017,

Ok, I understand what you're trying to do. I thought you were trying to change the value of an item within the list when in fact you're trying to change the definition of an actual column. The bad news is there's no action on the SharePoint connector, at the moment, to change the definition of a list column. The good news is that it's not that difficult to add one.

What you want to do here is issue a PATCH request against the column definition. Microsoft recommends creating a JSON payload that only includes the specific column properties that you want to update. In this case, the only thing you want to update is displayName from the sounds of it.

First, you issue a GET request to enumerate the column definitions for the specific List that you want to work with. I mentioned that in my post from Feb 3rd where I mentioned you would need to add an action for this. The action looks like this:

GET /sites/[Site ID]/lists/[List ID]/columns

The response will include an array of JSON objects that correspond to each column in the List. Find the information for the column you're interested in and pull out its ID. Now, you'll use that ID with a PATCH request to update it. The request looks like this:

PATCH /sites/[Site ID]/lists/[List ID]/columns/[Column ID]

And the request body, for displayName, would look like this:

{
  "displayName": "[New Column Name]"
}

Here are some screenshots from a test I ran. The first shows the original file list. The second shows what it looks like after I changed the name of the column titled Test Column.

NOTE: If you're looking at this in the browser, you have to refresh the page to see the update.

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

RE: Microsoft Graph - SharePoint VBO Challenges

Kamal2017 — Tue, 08 Mar 2022 07:57:00 GMT

Hi @ewilson,

I am trying to change the value of an item within the list only. For example: The Title value for Row 1 is "Failed" and I am trying to update this to "Success". The definition of an actual column will remain same i.e. Column name will still be "Title" only.

JSON (Request Payload) = {"@fields":{"Title":"Success"}}

------------------------------
Kamal Ahmed RPA Developer
Sr. Programming Analyst
BNY Mellon
Asia/Kolkata
------------------------------

RE: Microsoft Graph - SharePoint VBO Challenges

ewilson — Tue, 08 Mar 2022 12:24:00 GMT

@Kamal2017,

Ok, apparently my brain is not working. 😂

If you're using the Update List Item Column Values action, on the connector, there's no need to include the @fields portion in the JSON body because it's already included in the URL path. See the following screenshot:

Set up your JSON body to just include the field names and their values like this:

{
  "Title": "Success"
}

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

RE: Microsoft Graph - SharePoint VBO Challenges

Kamal2017 — Tue, 08 Mar 2022 15:20:00 GMT

Hi @ewilson,

Yes, finally it worked. Thank you for all your assistance and support. 🙂

------------------------------
Kamal Ahmed RPA Developer
Sr. Programming Analyst
BNY Mellon
Asia/Kolkata
------------------------------

RE: Microsoft Graph - SharePoint VBO Challenges

Kamal2017 — Wed, 04 May 2022 12:21:00 GMT

Hi @ewilson - Is there any way to get Site ID via SharePoint Online URL ? It looks that all actions in this VBO needs Site id as key input however no action to get the Site ID via URL.

------------------------------
Kamal Ahmed RPA Developer
Sr. Programming Analyst
BNY Mellon
Asia/Kolkata
------------------------------

RE: Microsoft Graph - SharePoint VBO Challenges

ewilson — Wed, 04 May 2022 12:58:00 GMT

@Kamal2017,

Have you looked at the actions Get Root Site or List Followed Sites? You can also try entering the actual hostname of the site as the ID (ex. mysite.sharepoint.com) as some Graph endpoints support that.

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

RE: Microsoft Graph - SharePoint VBO Challenges

Kamal2017 — Wed, 04 May 2022 14:15:00 GMT

Hi @ewilson,

Get Root Site action give us the console (company) id like blueprism.shapoint.com not to the exact site URL we are looking for. While List Followed Sites can give us the site id however it have a dependancy on users to have all those sites marked as favorite.

I am looking for an action to GET site id by passing Token and URL as inputs and provide respective URL site id as one the output paramater.

------------------------------
Kamal Ahmed RPA Developer
Sr. Programming Analyst
BNY Mellon
Asia/Kolkata
------------------------------

RE: Microsoft Graph - SharePoint VBO Challenges

ewilson — Wed, 04 May 2022 14:23:00 GMT

@Kamal2017,

I'm not sure I'm following you. Are you looking for a subsite of the root site? If so, take a look at the Get Subsites action. You pass in the root site (ex. blueprism.sharepoint.com) and it will return a list of all subsites of that root site.

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

RE: Microsoft Graph - SharePoint VBO Challenges

Kamal2017 — Wed, 04 May 2022 14:49:00 GMT

Hi @ewilson,

No, not looking for a subsite of the root site. I am simply looking to get the Site ID of any URL. (ex. blueprism.sharepoint.com/xxx/xxxx/xxx)

------------------------------
Kamal Ahmed RPA Developer
Sr. Programming Analyst
BNY Mellon
Asia/Kolkata
------------------------------

RE: Microsoft Graph - SharePoint VBO Challenges

ewilson — Wed, 04 May 2022 15:56:00 GMT

@Kamal2017,

If your example, you have the hostname of the SharePoint site. You can use that in many of the Graph calls. If you want the actual UUID of the site you can use the Get Site by Site ID action and pass in the hostname of the site. This will return the general data of the site including the UUID for the site. Here's an example response for a test site of mine where I used the hostname with the above action.

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

RE: Microsoft Graph - SharePoint VBO Challenges

Kamal2017 — Fri, 06 May 2022 13:28:00 GMT

Hi @ewilson,

The Get Site by Site ID action will still need site id as input. I am looking for a simple action to input URL (like blueprism.sharepoint.com/xxx/xxxx/) as Input and giving Site Id as Output.

------------------------------
Kamal Ahmed RPA Developer
Sr. Programming Analyst
BNY Mellon
Asia/Kolkata
------------------------------

RE: Microsoft Graph - SharePoint VBO Challenges

ewilson — Fri, 06 May 2022 13:43:00 GMT

@Kamal2017,

Yes, Get Site by Site ID takes a sites ID as input in order to return details about the sites definition - including its full ID. What my last post showed is that you can pass the host name portion of the SharePoint site's URL in as the site ID and the action will succeed.

From your example, I could pass in blueprism.sharepoint.com as the site ID and get back the sites info record.

Does that make sense?

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

RE: Microsoft Graph - SharePoint VBO Challenges

Kamal2017 — Mon, 16 May 2022 10:06:00 GMT

Hi @ewilson,

Looking for another help on this VBO. I have used both Get Lists and Get Subsites , Get All Drives and Get Drive Items action, however none of this is reflecting the list of folders I have on that site.

Any idea if am i missing any action to get this list of folders on that site id ?

------------------------------
Kamal Ahmed RPA Developer
Sr. Programming Analyst
BNY Mellon
Asia/Kolkata
------------------------------

RE: Microsoft Graph - SharePoint VBO Challenges

ewilson — Mon, 16 May 2022 13:44:00 GMT

@Kamal2017,

If you have the site ID, you can use a series of actions to get to a list of folders. Here are the steps:

You can use Get All Drives or Get Default Drive Details to get the driveId for the SharePoint site. If your site uses multiple OneDrive instances you'll want to use Get All Drives and iterate over all the drives to get all the folders.
After you have the driveId, use Get Root Folder ID to get the ID of the top level folder.
With the driveId and root folderId, you can use the Get Drive Items action to get a list of all items in that specific folder (including other folders).
Then you make additional calls to Get Drive Items using the IDs of the child folders.
Repeat step #4 as long as you're finding more child folders.

How do you identify an item as a folder in the response from Get Drive Items? The response data will include a folder facet in the JSON. Here's an example:

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------