You’re offline. This is a read only version of the page.
137
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?
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
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-user-and-not/td-p/337874
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/
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
#1
WarrenBelz
146,524
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,906
Most Valuable Professional
Share
Report
All responses (
Answers (
