cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
eenochs
Helper III
Helper III

Microsoft Forms to SharePoint List - Created By

I have a Microsoft form that is filled out and sent to a SharePoint list that users can later go in and change fields using Flow/Power Automate.  The SharePoint list has been set up that users can only read and edit what they submitted.  The problem I'm having is that all items are being created by me because I created the flow.  Is it possible to change the created by field so it shows created by the user so when they see the list it shows their items?

3 REPLIES 3
manuelstgomes
Super User
Super User

Hi @eenochs 

 

You should be able to share your Power Automation with the people who need to run it to be able to do that. The Submitted is an automatically generated field so you cannot update it.

 

You have a workaround is to create a new field called something like "Ran By" and add the user that ran the Power Automation. Then you can filter by that field even if it's you who is creating / running the Power Automation.

 

Makes sense?

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

Gristy
Resident Rockstar
Resident Rockstar

Hey @eenochs 

 

Whilst you can use rest api to update the author column i am not 100% sure it will work as you are expecting - it may.

 

There is a example of this here where they update Editor, where you would want to update Author: https://powerusers.microsoft.com/t5/Building-Flows/How-to-update-SharePoint-listitem-under-current-u...

 

The other alternative which will work, is if you use REST API or Plumsail Actions to update permissions directly on the item.

 

There is tutorials on this here: https://collab365.community/sharepoint-item-permissions-using-flow-part-1/

v-litu-msft
Community Support
Community Support

Hi @eenochs,

 

Has your problem been solved by @Gristy and @manuelstgomes 's advice?
If your problem has been solved, You could go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!

Best Regards,
Community Support Team _ Lin Tu

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Users online (2,065)