Power Automate - How to update SharePoint Created, Created By, Modified, Modified By Fields?
Вставка
- Опубліковано 5 вер 2024
- This video explains how to update SharePoint system fields Created, Created By, Modified, Modified By.
REST API
_api/web/lists/getbyTitle('ajlist')/items({Here place the id of the record})/ValidateUpdateListItem
Header
Content-Type application/json;odata=verbose
Http Body
{
"formValues":[
{
"FieldName":"Author",
"FieldValue":"[{'Key':'i:0#.f|membership|youremail@yourdomain.com'}]"
},
{
"FieldName":"Created",
"FieldValue":"19/01/2000"
},
{
"FieldName":"Editor",
"FieldValue":"[{'Key':'i:0#.f|membership|youremail@yourdomain.com'}]"
},
{
"FieldName":"Modified",
"FieldValue":"21/01/2000"
}
]
}
Thanks, It worked for me.
You're welcome!
How to update values by dynamic content .. I tried it is now working by if I give mail manually it works
Do you still need help in this?
Thanks
Flow ran successfully...
But the data not changed...
May i know why?
I need to see the flow
Hi abm
Is it possible to use a version of this flow to migrate a SPO classic List to a SPO Modern List in the same tenant?
I have a few lists to move but I only need to retain the created data from the SPO Classic from the metadata.
Hi Joe
Believe it should be possible. I can't see any difference other than the UI changes between classic and modern. So Power Automate should connect the classic list.
@@abm4975
Thank you for your quick reply :)
ShareGate charge $4999 a year for that ability so it would be a game changer if it could be done via a flow.
Interesting. Could you connect me via email. Check my Channel about section. I want to see the classic list. I could have a go and see whether I can make it work or not.
Thanks
What if I want to update the created by column of the same SharePoint list by using resources name column of that same list
Any luck here? i need to do the same.
Hii abm, i have a Microsoft form. When an employee or user submit his request. A line item creates in the SharePoint list. But createdby showing the connector of the Power automate. Instead of the connecter name should come response submitted display name
Please help me . I tried multiple time with SharePoint HTTP action
Hi
If you are sending externally then you won't be able to collect the names. If its internal (within your office network) its possible. The other option is you can add that as a question in your MSForms to ask the persons name as part of the forms submission.
Thanks
@@abm4975 hi abm finally I achieved, now I have another question we have a send an email action in the Power automate right. Can we collect multiple options from the mailbody
I got a video based on this. Please have a look
ua-cam.com/video/N1dYFr_4WSU/v-deo.html
Thanks for the video. How can we achieve this if files are in the DocumentLibrary of Sharepoint? I need to update the modified date if the date is 2 years old.
Use the expression addYears() and filter the records using this value.
learn.microsoft.com/en-us/power-automate/minit/date-and-time-operations
Thanks
@@abm4975 , thank you for the quick reply, yes. I am using addDays(utcNow,-913,’yyyy-MM-dd’) , UpdatefiePropertiecs does not update the Modified and SharePoint trigger Send HTTP Request, going wrong on POST or PUT to update
Hi
I could offer a screenshare and have a look at your flow. Click my channel icon > Welcome to my Power Automate tutorial channel. Click here. You can see my email from the about section then connect me.
How can I remove information from another column of a shared point list that is of type text?
Believe you are using Update Item Action step. Set it to null using the expression.