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": "xxxxx/MP_Log_Shunters/Lists/ShunterRequests/8_.000" }, "destPath": { "__metadata": { "type": "SP.ResourcePath" }, "DecodedUrl": "xxxxx/MP_Log_Shunters/lists/ArchiveShunterRequests_Ash/2023-01/MR_8" } } 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 xxxxx/MP_Log_Shunters/lists/ArchiveShunterRequests_Ash/2023-01 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.
@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
I have run in to an issue when the item is saved to the list folder, it replaces the item that existed before it. How would I fix this, I've scanned the video multiple times and do not see where I may have went wrong. Great Video! (after some research I found a work around, see in Reply)
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
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?
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.
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
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
Hi Deepak, thanks to your flow I save a lot of manual effort. As the folders are not existing right now, I put a step before to create a folder automatically for each country. Would you know how I can check before "if folder already created" ?
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?
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 🙏🏻
If you are doing bulk migration and using the "Get Items" action, make sure you go to the action setting and update the Threshold under Pagination to the number of items you have (less than 5000).
I have the same issue and received this error message: The property 'DecodeUrl' does not exist on type 'SP.ResourcePath'. Make sure to only use property names that are defined by the type. clientRequestId: 0f1b3ad3-496f-4328-95fb-11968a5dc0b7 serviceRequestId: 207086a0-a0fb-2000-f3ea-d2b8376e37e6 Thank you in advance for your reply.
I am running into the same issues. I get lang":"en-US","value":"Value does not fall within the expected range." for my error and I cannot figure out what I am doing wrong.
Deepak.. Your demos are crystal clear and easy to remember. Thanks for sharing the valuable tips
Thank you 🙏🏻
6:19, I think you can user Full Path instead of Identifier. Full Path seems to be the decoded Identifier.
Thank you for this - it took me awhile, but I finally moved something!
Amazing !! Thank you for taking the time to create this instruction. It worked perfectly !
Thank you Deepak. This one got me out of a hole🙏
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": "xxxxx/MP_Log_Shunters/Lists/ShunterRequests/8_.000"
},
"destPath": {
"__metadata": {
"type": "SP.ResourcePath"
},
"DecodedUrl": "xxxxx/MP_Log_Shunters/lists/ArchiveShunterRequests_Ash/2023-01/MR_8"
}
}
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 xxxxx/MP_Log_Shunters/lists/ArchiveShunterRequests_Ash/2023-01 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.
This is exactly what I needed. Thank you so much for the simple and detailed explanation. Keep up the great work really appreciated.
You're very welcome!
I always get StatusCode: 404 in my HTTP Request. It says no File not found.. does anyone have an Idea?`
Hi Deepak, is it aplicable just for lists and items, without folders?
@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
i always get error with Array 0, do you know how to fix it?
I have run in to an issue when the item is saved to the list folder, it replaces the item that existed before it. How would I fix this, I've scanned the video multiple times and do not see where I may have went wrong. Great Video!
(after some research I found a work around, see in Reply)
Deepak, how are you? Why do you use decodeUriComponent 3 times?
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
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?
It’s useful 👍🏽
Glad it was helpful!
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.
For file you already have an action available in Power Automate so you directly use that.
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
Check out my following videos , to get some ideas: ua-cam.com/video/mN_Jr8GW64g/v-deo.html , ua-cam.com/video/VeqzlWNQjjE/v-deo.html
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
Hi Deepak,
thanks to your flow I save a lot of manual effort. As the folders are not existing right now, I put a step before to create a folder automatically for each country.
Would you know how I can check before "if folder already created" ?
Thanks for watching. To check folder, one option is to query the library with name of the folder and if you get any result that means folder exist.
Hi what do you do if you column has multiple options. How to handle them?
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?
I am not fully understand your question "move an already existing item to another file?"
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 🙏🏻
If you are doing bulk migration and using the "Get Items" action, make sure you go to the action setting and update the Threshold under Pagination to the number of items you have (less than 5000).
@@DeepakShrivastava Thanks!
Bravo, brillant !
MS Link is dead, can you refresh it ? Thanks!
Thank You. I missed a " )". here is correct link- docs.microsoft.com/en-us/previous-versions/office/sharepoint-server/mt844928(v=office.15)
Looking good until final step. You say "just use standard headers" but I don't see those anuwhere
I have the same issue and received this error message: The property 'DecodeUrl' does not exist on type 'SP.ResourcePath'. Make sure to only use property names that are defined by the type.
clientRequestId: 0f1b3ad3-496f-4328-95fb-11968a5dc0b7
serviceRequestId: 207086a0-a0fb-2000-f3ea-d2b8376e37e6
Thank you in advance for your reply.
I am running into the same issues. I get lang":"en-US","value":"Value does not fall within the expected range." for my error and I cannot figure out what I am doing wrong.
Any further word on this issue Deepak? I'm having the same issue - many thanks.
I need help