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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Unable to update Creat...
Power Automate
Answered

Unable to update Created by field using Rest API

(0) ShareShare
ReportReport
Posted on by 6

Hello,

 

I'm trying to create a file that is triggered from a MS Form response.   This will allow me to enable"Only users who can approve items (and the author of the item)" on the library so that every Forms responder can only see their file until it is approved.  However, the flow succeeded but the Created by field is not updating with form submitter name.   It displays my name because I am creating a file based on a blank template created by myself. 

I am following this article as an example.  http://johnliu.net/blog/2019/2/flowninja-hack-78-modifying-modified-by-and-modified-time-with-microsoft-flow?rq=modified%20by

 

Any help would be appreciated.

 

ms1.png

Inputs

 

Method

Post

 

URI
_api/web/lists/getbytitle('Submit Business Cases')/items(107)/ValidateUpdateListItem

 

Headers

{
  "Content-Type""application/json;odata=nometa",
  "IF-MATCH""*",
  "X-HTTP-Method""Merge"
}
 
Body

{
"formValues": [{"FieldName":"Author","FieldValue":"[{\"Key\":\"i:0#.f|x@x.com\"}]"}], "bNewDocumentUpdate": false

}

 

Outputs

Status code
200

Body

{
  "d": {
    "ValidateUpdateListItem": {
      "__metadata": {
        "type""Collection(SP.ListItemFormUpdateValue)"
      },
      "results": [
        {
          "ErrorMessage""We couldn't find an exact match.",
          "FieldName""Author",
          "FieldValue""[{\"Key\":\"i:0#.f|x@x.com\"}]",
          "HasException"true,
          "ItemId"107
        }
      ]
    }
  }
}

 

Categories:
I have the same question (0)
  • Verified answer
    Rohit Sharma354 Profile Picture
    on at

    Hello,

     

    I observed that you are using the field name as "Author" to populate the created by.

    As per the example shared in http://johnliu.net/blog/2019/2/flowninja-hack-78-modifying-modified-by-and-modified-time-with-microsoft-flow?rq=modified%20by what happens if you use the field name "Editor" ? Does your flow change the modified by and modified date ? If yes, then it will prove that your logic is correct.

     

    If your list is a list of users are the users a person/group field? If they are you could use that field to filter the views instead of the created by or modified by fields.

     

     

     

  • tonerz82 Profile Picture
    6 on at

    Thank you for your feedback.  I ended up storing the form responder's name in a field in the library and using it for a filter view.  This approach using REST API was unreliable since the flow succeed without errors

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 519 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 296 Moderator

#3
abm abm Profile Picture

abm abm 232 Most Valuable Professional

Last 30 days Overall leaderboard