Unanswered

Flow to SharePoint list item - change "Created By"

(0) Share

Report

Posted on by JojenReed

I have a simple Flow, that takes the responses from a form created in Microsoft Forms and creates a new SharePoint list item for this. It appears however that regardless of who fills in the form, when Flow creates the SharePoint list item the Created By field is always set to me (probably as I created the Flow) - what I want however, is to know who the responder is, and I want them as a person object so I can utilise their profile information. I know I can get the responder's email and add that to a text field, but that is insufficient - or more work later on to retreive their profile information.

Is this possible?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

PieterVeenstra 13 on at

Like (0)

Report

Hi @JojenReed,

I don't think that this is possible at the moment. Running as the active user is indeed something that is needed from a SharePoint perspective. There are however a few soluitons that may work:

1. Create a PowerApps app instead of a form in Microsoft Forms. Then you could update the data in SharePoint directly.
2. If you can kick off the flow manually somehow ( this could be from e.g. PowerApps or SharePoint) then the flow could run as the logged in user.

At the moment what is happening is that the process runs as the Flow publisher. And as this user you are finding that the flow is triggered.

Was this reply helpful? Yes No
v-xida-msft on at

Like (0)

Report

Hi @JojenReed,

Could you please share a screenshot of your flow's configuration?

Do you want to change the Created By property within a SharePoint list using Microsoft Flow?

I agree with @Pieter_Veenstra's thought almost. The Created By field is a system field, it would be populated by SharePoint automatically. Changing the Created By field of a SharePoint list is not supported in Microsoft Flow currently, if you would like this feature to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

The value filled within Created By field of SharePoint list is based on connections. In other words, if user A create a connection to "Create item" action of SharePoint connector, when the flow run successfully, the Created By field would be populated with User A. If user B create a connection to "Create item" action of SharePoint connector, when the flow run successfully, the Created By field would be populated with User B.

You could consider take a try to create a custom Person or Group type column called Responder in your SharePoint list. Then set the value of this column to Responder's Email dynamic content within "Create item" action:

Best regards,

Kris

Was this reply helpful? Yes No
JojenReed 25 on at

Like (1)

Report

Hi Kris,

I'm happy with Pieter's response and have attempted your solution also - but I was having a problem with that too and have a separate forum post for that - https://powerusers.microsoft.com/t5/Building-Flows/Flow-to-record-info-from-Forms-in-SharePoint-list-including-the/m-p/95813#M9381

Was this reply helpful? Yes No