cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Update Created By field to Raised by in Sharepoint

Hi,

 

I have a flow which creates an item on the "Private" sharepoint list when a user selects Private in the Private or Public list, and deletes the private item from the "Public" SP list. Else, create the item in the "Public" SP list. ss2020.PNG

I have set up the Private list so that users can only see the items which they have created by ticking the 'Read items that were created by the user' option. However, with this flow, Created By is set to default to me, as I have created this flow, which makes this setting invalid i.e. users who created / raised the item wont see the it because Created by equals myself.

 

How do I work around this? Can i get flow to update created by to Raised By (a person/group lookup field) which I have?

 

Regards,

I

3 REPLIES 3
Gristy
Resident Rockstar
Resident Rockstar

You can try and update the author user the rest API

See examplehere

http://johnliu.net/blog/2019/2/flowninja-hack-78-modifying-modified-by-and-modified-time-with-micros...
Anonymous
Not applicable

Hi @Gristy ,

 

In the example which you had referred to, the author is defined. However, in my SP list, the user who creates the list item could be anyone who has access to this user. How can I achieve this?

 

Regards,

I

Gristy
Resident Rockstar
Resident Rockstar

The Create Item runs as the user the connection is on. i.e. yourself.

 

You need to do that and then update the Author column when whomever you need to maybe from the triggers author?

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

Users online (1,333)