How to grant access in Sharepoint

Question

Hey,

I created a list in sharepoint (for helpdesk tickets) that the users can submit a new ticket from the list itself or by sending an email to a mailbox. If the user chooses to submit a ticket by email, I created a flow that creates an item in the list when a new email arrives.
My problem is that the user can only see his tickets that he has submitted from the list itself, if he sent an email and submitted a ticket from there he won't see it (although I set the option that the user can see his items only).
Just to clarify that the tickets that are being submitted from the email looks just like the tickets that are created in the list - it's assigned to the user.

user view -

owner view -

Answer 1

Hi @Lihi Zin,

To change the created by column using a Power Automate flow, you need to use the "Send an HTTP request to SharePoint" action.

1. Add Send an HTTP request to SharePoint action to your flow.
2. Add your site address to the action.
3. Select POST inside the Method box.
4. Pass your Uri in Uri box as below.

Example : _api/web/lists/GetByTitle('list name')/items('item id')/ValidateUpdateListItem

Replace 'list name' with your list name;

Replace 'item id' with the item id created by the above "Create item" action.

5. Pass the Body as below:

{     
    "formValues":[ 	
        { 	    
            "FieldName": "Author", 	    
            "FieldValue": "[{'Key':'i:0#.f|membership|<author email>'}]" 	
        }     
      ], 
    "bNewDocumentUpdate": true 
}

Replace <author email> with the email sender mailbox in the trigger.

I have tested this flow in my environment, and it worked perfectly. Comment below if you still have any other questions.

---

If the answer is helpful, please click "Accept as Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.