Power Automate or Microsoft Flow to move or copy from 2010 SharePoint items to SharePoint online

%3CLINGO-SUB%20id%3D%22lingo-sub-1291777%22%20slang%3D%22en-US%22%3EPower%20Automate%20or%20Microsoft%20Flow%20to%20move%20or%20copy%20from%202010%20SharePoint%20items%20to%20SharePoint%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1291777%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20there%2C%26nbsp%3B%3C%2FP%3E%3CP%3EI%20was%20trying%20to%20get%20items%20to%20new%20site%20using%20the%20Microsoft%20Flow%20but%20this%20tool%20is%20not%20accepting%20the%20old%20site%20name%20HTTP%20%2F%2FDOCS%2FSSP%20What%20is%20the%20fix.%20I%20have%20neither%20access%20to%20SharePoint%20designer%20nor%20I%20know%20much%20about%20the%20coding.%20Here%20is%20a%20picture%20what%20I%20get%20while%20adding%20the%20source%20site%20name.%20Any%20help%20will%20be%20much%20appreciate.%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Power%20Automate%20Flow.jpg%22%20style%3D%22width%3A%20683px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F183066i6FD99FDA4F994AFF%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Power%20Automate%20Flow.jpg%22%20alt%3D%22Power%20Automate%20Flow.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1291777%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1303680%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Automate%20or%20Microsoft%20Flow%20to%20move%20or%20copy%20from%202010%20SharePoint%20items%20to%20SharePoint%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1303680%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F614251%22%20target%3D%22_blank%22%3E%40Nkhatiwada%3C%2FA%3E%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20site%20URL%20does%20not%20look%20valid%20or%20cannot%20be%20translated%20by%20Power%20Automate.%20Try%20using%20the%20fully%20qualified%20URL%20i.e.%20%3CA%20href%3D%22https%3A%2F%2Fyourtenantname.sharepoint.com%2Fssp%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fyourtenantname.sharepoint.com%2Fssp%3C%2FA%3E.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20hope%20this%20helps.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENorm%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1308909%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Automate%20or%20Microsoft%20Flow%20to%20move%20or%20copy%20from%202010%20SharePoint%20items%20to%20SharePoint%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1308909%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Norm%2C%3C%2FP%3E%3CP%3EI%20tried%20different%20things%20to%20get%20the%20URL%20but%20I%20have%20this%20only%26nbsp%3BDavWWWRoot.%20Not%20sure%20why%20the%20url%20has%20back%20slashes.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1309300%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Automate%20or%20Microsoft%20Flow%20to%20move%20or%20copy%20from%202010%20SharePoint%20items%20to%20SharePoint%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1309300%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F614251%22%20target%3D%22_blank%22%3E%40Nkhatiwada%3C%2FA%3E%26nbsp%3Bsorry%20I%20didn't%20notice%20that%20you%20were%20trying%20to%20connect%20to%20SP%202010.%26nbsp%3BThe%20SharePoint%20connector%20only%20supports%26nbsp%3B%3CSPAN%3ESharePoint%202013%20or%202016%20farm%20using%20the%20On-Premises%20Data%20Gateway.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EAre%20you%20able%20to%20migrate%20the%20list%20to%20SPO%3F%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3ENorm%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1309394%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Automate%20or%20Microsoft%20Flow%20to%20move%20or%20copy%20from%202010%20SharePoint%20items%20to%20SharePoint%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1309394%22%20slang%3D%22en-US%22%3E%3CP%3ENot%20all.%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F111382%22%20target%3D%22_blank%22%3E%40Norman%20Young%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20different%20ways%2C%20but%20moving%20files%20and%20list%20from%20SP%202010%20to%20SharePoint%20online%20is%20really%20difficult.%20Microsoft%20created%20a%20really%20good%20app%20Power%20Automate%20to%20create%20the%20flow%20to%20move%2Fcopy%20the%20lists%20but%20doesn't%20support%20SP%202010.%20That's%20little%20thing%20they%20could%20have%20made%20happen.%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20Norm%20for%20getting%20back%20to%20me%20to%20reply%20my%20questions.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1309399%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Automate%20or%20Microsoft%20Flow%20to%20move%20or%20copy%20from%202010%20SharePoint%20items%20to%20SharePoint%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1309399%22%20slang%3D%22en-US%22%3E%3CP%3ECan%20you%20export%20the%202010%20list%20to%20Excel%3F%20If%20so%2C%20Excel%20will%20let%20you%20export%20to%20SharePoint%20as%20a%20new%20list.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1309412%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Automate%20or%20Microsoft%20Flow%20to%20move%20or%20copy%20from%202010%20SharePoint%20items%20to%20SharePoint%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1309412%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F111382%22%20target%3D%22_blank%22%3E%40Norman%20Young%3C%2FA%3E%2C%20Yes%2C%20I%20did.%20It%20worked%20for%20simple%20list%20data%20only.%20Excel%20file%20converted%20People%20and%20Group%2C%20and%20choice%20data%20type%20to%20single%20line%20of%20texts.%20Had%20to%20manually%20correct%20those%20later%20in%20SPO%20after%20migrating.%20Struggling%20now%20to%20move%20the%20attachments%20in%20old%20SharePoint%202010%20list.%20I%20could%20move%20the%20whole%20list%20folder%20to%20SPO%20using%20Windows%20Explorer%20but%20can't%20use%20it%20as%20a%20list%20either.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1309436%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Automate%20or%20Microsoft%20Flow%20to%20move%20or%20copy%20from%202010%20SharePoint%20items%20to%20SharePoint%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1309436%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F614251%22%20target%3D%22_blank%22%3E%40Nkhatiwada%3C%2FA%3E%26nbsp%3Bdid%20you%20look%20into%20the%20SharePoint%20migration%20tool%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsharepointmigration%2Fintroducing-the-sharepoint-migration-tool%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsharepointmigration%2Fintroducing-the-sharepoint-migration-tool%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20says%20it%20supports%202010.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENorm%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1309468%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Automate%20or%20Microsoft%20Flow%20to%20move%20or%20copy%20from%202010%20SharePoint%20items%20to%20SharePoint%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1309468%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F111382%22%20target%3D%22_blank%22%3E%40Norman%20Young%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYes%2C%20that%20was%20my%20final%20option%20to%20go%20with%2C%20but%20our%20IT%20hasn't%20given%20permission%20to%20use.%20Our%20SP%20admin%20team%20only%20has%20access%20to%20this%20tool.%26nbsp%3B%3C%2FP%3E%3CP%3E-Narayan%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Hello there, 

I was trying to get items to new site using the Microsoft Flow but this tool is not accepting the old site name HTTP //DOCS/SSP What is the fix. I have neither access to SharePoint designer nor I know much about the coding. Here is a picture what I get while adding the source site name. Any help will be much appreciate. 

Thanks,

Power Automate Flow.jpg

 

8 Replies
Highlighted

Hi @Nkhatiwada,

 

The site URL does not look valid or cannot be translated by Power Automate. Try using the fully qualified URL i.e. https://yourtenantname.sharepoint.com/ssp.

 

I hope this helps.

 

Norm

Highlighted

Hello Norm,

I tried different things to get the URL but I have this only DavWWWRoot. Not sure why the url has back slashes. 

 

Highlighted

@Nkhatiwada sorry I didn't notice that you were trying to connect to SP 2010. The SharePoint connector only supports SharePoint 2013 or 2016 farm using the On-Premises Data Gateway.

 

Are you able to migrate the list to SPO?

 

Norm

Highlighted

Not all. @Norman Young 

I tried different ways, but moving files and list from SP 2010 to SharePoint online is really difficult. Microsoft created a really good app Power Automate to create the flow to move/copy the lists but doesn't support SP 2010. That's little thing they could have made happen. 

Thank you Norm for getting back to me to reply my questions.

Highlighted

Can you export the 2010 list to Excel? If so, Excel will let you export to SharePoint as a new list.

Highlighted

@Norman Young, Yes, I did. It worked for simple list data only. Excel file converted People and Group, and choice data type to single line of texts. Had to manually correct those later in SPO after migrating. Struggling now to move the attachments in old SharePoint 2010 list. I could move the whole list folder to SPO using Windows Explorer but can't use it as a list either. 

Highlighted
Highlighted

@Norman Young 

Yes, that was my final option to go with, but our IT hasn't given permission to use. Our SP admin team only has access to this tool. 

-Narayan