1 BEST ANSWER
Best Answers
@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:
Cheers,
------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------
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
------------------------------
@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:
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
------------------------------
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
------------------------------
@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:
Cheers,
------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------
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
------------------------------
@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:
Cheers,
------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------
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
------------------------------
