Create Item Widget

Click the button to select properties for the new item:

• Site Collection/Site/List Target: To create an item in a list in the current site, select a list in the List Target box. To create an item in a list in another site or site collection, make the desired selections in the Site Collection and Site boxes and then select a List Target.

• Item Fields:

  • Available fields in the list or library are added to the form when you select a List Target. Required list fields (marked with a red asterisk *) are automatically selected.

  • To specify a value for a field, check the box in front of the field name and enter a value using one of the following methods:

    • Choose a field value (for Choice and Yes/No fields)
    • Enter text in the field text box
    • Add a lookup using the Add Lookup icon ()

  • To remove a field from the list of fields to populate, uncheck the checkbox in front of the field name.

  • Use Record Variable: If you want to create an item using data from a Record variable instead of specifying values for each field, check the Use Record Variable box and select an available Record variable. Important notes about Record variables:
  • Record variables contain a single record (row) from the results of a Query Database widget.
  • Columns in the list will be populated with data from the record field with the same name. If your database field names do not match SharePoint column names, use SELECT field AS column.
  • If a column in the list has no matching field in the record, it will be skipped. If the column has a default value configured in SharePoint, the column will be populated with that default value.
  • If a field in the record has no matching column in the list, it will be skipped.
  • If the required SharePoint column Title or Name has no matching field in the record, it will be populated with data from the first field in the record.
  • If other required columns in the list have no matching fields in the record, they will be left blank in the list.

• Overwrite an existing item: Check this box to overwrite an item with the same Name, if one exists in the List Target. This option is available only for libraries.