web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : SSmvOGRscdHOJGcG0g0evv
Copilot Studio - General
Unanswered

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

Like (0) ShareShare
ReportReport
Posted on 23 Jan 2024 11:28:06 by 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:
  • Expiscornovus Profile Picture
    32,205 Most Valuable Professional on 24 Jan 2024 at 16:36:21
    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

     

    systemvariable.png

    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
    }

     

    upn_flow.png

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Copilot Studio

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 468 Super User 2025 Season 2

#2
stampcoin Profile Picture

stampcoin 52 Super User 2025 Season 2

#3
trice602 Profile Picture

trice602 46 Super User 2025 Season 2

Loading complete