SharePoint Fields

SharePoint fields are based on the columns of the SharePoint List or Library that you connect to. These fields, when added to the form, are automatically connected to the List and will retrieve data from the List, as well as automatically submit user input on save.

It’s recommended to only use SharePoint fields on SharePoint forms unless you want to handle data from the Common fields with JavaScript or Flow. This section contains information about settings for fields that are unique to SharePoint.

Note

If you add another column to the list, while editing its forms, you can refresh fields by clicking refresh fields button:

Refresh SharePoint fields

Basic properties

Most fields have following settings:

General

Name

Setting utilized by many elements. Name is similar to ID, it’s a unique identifier for the element.

Required

Select if the field is required to submit the form or not.

Orientation

Select if the title is displayed on the left from field or on top of it, to the left. Might automatically switch if not enough space.

Class

Give CSS Class to the element, in order to apply JavaScript or CSS Style to it. Can give multiple classes separated by spaces to one element.

Style

Allows you to give specific element certain style. No need to use selectors, simply add CSS rules to this setting.

Title

Text

Select the displayed title for the field.

Visible

Select if the title is visible or not.

Width

Select the width of the title.

Font Size

Select font size of the title.

Font Style

Select if the title is in italics or not.

Font Weight

Select if the title is bold or not.

Font Color

Select font color of the title. Can be either selected or manually entered.

Wrap

Select if the title will wrap if it has not enough space or not.

Control

Width

Allows you to set the width of the input field manually. Only takes number in pixels, no additional symbols required.

Hint

Allows you to set placeholder value for the text input. Can be used as an example for the users.

Font Size

Select font size for the input.

Font Style

Select if the input is in italics or not.

Font Weight

Select if the input is bold or not.

Font Color

Select font color for the input. Can be either selected or manually entered.

Currency and Number

Currency and Number fields have received multiple unique properties to configure.

Currency and Number fields

Currency and Number properties

These properties are unique to Currency and Number fields:

General

Min

Minimum possible value.

Max

Maximum possible value.

Decimals

Number of decimals.

Format

Numeric format for the field.

Step

Value added or removed when using the control’s arrows.

Lookup

Lookup field has received several new features, all of which can be configured in the designer.

Now, users can use search bar to filter the selection in the lookup field. There’s also an option to add new items to the source list, if the item wasn’t found - this could be turned on/off.

Additionally, you can apply a field based filter on the lookup with Filter properties.

Example Lookup

Lookup unique properties

Lookup field has the following unique settings:

General

Operator

Determines how the search is handled by the lookup. Has two options: StartsWith - only show items that start with the entered value, Contains - show all items that contain the entered value.

Add New

Allows users to add new values to the source list of the Lookup. User must enter value that doesn’t exist yet, then there will be an option to add new item.

Extra Fields

Select fields from the list that also need to be loaded. By default, only ID and ‘Display Field’ are retrieved. Extra fields can accessed with JavaScript. When adding Lookup fields in Extra Fields setting, do not forget to format them like this: Category/ID, Category/Title. Uses OData $select query option - read more here.

Expand

In the Expand setting you need to enter the Lookup field that you are getting in Extra Fields, such as: Category. Uses OData $expand query option.

Filter

Depends on

Select what field in the current list will be used for filtering items available in the lookup field. For complex fields, such as Lookup or Person, also select which property to match (ID, Title or Email, Display Name, etc.)

Match to

Select what field in the source list has to match the field selected in Depends on property. For more information on filtering, refer to our Filter lookup fields article.