change list element "creator" (owner)

[mc_chick]

outside a flow, i use the sharepoint list setting that a user only can see and edit their own entries. 

Is there a way to change the owner/creator of an entry if someone from a helpdesk or support creates the entry "in the name" of the user? at the moment the entry will be created in the name of the support-member, which creates it. And this leads to the real user cant see the entry ... are there any ideas for a possible solution? or is the sharepoint-list setting "not to be tricked"?

[RobElliott · Accepted solution]

 yes this can be done by using the send an http request to SharePoint action. In my company we add a JSON-formatted button to the site pages library or to the list. The following example was for a blog I did on this last week for my company where I'd been asked how to change the owner of a page so the new owner receives comments, likes etc, not the person (usually me) who created the page. But the principle is the same for a list created by column. 

 

Fire up Power Automate and create an instant cloud flow from blank and from the toggle at the top right of the flow switch to the classic designer. Among other problems with the new designer it doesn't have the trigger we want so we have to use the classic designer (which many of us prefer anyway!).

As we're doing this for a site page the trigger is the SharePoint For a selected file. For a list it would be for a selected item. Select your site and for the Library use a custom value of Site Pages Add a text input and for the left field I've typed Page Contact Email and for the right field with the hint text I've typed Enter email address before @

 

 

Next, add the Send an HTTP request to SharePoint action and select your site. Then add the following:
 

• Method: Post
• Uri: _api/web/lists/getByTitle('Site Pages')/items(ID)/validateUpdateListItem
• Headers: leave empty

• Body: 
  {

  "formValues":[

  {

  "FieldName": "Author",

  "FieldValue": "[{'Key':'i:0#.f|membership|Page Contact Email@wsp.com'}]"

  },

  {

  "FieldName": "Editor",

  "FieldValue": "[{'Key':'i:0#.f|membership|Page Contact Email@wsp.com'}]"

  }

  ],

  "bNewDocumentUpdate": true

  }
  
  Select ID from the dynamic contact box.
  Select Page Contact Detail from the dynamic contact box.

   

  Give your flow a name and save it and make a note of the flow ID from the address bar as you'll need it for the button that triggers the flow:

   

  In your Site Page library create a new single line of text column and go to format this column.

   

  Format the column in advanced mode and paste in the following to create the button, changing the id to the one you copied from the flow. You can change the button text (txtContent), and in the actionParams line you can change the header text (I'm just using the page title) and the text on the Run Flow button:
  
  

  {

  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",

  "elmType": "button",

  "txtContent": "Change Owner",

  "customRowAction": {

  "action": "executeFlow",

  "actionParams": "='{\"id\":\"5eddbaca-e7df-46f4-b968-f009ed9f69ec\", \"headerText\":\" ' + [$Title] + '\",\"runFlowButtonText\":\"Go\"}'"

  },

  "style": {

  "background-color": "#bad3ce",

  "border-radius": "10px"

  }

  }

  

  When the button is clicked a panel will open on the right of the screen. The first time you run it it will just want the confirmation of the SharePoint connection. You enter the first part of the email address of the new author omitting the @xxx.com part, so in this example it's philip.ladd, and then you click the Go button.

   

  The flow will run and after a few seconds the Site Pages library will refresh with the new name in the created by column. 

  

  Rob
  Los Gallardos
  If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

[mc_chick]

It works perfect 🙂 thanks a lot. I integrated the flow in my PowerApp solution and now we are able to create entries for the users and also "in the name" of the users 🙂 very nice ...