SharePoint - How to set more than 255 characters on a field through workflow?

Asked By Jacques Lopes dos Santos on 18-Jun-12 12:15 PM
Hi,

I have a form library in SharePoint that stores forms with a field in blank. Through the workflow that I've created for this
library I was able to set that, when the approver approves the file, it should fill that field in blank with information
got from the approver's account. It worked fine for some users, but sometimes the amount of information that the user have is big enough to surpass the 255 characters restriction that the String field have. So, I've tried to change the type of the field to rich text, but that type is not able to get edited by the sharepoint workflow, then I've tried to create a way to use a repeating table for filling each row with the information got from the approver's account but I was unsuccessful.

Does anyone know a solution for this?
I will appreciate any kind of help.
Thanks!
D Company replied to Jacques Lopes dos Santos on 18-Jun-12 09:38 PM
Give a try to this example.

http://office.microsoft.com/en-us/sharepoint-designer-help/watch-this-run-a-workflow-when-a-specific-field-changes-HA010256419.aspx
Jitendra Faye replied to Jacques Lopes dos Santos on 19-Jun-12 12:54 AM
If you want more that 255 characters then use multiline field.

refer this link-

http://social.technet.microsoft.com/Forums/en-US/sharepoint2010customization/thread/71e7e11f-516b-4fed-9d4c-559278b3b6de/
Jacques Lopes dos Santos replied to Jitendra Faye on 19-Jun-12 09:48 AM
Thanks guys, to solve my problem I just created 3 fields, made the workflow fill each one with 5 rows from the user's account and then set a fx box inside the form just to show the concatenation of those fields. The difficult part was creating a workflow variable and then set it to get incremented by 1 after each row was get. However, in the end, everything just worked fine. Thanks again and good luck on your new challenges.
Ravinder Jamgotre replied to Jacques Lopes dos Santos on 11-May-16 05:17 AM
You have to check the Allow unlimit length checkbox on the list column's properties page
Ravinder Jamgotre replied to Jacques Lopes dos Santos on 11-May-16 05:19 AM
You can also achieve programmatically with C# or PowerShell

[void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint")
 
#Get-SPSite cmdlet for MOSS 2007
function global:Get-SPSite($url)
 {
    return new-Object Microsoft.SharePoint.SPSite($url)
 }
 
#Get-SPWeb cmdlet for MOSS 2007
Function global:Get-SPWeb($url)
{
  $site= New-Object Microsoft.SharePoint.SPSite($url)
        if($site -ne $null)
            {
               $web=$site.OpenWeb();
        
            }
    return $web
}
   
  #Parameters
  $web = Get-SPweb "<a class="vglnk" href="http://sharepoint.crescent.com/regions/emea/se/" rel="nofollow"><span>http</span><span>://</span><span>sharepoint</span><span>.</span><span>crescent</span><span>.</span><span>com</span><span>/</span><span>regions</span><span>/</span><span>emea</span><span>/</span><span>se</span><span>/</span></a>"
  $ListName = "Employee of the Month"
  $FieldName = "Desciption"
  
  #Get the List
  $list = $web.lists[$ListName]
  
  #Set the "Allow unlimited length in document libraries" option to true programmatically
  $list.Fields[$FieldName].UnlimitedLengthInDocumentLibrary= $true
  
  #Update the Field
  $list.Fields[$FieldName].update()


Read more: http://www.sharepointdiary.com/2014/01/this-field-can-have-no-more-than-255-characters.html#ixzz48KyNpzy4