Does anyone know if there is a working method to clear (to blank) a single people picker field in an update Singlepoint process within flows?
Does anyone know if there is a working method to clear (to blank) a single people picker field in an update Singlepoint process within flows?
Hi @NorsemanRoo
I checked my version of flow compared with my video and I found what was your issue. So in your earlier post you mentioned the following didn't worked.
{
'__metadata':{'type':'SP.Data.ApprovalsListItem'},
'EnHApprover':-1
}
In my video I specified that you need the keyword Id along with the field name. See below in bold.
{
'__metadata':{'type':'SP.Data.ApprovalsListItem'},
'EnHApproverId':-1
}
Try the above in your body and it should work.
Thanks
Finally fixed this - for those that are interested. the previous options were on the right vein but did not work. This does:
Hope this helps someone in the future 🙂
Could you post a screenshot of your SharePoint List settings column EnHApprover details?
api/web/lists/GetByTitle('Approvals')/Items(@{outputs('Compose')})
I've used both getbytitle and GetByTile
{
'__metadata':{'type':'SP.Data.ApprovalsListItem'},
'EnHApprover':-1
}
{
"status": 400,
"message": "A 'PrimitiveValue' node with non-null value was found when trying to read the value of a navigation property; however, a 'StartArray' node, a 'StartObject' node, or a 'PrimitiveValue' node with null value was expected.\r\nclientRequestId: 16bee3d6-1fda-48d9-b898-fd3077a1d390\r\nserviceRequestId: f9f329a0-4054-3000-e9f3-73378554e8cd",
"source": "https://heathcoatfabricsltd.sharepoint.com/GH/_api/web/lists/getbytitle('Approvals')/Items(3)",
"errors": [
"-1",
"Microsoft.SharePoint.Client.InvalidClientQueryException"
]
}
Sorry - Error
Could you post a screenshot of the SharePoint column details metadata?
No- that didn't work.
As I am using non multiple I used the first video.
After a bit of configuring I got it all correct but it failed:
Error Message:
A 'PrimitiveValue' node with non-null value was found when trying to read the value of a navigation property; however, a 'StartArray' node, a 'StartObject' node, or a 'PrimitiveValue' node with null value was expected.
clientRequestId: 16bee3d6-1fda-48d9-b898-fd3077a1d390
serviceRequestId: f9f329a0-4054-3000-e9f3-73378554e8cd
Blimey that's convoluted. I'll give it a go in the morning and let you know how I get on
WarrenBelz
146,668
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,004
Most Valuable Professional