Re: SharePoint External Content Type - want more than 150 characters.

Patrick Halstead — Mon, 18 Apr 2016 12:15:25 GMT

Hi Catharine,

Have you tried reconverting the main data connection from within InfoPath? Hopefully, that will get it to see the new schema.

Good luck!

SharePoint External Content Type - want more than 150 characters.

Catharine — Mon, 18 Apr 2016 11:40:40 GMT

I am using SharePoint 2010.

I have an External Content Type for which I have created an InfoPath form. The External Content Type is reading/writing from/to an SQL database. This is all working fine.

User feedback is that they want to enter more detail in one of the text fields - (Justification)

I have updated the SQL database for the Justification field to be nvarchar(MAX)

I have refreshed External Content Type connection. In SharePoint designer creation operation shows that Justification has a .net type of system.string. I have tried creating a new table on the ECT and new InfoPath form - but the InfoPath form kicks in with some validation on the Justification field to only allow 150 characters. (This is not validation I have put in.)

What else do I need to do to allow more data to be added to the Justification field?

Thank you

Catharine

SharePoint Integration

Re: SharePoint External Content Type - want more than 150 characters.

SharePoint External Content Type - want more than 150 characters.