Forum Discussion
LucidBike1140
May 22, 2024Iron Contributor
SPO List View/Edit Items Created by User - Can I Change the User?
We have an existing Excel sheet with many entries and need to make it a shared list in SPO. Each user should only be able to view or edit their own entries. The problem is the list will be pre-popu...
Rob_Elliott
May 23, 2024Silver Contributor
LucidBike1140 the created by column is read only so cannot be amended within the list. It is however possible to change it by building a flow in Power Automate, trigger it by having a JSON-formatted button in a single line of text column, and using the "Send an HTTP request to SharePoint" action in the flow:
But it might be better for you to have a separate column for the assigned to person and then change the item permissions based on the video at https://www.youtube.com/watch?v=PYxzWMI8h8I
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)