cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate I
Advocate I

Change the CREATED BY field in a sharepoint list on newitem

What I'm really needing to do is have a sharepoint list with dynamic permissions, seeing as how the only item level permissions in sharepoint lists that exists are based around the "created by" being only able to view items that person created, what I'd like it to have is LIST B update list A and have the "created by" field be the MANAGER of the user who created the new item in list B, but I don't know of any way to do this..

 

Is there a way to do this that I'm not thinking of? It gives me tremendous flexibility if I can do this from sharepoint, otherwise there's no way to have all the list items in the same place but have permissions just to those that need them, this would save me easily 10+ hours in work if it were do-able.

1 REPLY 1
Highlighted
Dual Super User
Dual Super User

Re: Change the CREATED BY field in a sharepoint list on newitem

Hi!

 

The scenario is that items on List B are created by employees; and Flow shall copy them into List A assigning the Manager on Created By field, right?

If the Flow runs with the Manager credentials, I guess this can be achieved. So, the Flow triggers "When a new item is added" on List B; then check the Employee (Created By field from new Item on list B).

There is an action called ‘Office 365 Users – Get manager’ that allows you to obtain Employee's Manager Id.

 

There is another action called 'Office 365 Users – Get My Profile'- I haven't tested myself, but I guess it will provide Flow Owners id.

 

If so, you just need to compare Flow Owner and Employee's Manager, if match, then copy item from list B to lista A. THis way the new item on list A will be created bt Employee's manager.

 

Please note if the scenario covers more than one manager, it means N instances of the flow shall be created, one per manager. So this can have a significant performance impact. FRom the functional point of view, N flows will be executed, but only one will pass the condition

 

Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Helpful resources

Announcements
firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Users online (6,867)