Unanswered

Microsoft Forms to SharePoint List - Created By

(0) Share

Report

Posted on by eenochs

147

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?

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (0)

manuelstgomes 6,625 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Gristy 2,429 on at

Like (1)

Report
Copy link

Link copied!

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/

Was this reply helpful? Yes No
v-litu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No