Changing Created By (Author) in SharePoint List At time of adding a task through Copilot studio (Power Virtual agent)

(0) Share

Report

Posted on by Sharmilshah

Hi,

I have created a chatbot in Copilot studio. This chatbot takes information from user and add it on Sharepoint list. While testing, I figured out that the default created by column shows my name instead of the user who has added a request through chatbot. Could you please guide me how can I change "Created By" (Author) column on sharepoint list at time of creating task?

After creating task, there is no point of changing the created by details as I won't have the requestor's details. Please guide.

Thank you

Categories:

General

All responses (1)

Answers (0)

Expiscornovus 31,709 Most Valuable Professional on at

Like (0)

Report
Re: Changing Created By (Author) in SharePoint List At time of adding a task through Copilot studio (Power Virtual agent)

Hi @Sharmilshah,

A topic should have system variables like User.PrincipalName. You can use that to feed into your flow. After that you can use that principal name to set the author field with a HTTP request.

Below is an example

1. The User.PrincipalName system variable

2. A flow which uses a ValidateUpdateListItem method to update the Author value to the principal name of the user who interacts with the Copilot of the item just created. Based on this article:

https://elliskarim.com/2022/09/13/how-to-easily-change-the-creator-or-editor-of-a-sharepoint-file-or-item-using-power-automate/

URI

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

Body

{ "formValues": [ { "FieldName": "Author", "FieldValue": "[{'Key':'i:0#.f|membership|@{triggerBody()['text']}'}]" } ], "bNewDocumentUpdate": true }