Before a value is updated on SharePoint, it is validated.
The validation is also performed when “Test-Run” is executed.
InvalidData.txt Report is embedded in the Job Log
Fusion supports the following SharePoint column types:
| Type | Validation |
| Single line of text | Data is truncated at 255 characters. |
| Multiple lines of text | No validation |
| Choice | No validation. Multiple choices are separated by ; or ;# |
| Number | Validated to be a numeric value. |
| Currency | Validated to be a numeric value. |
| Date and Time | Validated to be a valid date and time. |
| Lookup | Validated to be a value that exists. Site column lookups are also supported. Multiple values are separated by ;# or ; Read more |
| Yes/No | Validated to be a boolean value (Yes,No,True,False,On,Off,1,0) |
| Person or Group | Validated for existence in SharePoint. Multiple users are separated by ;# or ; |
| Hyperlink | Not validated |
| Enterprise Keywords | Validated and transformed into the format SharePoint accepts.Remove illegal charterers. Keywords are automatically added to the SharePoint Term Store |
| Managed Metadata | Terms are validated for existence. |
Need more help with this?
DON'T HESITATE TO CONTACT US HERE ..