Microsoft Forms to SharePoint List - Created By

Like (0) Share

Report

Posted on 18 Dec 2019 18:07:36 by eenochs

141

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?

I have the same question (0)

All responses (3)

Answers (0)

v-litu-msft on 01 Jan 2020 at 09:01:28

Like (0)

Report

Re: Microsoft Forms to SharePoint List - Created By

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
Gristy 2,429 on 18 Dec 2019 at 20:48:27

Like (1)

Report

Re: Microsoft Forms to SharePoint List - Created By

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
manuelstgomes 6,625 on 18 Dec 2019 at 18:25:18

Like (0)

Report

Re: Microsoft Forms to SharePoint List - Created By

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

Community site session details

Microsoft Forms to SharePoint List - Created By

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

MS.Ragavendar – Community Spotlight

Congratulations to the August Top 10 Community Leaders!

Leaderboard > Power Automate

Featured topics

Product updates

Community site session details

Microsoft Forms to SharePoint List - Created By

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

MS.Ragavendar – Community Spotlight

Congratulations to the August Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Power Automate

Featured topics

Product updates