I tried it but it didn't work.
Solved @ekarim2020 - there was a different internal list name. I did find out that you need _x0020_ if your name has spaces.
Hi @smorley
Confirm you have the correct ListItemEntityTypeFullName for the list "Loan Manager".
Please see section 5. How to CLEAR a People column using Power Automate of the post 🚹SharePoint People Column : How to Update and Patch in Power Automate and Power Apps and confirm you have the correct ListItemEntityTypeFullName for the list "Loan Manager".
This post shows how to CLEAR a People column using Power Automate:
Hope this helps.
Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site
@ekarim2020 I'm going to add to the pile. I'm getting the error of:
A type named 'SP.Data.Loan_x0020_ManagerListItem' could not be resolved by the model. When a model is available, each type name must resolve to a valid type.
The name of my list is "Loan Manager" so I added the '_x0020_"
Based on your post, here is the body of the http action:
{'__metadata':{'type':'SP.Data.Loan_x0020_ManagerListItem'},
'CurrentOwnerStringId':'',
'CurrentOwnerId':-1
}
The internal name of my people/group field is "CurrentOwner" without any spaces.
Any help that you could give would be greatly appreciated.
I can do it. I really appreciate all the hard work you’ve done to help me.
To do the clear operation, you must know the correct ListItemEntityTypeFullName property of the list and pass that as the value of type in the Send an HTTP request to SharePoint body.
It seems that the ListItemEntityTypeFullName property value SP.Data.BTToolsDataListItem specified in the flow may not be correct.
Use the following rest call to get the ListItemEntityTypeFullName
Uri:
_api/web/lists/GetByTitle('People')?$select=ListItemEntityTypeFullName
Headers:
{
"Accept": "application/json;odata=nometadata"
}
Then examine the runtime output of the request to get the text for the ListItemEntityTypeFullName
Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.
Flow run failed
Flow run failed
Although there may be other ways to do this, it can be done using a HTTP request to SharePoint:
Uri:
_api/web/lists/GetByTitle('People')/items(69)
Headers:
{
"IF-MATCH": "*",
"X-HTTP-Method": "MERGE",
"Content-Type": "application/json;odata=verbose",
"Accept": "application/json;odata=verbose"
}
Body:
{'__metadata':{'type':'SP.Data.PeopleListItem'},
'PMStringId':'',
'PMId':-1
}
Here is an example of clearing the PM field from a SharePoint List called People. The list item ID is 69:
Use the internal name for the Person field, not the display name.
For more info please see:
Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.