kk
Forms Fledgling

FormData not available after migration of Nintex Forms from OnPremise to O365

Jump to solution

We have noticed an issue after migrating the forms (using Sharegate) from OnPremise to O365. The FormData field does not seem to have copied over. When we try to query the field

It gives the below message saying “ Field or property ‘FormData’ does not exist“

error.jpg

 

 

 

The data in the field is critical in multiple forms, We wanted to know how this can be ported over

0 Kudos
Reply
10 Replies
SimonMuntz
Nintex Employee
Nintex Employee

Re: FormData not available after migration of Nintex Forms from OnPremise to O365

Jump to solution
Hi,

The form data column is a hidden column.
You may need to ask ShareGate how this can be migrated.
Also please note that the onpremise hidden form data column has a different name in O365.
0 Kudos
Reply
kk
Forms Fledgling

Re: FormData not available after migration of Nintex Forms from OnPremise to O365

Jump to solution

There most likely question from sharegate would be can this field be unhidden for sharegate to be able to pick it up.

In O365 the internal name of the field is the same(FormData) but rest api seem to refer it as NFFormData

0 Kudos
Reply
butlerj
Community Manager Community Manager
Community Manager

Re: FormData not available after migration of Nintex Forms from OnPremise to O365

Jump to solution

@kk this column can be unhidden be editting the List Content Type within SharePoint (see video below), however when it comes to mapping that data to a field in O365, that would be a question the ShareGate team would have to answer for you.

 

0 Kudos
Reply
kk
Forms Fledgling

Re: FormData not available after migration of Nintex Forms from OnPremise to O365

Jump to solution

Thanks for this @butlerj but even after unhiding it in O365 list, the field does not show up in the list/listcontenttype so Sharegate is unable to pick it to allow data copy

0 Kudos
Reply
kk
Forms Fledgling

Re: FormData not available after migration of Nintex Forms from OnPremise to O365

Jump to solution

@butlerj Even in the video you can see that once Form Data is made optional the field does not show up in the contenttype

0 Kudos
Reply
butlerj
Community Manager Community Manager
Community Manager

Re: FormData not available after migration of Nintex Forms from OnPremise to O365

Jump to solution

@kk interesting. Sorry I didn't notice that when capturing the video. I'm actually not 100% sure why that would be given that you can definitely see the column when you go into 'Column Order' so SharePoint knows that it's there 😕


Column Order.pngI will keep doing some investigation and see if I can find a fix for this.

0 Kudos
Reply
kk
Forms Fledgling

Re: FormData not available after migration of Nintex Forms from OnPremise to O365

Jump to solution

It seems its due to the NFFormData/FormData field being "sealed" and part of the "_Hidden" column group

Reply
butlerj
Community Manager Community Manager
Community Manager

Re: FormData not available after migration of Nintex Forms from OnPremise to O365

Jump to solution
@kk I just pinged one of our engineers to see if there's anything that can be done with a "sealed" column once it has been configured that way. My understanding is that there is not, but want to confirm with someone a little closer to the code. Will update shortly.
0 Kudos
Reply
butlerj
Community Manager Community Manager
Community Manager

Re: FormData not available after migration of Nintex Forms from OnPremise to O365

Jump to solution

@kk After doing some testing it appears that you cannot modify the column group (you can make access the column settings at the site level via: https://<SITE URL>/_layouts/15/fldedit.aspx?field=FormData&Source=%2F%5Flayouts%2F15%2Fmngfield%2Easpx%3FFilter%3DAll%2520Groups), as when you try and update it from the _hidden group it just reverts to that group. I've also found that the only way to "unseal" a column is through Visual Studio, and I have no idea what that ramifications of that would be. 

 

This might be a little backwards, but given that the FormData field is just a multiline text field, would it be possible for you to copy the data from that field to a new text column on the list using workflow and then have ShareGate map that field to the new field in O365? 

0 Kudos
Reply