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?
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.
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
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/
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!
Community Support Team _ Lin Tu