Answered

Create new List elements in a listfolder

(0) Share

Report

Posted on by ToWag

Hello everyone,
I am working on the following task:

Employees can submit a request using a form. For each submitted request, I create an element in a SharePoint list with the most important details. Employees should have access to this list so that they can only see the requests they have created.

I have tried the following: All employees have read-only access to the list and I have created a list view that filters the "Created by" column by [Me], i.e. they should only be able to see the requests they have created themselves. The problem is that the "Created by" column always contains my name, as I am the creator of the form and this apparently determines the entry in "Created by". My intended filter function therefore does not work. I cannot overwrite the entry in "Created by" either.

My new approach: I have created a folder in a SharePoint list for each employee and would like to save new list entries directly in the folder corresponding to the respective employee. The employee then receives a share link for their folder and not for the entire list. Sharing works perfectly, but now I can't manage to create a list item directly in a list folder using Power Automate. Does anyone know what to do? Does anyone have an alternative solution to my problem?

Thanks in advance 🙂

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

SamLed 2,338 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @ToWag,

Following Rest API call updates "Created by" (Author) and "Modified by" (Editor) fields value:

Uri:

_api/web/Lists/GetbyTitle('<List Tttle>')/items(<Item ID>)/ValidateUpdateListItem

Headers:

{ "Accept": "application/json; odata=verbose", "Content-Type": "application/json; odata=verbose" }

Body:

{ "formValues": [ { "__metadata": { "type": "SP.ListItemFormUpdateValue" }, "FieldName":"Editor", "FieldValue":"[{'Key':'i:0#.f|membership|<user email>'}]" }, { "__metadata": { "type": "SP.ListItemFormUpdateValue" }, "FieldName":"Author", "FieldValue":"[{'Key':'i:0#.f|membership|<user email>'}]" } ] }

______________________________________________________________

If I have answered your question, please Accept the post as solution.
If you like my response, please Thumbs Up.

Was this reply helpful? Yes No
ToWag 7 on at

Like (0)

Report
Copy link

Link copied!

Awesome! It worked at first try. Thank you very much 🙂

Was this reply helpful? Yes No