zerg00s / flowpowerappsmigrator Goto Github PK

Hello @Zerg00s

I'm having this issue where i'm trying to migrate some lists between two different organizations, the source site is our own organization Tenant and the target site is the client's Tenant, I have the TotalControl-Permission Level Credentials in both Tenants, but I can't login in the target site, The migrator tries to login with my source site credentials on the target site, and when i use the clear login cache option pops an error saying that my user does not have required permissions.

The first error is the next one (without using the ClearCacheOption):

Obs: I have the MFA with the Authenticator App in my source site credential and im using the current version of the Migrator (V.3.8.4).

Really hope I can get some help in this, is really important for finishing our project.

Hi Denis,

is your tool supporting customized list forms, too?

I used PnP Provisionig Engine to create the same list at another site. I customized the list form in the source, exported the package and used your tool to update the json files. Then I imported the zip package (create as new and updated the ressource name) in my tenant getting the error "An App already exists for this list. Remove the existing App before adding a new one."

I checked the json file inside the zip package and the guid of the source list has been updated by the guid of the destination list.

If I perform this process again I am getting the error: "You have already created an application with this name. Please specify a different name. "

But where is this application? The form is not bound to the destination list neither listed under Apps.

Do you have any ideas?

I'm receiving the following error when running the migrator:

ForEach-Object : You cannot call a method on a null-valued expression.
At C:\Users\steven.messier\Downloads\FlowPowerAppsMigrator\GenerateInitialMapping.ps1:16 char:10

• $lists | ForEach-Object {

•      ~~~~~~~~~~~~~~~~
  

  • CategoryInfo : InvalidOperation: (:) [ForEach-Object], RuntimeException
  • FullyQualifiedErrorId : InvokeMethodOnNull,Microsoft.PowerShell.Commands.ForEachObjectCommand

I've looked at the PowerShell script and I can't tell what null value it's referencing. I've verified the URLs for the target and source are correct.

When I either double-click or run as administrator the Migrate-Packages.bat nothing happens after I press any key in the cmd.exe window.

The UI screens do not appear.

-Bob

I logged on the mfa with wrong credentials one time and now the login window will not show again. What can I do to make the old credentials not to be remembered?

Hi
I am testing your solution when trying to migrate a list with Power Apps customized form.
I want to move it from tenant A to tenant B.
I have manually created the list in both tenants.
It is a simple list with 4 columns "Title", "Description" (multifield), "Status" (choice field) and "Manager" (person field).

But I get the error message as seen below.
[Error] Invalid field name. {2b67bcd7-14d4-4c13-85dd-605eb8109b5e} https://xxx.shareoint.com/sites/TESTplanering

Apply-PnPProvisioningTemplate : The field was found invalid:
At C:\Users\Downloads\FlowPowerAppsMigrator\MISC\Move-Lists.ps1:124 char:9

•     Apply-PnPProvisioningTemplate -Path Lists.xml
  

•     ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  

  • CategoryInfo : WriteError: (:) [Apply-PnPProvisioningTemplate], Exception
  • FullyQualifiedErrorId : EXCEPTION,PnP.PowerShell.Commands.Provisioning.Site.ApplyProvisioningTemplate

I have a powerapps form developed in a document library that helps to work with metadata of the library. Now I want to copy that PowerApps form and copy it across multiple libraries in the same site. Your solution looks like it will only work if the destination lists are in a different site (so the lists name are same even when they are coped across?), am I right? If this solution only work for lists/library that exist in different site, please let me know.

Nevertheless, I tried to run the "Migrate-Packages" batch file and I get an error
"The term '.\RunAllScripts.ps1' is not recognized as the name of a cmdlet, function, script file, or operable
program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again."

Can you please help me? Much appreciated.

I was wondering if anyone has had this issue:

The tool ran with no issues, and I could import the converted package into my target tenant. Still, when testing the app, in the gallery where I display the sharepoint data, I received an error stating the list ID was not recognized, meaning the app was connecting to the list properly. This is interesting because I was authenticated correctly with the target tenant and also, when I click on edit data source it correctly re-directs me to the correct sharepoint list in question.

Is there any artifacts from the source tenant that can linger within the .maspp file that could cause this error? Because the JSON files within the zip file all correctly map to the target tenant.

Also, I want to point out that during the import phase the second part of the import when you select the account to use for the connections required for the powerapp, there were NO connections listed. I believe this might be something related.

I'm running the current version. I have a SharePoint list form customized with PA. I tick the list, but in the target site nothing changes. I've tried several times, starting with different situations in the target site, i.e.
-- The list exists with an old version of the form
-- the list exists with the SharePoint native form, no PowerApps
-- the list exists with no columns and no form
In all the above cases, the list remains exactly the same after running the code. Watching the PowerShell window, I see the following prompts
-- Extracting Template from https://something.com/sites/MySourceSite
--Applying template to https://something.com/sites/MySourceSite

It looks to me as if the template is extracted from the source site, but it is then not applied to the target site, but back to the source site. Can you check that?

I am a site collection admin on both sites and also a global admin on the tenant. This worked on the earlier version, but after the upgrade I did today, it hasn't worked. I got colleague of mine to log in with his user (FlowPowerAppsMigrator workes on his pc), but he got the same error. Any suggestions?

I have used this a couple time with no issues but now I am trying to convert a flow the source and the Destination are in the same domain but different sites which has worked before and I am getting the following error. I have done this same thing with others without this being an issue. Just not sure what is different in this case. Any help or suggestions I would be very grateful.
Thank you

ForEach-Object : The property 'newId' cannot be found on this object. Verify that the property exists and can be set.
At C:\Users\Public\Utilities\FlowConverter383\CompleteResourceMapping.ps1:19 char:10

• $lists | ForEach-Object {

•      ~~~~~~~~~~~~~~~~
  

  • CategoryInfo : InvalidOperation: (:) [ForEach-Object], RuntimeException
  • FullyQualifiedErrorId : PropertyAssignmentException,Microsoft.PowerShell.Commands.ForEachObjectCommand

I experience error with running the script

Hi Zerg00s,

I'm migrating a Power Apps solution and one site and 1 list. I see this error:

Importing lists and libraries...
[Error] Value does not fall within the expected range.
Apply-PnPProvisioningTemplate : Value does not fall within the expected range.
At C:\Users\ThomasMichelsen\Downloads\FlowPowerAppsMigrator-master\FlowPowerAppsMigrator-master\MISC\Move-Lists.ps1:124 char:9
+         Apply-PnPProvisioningTemplate -Path Lists.xml
+         ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : WriteError: (:) [Apply-PnPProvisioningTemplate], ServerException
    + FullyQualifiedErrorId : EXCEPTION,PnP.PowerShell.Commands.Provisioning.Site.ApplyProvisioningTemplate

NB: If I exclude the site and list, I get this warning: "Løsningen "Tencate Ordering System" blev importeret med advarsler: Translated labels for the following languages could not be imported because they have not been enabled for this organization: 1033". Is that because I have different languages in the two Sharepoint environments?

Best regards,
Thomas

The following error message is displayed during a conversion:

Enter the URL of the original (old) SharePoint site: [OLD_SITE_URL]
WARNING: A newer version of PnP PowerShell is available: 3.23.2007.1. Consider upgrading.
resourceMapping.csv generated
Enter the URL of the destination SharePoint site: [NEW_SITE_URL]
resourceMapping.csv fully complete
Converting SiteUrl ...Done.
ForEach-Object : The term 'resources[$i].newId' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.
At C:\Development\Microsoft\FlowPowerAppsMigrator-master-mfa\ConvertPackage.ps1:20 char:14

• $files | ForEach-Object {
  

•          ~~~~~~~~~~~~~~~~
  

  • CategoryInfo : ObjectNotFound: (resources[$i].newId:String) [ForEach-Object], CommandNotFoundException
  • FullyQualifiedErrorId : CommandNotFoundException,Microsoft.PowerShell.Commands.ForEachObjectCommand

I'm using MFA, so to get to this point I had to add -UseWebLogin after the site URL in your PowerShell scripts. I'm not sure if this has a knock on effect or it's something else?

I'am using the following versions:

Microsoft.Online.SharePoint.PowerShell 16.0.9021.0
SharePointPnPPowerShellOnline 3.23.2007.1
SharePointPnPPowerShellOnline 3.12.1908.1
SharePointPnPPowerShellOnline 3.6.1902.2

Your help would be much appreciated.

Regards

Rob

I got a list with a powerapp form that is named "Requests (Client name)". I'd like to copy the form to another site meant for another client, execpt the list is called "Requests (Other client Name)". How can I do this?

I already know I need to deactivate migrating the lists, and that it does works if you rename the list as "Requests (Client name)" and back, but is there an easier way?

The app was created/attached right from the list. So I am not sure if that is the issue.

Apply-PnPProvisioningTemplate : Object reference not set to an instance of an object on server. The object is
associated with method GetList.
At C:\Users\Mark\Downloads\FlowPowerAppsMigrator-master\FlowPowerAppsMigrator-master\MISC\Move-Lists.ps1:78 char:5

• Apply-PnPProvisioningTemplate -Path Lists.xml
  

• ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  

  • CategoryInfo : WriteError: (:) [Apply-PnPProvisioningTemplate], ServerObjectNullReferenceException
  • FullyQualifiedErrorId : EXCEPTION,PnP.PowerShell.Commands.Provisioning.Site.ApplyProvisioningTemplate

When running migrations, App & Flow Migrator will not warn users if they forgot to add .ZIP files to the src folder. There must be some a check implemented. For example, we need to show a warning and then check if the ZIP files were inclded.

Hello, when the script is going to recreate the lists I get this error message. I don't have this field in my lists. Any ideias? Thank you.

Hi,

Maybe I'm wrong but seems in the script RunAllScripts, the line 65 must be after the import of the selected lists.
Is it correct ?

Best wishes for 2022

When importing a solution on the powerapps platform following message occurs and the import fails:

"SharepointChangeNotAllowed Message: The listId and siteId of SharePoint cannot be changed."

Hi @Zerg00s,
While Importing existing list & libraries in target sit gives an error.

[Attention] Look for a login popup in a separate window. Please, log in to the source site site https://04xd3.sharepoint.com/sites/Federal Connected to the source site Site: https://04xd3.sharepoint.com/sites/Federal
User: Firdos Shaikh ([email protected])
Mapping file resourceMapping.csv is generated
C:\Users\YusufShaikh\Downloads\FlowPowerAppsMigrator
Exporting lists and libraries...
[Attention] Look for a login popup in a separate window. Please, log in to the target site https://t1jtk.sharepoint.com/sites/Federal.

Connected to the target site
Site: https://t1jtk.sharepoint.com/sites/Federal
User: Harsh Markad ([email protected])
Applying PnP Template to https://t1jtk.sharepoint.com/sites/Federal
C:\Users\YusufShaikh\Downloads\FlowPowerAppsMigrator
Importing lists and libraries...
[Error] Make sure that both target site and the source sites created with the same language. Cross-language list migration is not supported.
Apply-PnPProvisioningTemplate : Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
At C:\Users\YusufShaikh\Downloads\FlowPowerAppsMigrator\MISC\Move-Lists.ps1:124 char:9

•     Apply-PnPProvisioningTemplate -Path Lists.xml
  

•     ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  

  • CategoryInfo : WriteError: (:) [Apply-PnPProvisioningTemplate], ServerUnauthorizedAccessException
  • FullyQualifiedErrorId : EXCEPTION,PnP.PowerShell.Commands.Provisioning.Site.ApplyProvisioningTemplate
    Press any key to continue . . .

But i have created one new list in same source site & import to same target site its exported successfully.

When exporting lists following exception occurs:
Exporting lists and libraries...
Hidden fields count:
.......\FlowPowerAppsMigrator\MISC\Move-Lists.ps1 : You cannot call a method on a null-valued
expression.
At C:\Users\stefa\Downloads\FlowPowerAppsMigrator\RunAllScripts.ps1:98 char:5

• . .\MISC\Move-Lists.ps1 -Path $Path -MigrationType Export -Source ...
  

• ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  

  • CategoryInfo : InvalidOperation: (:) [Move-Lists.ps1], RuntimeException
  • FullyQualifiedErrorId : InvokeMethodOnNull,Move-Lists.ps1

It runs for 1 minute and I get this error message everytime, tried 5 times

This is the first time i am trying this tool. As soon as i run the bat file I get this error.

Get-FormItemProperties : The term 'Get-FormItemProperties' is not recognized as the name of a cmdlet, function, script
file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct
and try again.

This is the command window output.

Text of the error:
Converting SiteUrl ...Done.
ForEach-Object : The term 'resources[$i].newId' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.

Hi @Zerg00s,

I'm facing some issues while migrating from one site to another. During testing, I've encountered errors related to connectivity and permissions.

When trying to migrate a list from the source site, I encountered this error:

Another issue I'm having is that the login popup for the target site permission isn't opening. It appears to automatically log in with the source login information, and I'm not able to see the target login popup.

Lastly, when setting Clear Credentials to True, two login popups appear. After logging in to one of them, the other one closes automatically and I receive this error:

Any help in resolving these issues would be greatly appreciated. Thanks!

When it copies the list, should it also copay the content? If not, can that option be added?

Didn't see this issue posted so thought I'd share my experience and workaround. I encountered this error attempting to migrate a list containing calculated list columns:

[Error] The formula contains a syntax error or is not supported.
Apply-PnPProvisioningTemplate : The formula contains a syntax error or is not supported.
At C:\.....\Move-Lists.ps1:124 char:9
+         Apply-PnPProvisioningTemplate -Path Lists.xml
+         ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : WriteError: (:) [Apply-PnPProvisioningTemplate], ServerException
    + FullyQualifiedErrorId : EXCEPTION,PnP.PowerShell.Commands.Provisioning.Site.ApplyProvisioningTemplate

Since it choked in the middle of list provisioning, I looked at the migrated list and saw only a portion of the expected fields were provisioned just shy of where the first calculated field should have been created. I looked at the Calculated field types with Formulas in the Lists.xml and noted that fields were being referenced as such : [{fieldtitle:InternalName}]

Did some digging and found similar issues reported with Apply-PnPProvisioningTemplate such as this post suggesting that a difference between how the field is defined vs what PnP provisioning expects and suggested changing [{fieldtitle:InternalName}] to just [DisplayName] as workaround.

As such I reran the migration, this time using the Prepare-Deployment-Package-For-Client script vs RunAllScripts so I can edit the Lists.xml before continuing on. Made the changes in the package and continued with running Convert-packages.bat and it successfully completed. Confirmed the target list looked good then finished off by importing my power apps form.

When SharePoint connectors are used in PowerAutomate, your tool does a great job of updating all the LIST Guids, but if the option "Limit Columns by View" is selected and a view is chosen, even if that view exists with the same name at the destination, the tool does not update those, we have to manually go in and fix these..

.

Individual FLows and Power Apps can be converted just fine, however, Solution Package conversion is not yet supported.
Need to update the code to support packages as well.

Is it possible to migrate to a subsite on the existing site?

It didn't seem to work when I attempted. There was a warning message during the Migrate-Packages that said "template contains fields and you are provisioning to a subweb. If you still want to provision these fields, set the ProvisionFieldsToSubWebs property to true."

Thank you.

Has anyone tried to migrate an app after the recent MFA update?

The login itself seen successful, but I'm told I don't have the right permissions. (I have migrated this app about 2 months ago successfully).

[Attention] Look for a login popup in a separate window. Please, log in to the source site site https://###.sharepoint.com/sites/###
[Error] make sure you have FULL CONTROL at the source site: https://###.sharepoint.com/sites/###
If you already have enough permissions, try running the script with CLEAR_CREDENTIALS_CACHE set to True
Get-PnPList : The remote server returned an error: (403) Forbidden.
At C:\Users\arascanu\Downloads\FlowPowerAppsMigrator-master\FlowPowerAppsMigrator-master\GenerateInitialMapping.ps1:20
char:14

• $lists = Get-PnPList -Includes Views, Fields, DefaultView
  

•          ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  

  • CategoryInfo : WriteError: (:) [Get-PnPList], WebException
  • FullyQualifiedErrorId : EXCEPTION,PnP.PowerShell.Commands.Lists.GetList

I'm trying to migrate a Power App customized list between two SharePoint online tenants. It connects to the source and exports the templates. However when it tries to connect to the destination tenant, the Invoke-PnPSPRestMethod on line 90 in RunAllScripts.ps fails with the following error

Invoke-PnPSPRestMethod : Object reference not set to an instance of an object.
At C:\Users...\source\FlowPowerAppsMigrator\RunAllScripts.ps1:90 char:13
+ $Response = Invoke-PnPSPRestMethod -Url "$TARGET_SITE_URL/_api/web/cu ...
+ CategoryInfo : WriteError: (:) [Invoke-PnPSPRestMethod], NullReferenceException
+ FullyQualifiedErrorId : EXCEPTION,PnP.PowerShell.Commands.Admin.InvokeSPRestMethod

I have commented out line 90 and the script was able to continue.
I am running Windows PowerShell in Administrator mode.
MFA is disabled on the destination tenant.
I get the same error if I try calling Invoke-PnPSPRestMethod directly

This could be feature more than issue. I have below scenario

I used this tool and successfully moved solution from one tenant to another. Worked great.

I have small change in source power automate. I made that change. Next time i ran the tool, I did not want to migrate Sharepoint artifacts (since there is no change and it takes too much time). So , I did not select any list from popup and clicked ok. I expected, just new solution to be created without artifacts. However, i received below error.

On side note, thanks a lot for creating this. Makes life so much easier!!!

Short explanation

• Around February/March, 2022, Migrated Power App forms stopped working. After a migrated App is imported to the new tenant, it does not appear in a SharePoint List form.

From my research, I've noticed that an imported Power App does not trigger several SharePoint-specific artifacts to be created.

Bonjour,
Running the app to copy a PowerApp List form from one SPOnline site to another on same tenant. Classic Teams site in french.

I'm getting _Error: An error occurred while parsing EntityName. Line 207, position 168 while running the .bat

But looking at the TraceOutput.txt log file, i get

Note : Source list and PA form has 200+ fields

Any help welcome!

When running the script using a forward slash (/) at the end of the Source and Destination URL the replace doesn't work because the export files don't have trailing slashes. Maybe it would be good to make this clear on the instructions or remove the trailing slash automatically.

First time attempting using this so I may be doing something wrong but I can get passed this error after signing into both tenants.
Get-PnPList : The remote server returned an error: (403) Forbidden.
At C:\Temp\Flow Power App Migrator\GenerateInitialMapping.ps1:21 char:10

• $lists = Get-PnPList -Includes Views, Fields, DefaultView

•      ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  

  • CategoryInfo : WriteError: (:) [Get-PnPList], WebException
  • FullyQualifiedErrorId : EXCEPTION,PnP.PowerShell.Commands.Lists.GetList

I can successfully import a powerapp canvas and powerapp sharepoint form, but when it comes to opening them I get the following error:

Login dialogs do not pop up, immediate error. Source and destination require MFA. For some reason I'm unable to use -Interactive on the Connect-PNPOnline. I receive the error: A parameter cannot be found that matches parameter
name 'Interactive'. This does not occur when connecting from within PowerShell. All other methods show 403 forbidden

Hi
Please find the issue in the following image. The message says that the access to the source account is forbidden(403). As I have given the permission as owner to the account.

https://themaverics-my.sharepoint.com/:i:/p/sumidha_r/EYI6_eJYAxhLtos7h-Mre14BfDhqSXT22NUv9kz2qnpItA?e=aGB7ws

Hi

When we execute the 'RunAllScripts.ps1. file, and mention the source & destination lists, the program doesn't copy the content type associated with the source list across to the destination list.

Can you please advise if this feature is not included in the migrator?

Thanks a lot!

The "Word Online (Business)" actions are not converting.

Hello,
thanks for such amazing tool.
there is SecurityEroor then I run Migrate-Packages.bat : RunAllScripts.ps1 is not digitally signed. You cannot run this script on the current system.
I have run directly .\RunAllScripts.ps1 with Bypass : Set-ExecutionPolicy -Scope Process -ExecutionPolicy Bypass
Next Error was that Path is initiated in bat file and after change first lines in RunAllScripts.ps1 to $Path = /...... /myactualpathtofolder/ its works.
is there way to add Bypass directly in bat file?

Best Regards,
Keti

Hi !
I faced with error while trying to move form from one list to another into one site
.

Is it possible for Migrator or it works just for different sites?

Get-pnpProvisioningTemplate : {"odata.error":{"code":"-2147024891,
System.UnauthorizedAccessException","message":{"lang":"en-US","value":"Attempted to perform an unauthorized
operation."}}}
At E:\ABG\FlowPowerAppsMigrator\MISC\Move-Lists.ps1:61 char:9

•     Get-pnpProvisioningTemplate -ListsToExtract $titles -Out "Lis ...
  

•     ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  

  • CategoryInfo : WriteError: (:) [Get-PnPProvisioningTemplate], Exception
  • FullyQualifiedErrorId : EXCEPTION,PnP.PowerShell.Commands.Provisioning.Site.GetProvisioningTemplate

Apply-PnPProvisioningTemplate : Access is denied.
I get this error

user has full control access on the site