Unanswered

Sharepoint HTTP Request Process Query Update multi-select person field HELP

(0) Share

Report

Posted on by TimBarnes07

Hello community,

I am trying to update a multi select person field in a Sharepoint list in Power automate by using the HTTP Request action to Sharepoint, and the ProcessQuery URI in order to update the item silently. my XML Body and other details are shown below:

URI: _vti_bin/client.svc/ProcessQuery

Headers: Accept */*

Content-Type text/xml;charset="UTF-8"

X-Requested-With XMLHTTPRequest

<Request xmlns="http://schemas.microsoft.com/sharepoint/clientquery/2009" SchemaVersion="15.0.0.0" LibraryVersion="16.0.0.0" ApplicationName="Javascript Library">
<Actions>
<Method Name="SetFieldValue" Id="5" ObjectPathId="3">
<Parameters>
<Parameter Type="String">Process_x0020_Owner</Parameter>
<Parameter Type="String">-1;#User1@contoso.com</Parameter>
</Parameters>
</Method>
<Method Name="SystemUpdate" Id="12" ObjectPathId="3" />
</Actions>
<ObjectPaths>
<Property Id="1" ParentId="0" Name="Web" />
<Method Id="2" ParentId="1" Name="GetList">
<Parameters>
<Parameter Type="String">/Sites/spsite/list1</Parameter>
</Parameters>
</Method>
<Method Id="3" ParentId="2" Name="GetItemById">
<Parameters>
<Parameter Type="Number">2051</Parameter>
</Parameters>
</Method>
<StaticProperty Id="0" TypeId="{3747adcd-a3c3-41b9-bfab-4a64dd2f1e0a}" Name="Current" />
</ObjectPaths>
</Request>

The top method updates the multi select person field with a single, however i am wanting to update the field with potentially more people. I know how to compose the data how I need it however I just need some pointing in the right direction as to the data it requires, as adding another using in the same format separated by a comma does not work.

I have also tried using an Ensure User step to grab the user D.Id and then putting that into an array and trying to update the field with the array, again with no luck. Before I get the question yes, the column is set to allow multiple values

Any help would be greatly appreciated.

Thanks,

Tim

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Expiscornovus 33,195 Most Valuable Professional on at

Like (0)

Report

Out of interest, have you considered using the SharePoint REST API instead of the client.svc?

Or do you have a specific reason why you want to use this method instead?

https://learn.microsoft.com/en-us/sharepoint/dev/sp-add-ins/determine-sharepoint-rest-service-endpoint-uris?tabs=csom#reference-the-sharepoint-rest-service-in-your-endpoint-uri

There are lots of examples on the internet for updating multi-person type of field values via the REST API approach. Tom Riha has one with the ValidateUpdateListItem method (which also allows to update without incrementing a version, via the bNewDocumentUpdate property)

https://tomriha.com/how-to-easily-update-sharepoint-people-picker-column-in-power-automate/

Was this reply helpful? Yes No
TimBarnes07 25 on at

Like (0)

Report

I can try the method you posted instead and see if that works. The reason why is to update the item even if it is open in browser by someone. Using the update item action will fail if someone has it open so thats why I was using this method. I will look into doing it this way.

Was this reply helpful? Yes No
TimBarnes07 25 on at

Like (1)

Report

I have tried it and it does work. Going to use this going forward thank you. Although I will need to tweak my whole body to match that format as it does update more fields than just one.

Was this reply helpful? Yes No
Expiscornovus 33,195 Most Valuable Professional on at

Like (0)

Report

Btw, recently I published a blog about handling file locks as well with this method.

Might be useful for your setup as well?

https://www.expiscornovus.com/2024/10/23/update-a-locked-file-property/

Was this reply helpful? Yes No