web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / POST API to user field...
Power Automate
Answered

POST API to user field Error

(1) ShareShare
ReportReport
Posted on by 12

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 ColumnUser - Person Column
User EmailUser 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.

Ethan1132_1-1688635442839.png

 

Ethan1132_0-1688635364221.png

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.

 

Categories:
I have the same question (0)
  • Verified answer
    annajhaveri Profile Picture
    8,531 Most Valuable Professional on at

    @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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 239 Super User 2026 Season 1

#2
David_MA Profile Picture

David_MA 177 Super User 2026 Season 1

#3
Kalathiya Profile Picture

Kalathiya 97 Super User 2026 Season 1

Last 30 days Overall leaderboard