cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Karol
Helper II
Helper II

Change author of record in 'Created by' column

Dear PA Users,

 

I'm creating a "Suggestion Box" to a company. I added in SP list a Column named "Anonymous" (Yes/No). I would like to hide the creator of the record, if the person would like to give a suggestion anonymously. Is that possible? How can I reach that? I'm wondering if there is a possibility to create a flow:

Karol_0-1646680114834.png

 

"When Anonymous = Yes, make a Service_Account creator of that record in "Created by" column"

 

Maybe it's trivial, but I cannot find a solution. Thank you in advance.

 

Best Regards,

Karol

2 ACCEPTED SOLUTIONS

Accepted Solutions
ekarim2020
Super User
Super User

See: How to change SharePoint item author (Created By) with Power Automate


Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

I've just created the flow and successfully changed both the author and editor

{
  "formValues": [
    {
      "FieldName": "Author",
      "FieldValue": "[{'Key':'i:0#.f|membership|AlexW@dev365.com'}]"
    }
  ],
  "bNewDocumentUpdate": true
}

 

(1) Make sure that the Uri starts with an underscore character:

Snag_1736024.png

(2) The error 401 Unauthorized may indicate a permissions problem? Do you have Site Owner permissions to the SharePoint site?

 


Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

 

View solution in original post

5 REPLIES 5
ekarim2020
Super User
Super User

See: How to change SharePoint item author (Created By) with Power Automate


Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

Dear @ekarim2020,

 

 I got stuck:

 

Karol_0-1646690702761.png

Karol_1-1646690747211.png

 

 

 

401 UNAUTHORIZED

I copied 1:1 everything from that link. Any ideas?

 

Body:
{
"formValues":[
{
"FieldName": "Author",
"FieldValue": "[{'Key':'i:0#.f|membership|rpauser@domain.com'}]"
},
{
"FieldName": "Editor",
"FieldValue": "[{'Key':'i:0#.f|membership|rpauser@domain.com'}]"
}
],
"bNewDocumentUpdate": true
}
}

I've just created the flow and successfully changed both the author and editor

{
  "formValues": [
    {
      "FieldName": "Author",
      "FieldValue": "[{'Key':'i:0#.f|membership|AlexW@dev365.com'}]"
    }
  ],
  "bNewDocumentUpdate": true
}

 

(1) Make sure that the Uri starts with an underscore character:

Snag_1736024.png

(2) The error 401 Unauthorized may indicate a permissions problem? Do you have Site Owner permissions to the SharePoint site?

 


Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

 

Dear @ekarim2020  thanks.

 

I noticed that I had no Site Owner permissions, I gave proper privileges 5 mins ago. I'll check it later, because it's not working, maybe it needs time to "sync" in the cloud.

pkolodzi
New Member

Is it possible to add an email from the person who sends this email? I don't want one specific one by default.
Below is the code I entered, but unfortunately it still does not work

 

pkolodzi_0-1657030091671.png

 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (5,292)