web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Copilot Studio Changing Created By (A...

Copilot Studio

Unanswered

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

(0) Share

Report

Report

Posted on by Sharmilshah

28

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:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Expiscornovus 33,851 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
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 }

Was this reply helpful? Yes No

Join the conversation