
I am way out of my depth using the API, I've managed to create a flow from pulling other forums together.
I am stuck at the very end of my flow with one specific field that I am trying to populate with POST.
I have a list with two columns
| Title- Text Column | User - Person Column |
| User Email | User Account |
| User Email | User Account |
I am trying to push the user email into the user account column, however when I try do this I get the below error.
{"odata.error":{"code":"-1, Microsoft.SharePoint.Client.InvalidClientQueryException","message":{"lang":"en-US","value":"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."}}}
I am able to push the Title field with the information without a problem, it is when I try add this User column I get the issue.
Can someone explain how I can push the Title information into the User field, causing the List to pick up the user account via their email address without getting the above error.
@Ethan1132 to update user value in the column, you need the user id. You can get user id using the REST API _api/web/SiteUsers/getByEmail(‘UserEmail‘) in the Send HTTP action. Then use the user id within the POST API Send HTTP action, here you have to append Id to the column name, so if your column name is user, then use UserId in the column name.