Move SharePoint List Items Using Power Automate #PowerAutomate #SharePoint

Hello Friends,
As we know, there is a feature in the SharePoint list that allows moving list items to a given folder, but it's a manual process.
In this video, I will show you how to move SharePoint list items using Power Automate automatically

Connect with me
Twitter: @deepak_s22

#PowerAutomate #SharePoint

[shaiksamad]

Deepak.. Your demos are crystal clear and easy to remember. Thanks for sharing the valuable tips

[conaxlearn]

6:19, I think you can user Full Path instead of Identifier. Full Path seems to be the decoded Identifier.

[susanclark]

Thank you for this - it took me awhile, but I finally moved something!

[kimh]

Amazing !! Thank you for taking the time to create this instruction. It worked perfectly !

[YoN]

This is exactly what I needed. Thank you so much for the simple and detailed explanation. Keep up the great work really appreciated.

[marksims]

Thank you Deepak. This one got me out of a hole🙏

[Geennjuuu]

I always get StatusCode: 404 in my HTTP Request. It says no File not found.. does anyone have an Idea?`

[dlouhavideacz]

Hi Deepak, is it aplicable just for lists and items, without folders?

[jelmerbakker]

Hi Deepak Shrivastava, how can apply your method to files? Now you have recorded a video on items, but I need to use it for files like Excels and PDF's.

[zhenghaiming]

Is it possible to move the item subsequently, when the item's title was edited, for example, changed the title from USA to India thus this item should move to India folder?

[lpdowdell]

Deepak, how are you? Why do you use decodeUriComponent 3 times?

[Tubasnot]

Hello @Deepak, Running into bit of issue when running this. By and large got it to work and the workflow moving items for me. But every new items moved into folder seems to overwrite the previous one (have checked this against the ID generated). The only difference from your workflow is that I have an get item and update item before executing the move. The update is appending and updating some records that are being pulled in from other lists as refences (like generating department and service lines). Either way, any thoughts on why the data overwriting is happening? Cheers and thanks for the great video

[shinable]

Hi what do you do if you column has multiple options. How to handle them?

[billwhite]

Thank you for this - I am nearly there (I think).

My flow is to run daily and move the appropriate list line items to different List archive locations depending on a value in one of the columns.

I have followed the process and have the api call set up. When I run the flow, my "Get Items" finds 2 line items it needs to process, it apparently runs successfully and the api call gets a "odata.null": true as the output. When I run the flow a 2nd time - the "Get Items" finds no items to process (as hoped for).

This is the Json for one item from the first run.
"srcPath": {
"__metadata": {
"type": "SP.ResourcePath"
},
"DecodedUrl":
},
"destPath": {
"__metadata": {
"type": "SP.ResourcePath"
},
"DecodedUrl":
}
}

BUT when I go to SharePoint I can still see the 2 items in the source, and nothing in the destination locations.
I have used the url and it shows no files.

I have done clear cache and refresh, logged on with a different account and still the same. From the second account I can still edit the items in source. But they are still not found in the Get Items...

I have created a completely separate flow and done Get items from ShunterRequests(srcPath)- in Site contents 9 items are displayed as available. When I go Get Items and try and return all items only 7 are returned . When I do Get Items from ArchiveShunterRequests_Ash (destPath) it only shows the folder 2023-01 I was attempting to move the data into.

Perplexed. Any ideas please.

[gcoleman]

@Deepak - If you know you only want to get a single record, why not just use Get Item instead of Get ItemS Then you wouldn't need any array subzero "[0]" in the expression and possibly break under other conditions. Either works, was just curious on your thought process

[patrycjakaminska]

Hi Deepak, do you know how I can move an already existing item to another file? I don't have the manual option in my SharePoint...Is it possible with a flow?

[pruthvi]

Hello I was working on move file but my library had around 500+ files so. I'm getting time out error while the flow runs in background and moves 100 files and then it fails. Please share any idea if you have 🙏🏻

[T_h_e_Best]

Hi, greate video! I have an issue: how can l add, delete, modify data in Sharepoint List using my LOCAL EXCEL file WITH MACROs?
I'm creating a program in local excel with a lot of usefull things, and one of this thing is need to create a task from local file into sharepoint list and via versa!! is it possible? Can you give me some way, direction, how can I do this, what i have to use additionally? thanks in advance

[RyanSmith-mhlj]

Hi Deepak, thank you for the nice video and very informative, I have a list where I need to move a large number of columns to different list (about 7 of them are lookup columns) I have tried but lookup columns don't get move, I am new to Flow, any assistance; much appreciate it!! Thank you

[Galvenable]

MS Link is dead, can you refresh it ? Thanks!