Unanswered

Set Created By in LIST based on Responder in FORM

(0) Share

Report

Posted on by JeffHallett

I'm setting up a simple Power Automate to create an entry in a List based on a form submission in Forms. As expected, the Created By in the List entry is the owner of the automation flow.

Is there a way to set the Created By in the List entry to the responder on the Form using Power Automate?

I have seen a similar post where the answer involved calling a REST function, but I confess I'm new to Power Automate and the example was not complete enough for me to understand how to accomplish this from inside the flow. I also tried using the AI on Copilot and it made a change that looked promising but it failed when it executed as it seemed to have used schema references that were no longer valid.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Expiscornovus 33,189 Most Valuable Professional on at

Like (2)

Report
Hi @JeffHallett,

You can use a Send an HTTP request to SharePoint action for this. With in that action you can update the Author field value of the existing item via the ValidateUpdateListItem method. @tom_riha has written a nice blog about this approach: https://tomriha.com/how-to-change-sharepoint-item-author-created-by-with-power-automate/

Below is an example

1. In this sample first the list item is created in a list called Update Created By.

2. With an Send an HTTP request to SharePoint action that item is updated. The Responders' Email field is used for that in the Body. Also the ID of the Create Item is used in the URI

URI

_api/web/lists/GetByTitle('Update Created By')/items(@{outputs('Create_item')?['body/ID']})/validateUpdateListItem

Body

{ "formValues":[ { "FieldName": "Author", "FieldValue": "[{'Key':'i:0#.f|membership|@{outputs('Get_response_details')?['body/responder']}'}]" } ], "bNewDocumentUpdate": true }

1 people found this reply helpful.

Was this reply helpful? Yes No
JeffHallett 19 on at

Like (0)

Report

Thanks! Going to check this out right away!

Was this reply helpful? Yes No
ScottAD 39 on at

Like (0)

Report

Just want to say this worked perfectly for me!

Was this reply helpful? Yes No