Updating FieldName "Editor" to be same as "Created By" dynamic content using JSON

Question

I am wracking my brain to find a way within SharePoint to overwrite the Modified By column value of an item with the value within the Created By column.

I have scoured the internet and have found CSOM examples here on SE, but they do not answer my specific dilemma, as I am attempting to do this specifically through JSON Composers and an Sending an HTTP request to SharePoint using the output of those JSON Composers.

As a reference, I am using this article to give me the biggest bulk of work, and I have the JSON Formatted correctly, but it still will not update the Modified By parameter of a file. I have disabled all other flows which may modify the file to ensure this change should be done.

My current JSON input from the HTTP Request looks like this:

[
  {
    "FieldName": "Editor",
    "FieldValue": "[{\"Key\":\"i:0#.f|membership|[email protected]\"}]"
  },
  {
    "FieldName": "Title",
    "FieldValue": "SomeTitleOfFileSinceTitlesAreNotPrePopulatedinSharePoint.pdf"
  }
]

I know my JSON works appropriately for the Title field, as the Title field updates appropriately, AND, my version of the file does not increment up so I know the final line is appropriately working as well! I feel like I'm missing something really really simple. . .

I've also tried using the odata ("Created By") Dynamic Content values pulled directly from the body of the file, as well as the ("Created by Display Name") Dynamic Content value. I am populating the "i:0#.f. . . Key using ("Created by Claims") Dynamic Content value as well. Below are screenshots of my flow:

I am baffled by this and am seriously hoping I'm forgetting something or using "" when I should be using '' etc.

Answer 1

I have done the exact same thing before in one of my flows where I didn't want to change the "Modified By" field with the name of flow owner/connection.

Below is my flow configuration which copies the "Created By" in "Modified By" column:

Here I have added Created by Claims directly in the Compose action. It is working fine for me. So, no need to convert it using string() function.

Answer 2

I have done some test and the key shall be on the claims. You will need to first convert it to string and then use it in the compose action. It works in my end on updating the modified by field with another custom person field. Have a try on this. Other steps are exactly same with the blog your provide.