How to make a flow that can be run by other people and puts the name in the column Created By and Changed By in the list ?

(0) Share

Report

Posted on by CU16021406-1

1,048

Dear Experts,

I want to make a flow that creates a SharePoint List row for me and my colleagues. So i have shared the flow with my colleagues.

The SharePoint List also contains the columns "Created by" and "Changed by".

But when a colleague runs the flow (that i have created). My name appears in the column Created By and Changed by.

instead of the name of the colleague that has run the flow. What do i have to do to correct this.

So how to get the name of the person that has triggered the flow:

Gr. P

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

eliotcole 4,388 Moderator on at

Like (1)

Report
Copy link

Link copied!

You can use a ValidateUpdateListItem() SharePoint API call using the 'Send an HTTP request to SharePoint' action, @PeKi72 .

This might take a few tries for you to get it right ... but it is a really good thing to "keep failing at" to knock it in to your head. 😅

Take a look at SharePoint Cass' page on this, here:

https://sharepointcass.com/2020/05/14/programmatically-updating-sharepoint-list-properties-in-power-automate-without-affecting-the-version-history/

I also think that @Expiscornovus has a page on it somewhere, too!!

Basically, it works by editing only the fields that you want changed to be what you want them to be, and theoretically shouldn't indicate any change to the list or library. Although I have found that part to be lacking in recent months.

So just make sure that you don't make any loops in your flow. 😉

Was this reply helpful? Yes No
Verified answer

Expiscornovus 33,501 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @eliotcole,

I have used that approach a couple of times. You can update the Author and Editor fields with it.

@tom_riha has a nice blog about this specific use case with this method:

https://tomriha.com/how-to-change-sharepoint-item-author-created-by-with-power-automate/

Was this reply helpful? Yes No
eliotcole 4,388 Moderator on at

Like (0)

Report
Copy link

Link copied!

Agreed with Expiscornovus to add both as solution.

Was this reply helpful? Yes No