Choosing the right trigger conditions is the first step to building a precise and reliable automation. When you set up a trigger condition, you need to know which field types are supported by Automate365. This article provides a comprehensive list of all supported data types, organized by the system you are connected to, to help you design your automation conditions effectively.
Generic supported data types
Automate365 supports a range of common data types across various systems. These are the fundamental types you'll often encounter when defining your automation conditions:
String: Text-based values (e.g., names, descriptions, short phrases).
Char: Single-character values.
Date and DateTime: Dates and timestamps, allowing for time-based conditions.
Integer: Whole numbers (e.g., quantities, IDs).
Long: Larger whole numbers.
Decimal: Numbers with decimal points, suitable for financial or precise measurements.
Boolean: True/False or Yes/No values.
Note: When you connect to a data source using an API, the list above serves as your reference for supported field types.
SharePoint list columns
List column type | Underlying data type | Supported |
Calculated column | Calculated | ✅ |
Choice | Choice | ✅ |
Currency | Number | ✅ |
Date and Time | Date | ✅ |
Hyperlink | Link | ❌ |
Image | Image | ❌ |
Location | Location | ❌ |
Managed Metadata | Metadata | ❌ |
Multiple Lines of Text | Text | ✅ |
Number | Number | ✅ |
Person or Group | People | ❌ |
Single line of text | Text | ✅ |
Yes/No (boolean) | Boolean | ✅ |
JIRA custom fields
Custom field type | Underlying data type | Supported |
Boolean | Boolean | ✅ |
Date Picker | Date | ✅ |
Date Time Picker | Date | ✅ |
Labels | Text | ✅ |
Multi-Line | Text | ✅ |
Number | Number | ✅ |
Select List (cascading) | Choice | ❌ |
Select List (multiple choices) | Choice | ✅ |
Select List (single choice) | Choice | ✅ |
Single Line | Text | ✅ |
User Picker (multiple users) | People | ❌ |
User Picker (single users) | People | ❌ |
URL Field | Link | ❌ |
ServiceNow fields
Field type | Underlying data type | Supported |
Choice | Choice | ✅ |
Date | Date | ✅ |
Date-Time | Date | ✅ |
Decimal | Number | ✅ |
Due-Date | Date | ✅ |
Duration | Date | ❌ |
Image | Image | ❌ |
Integer | Number | ✅ |
List | Text | ✅ |
Journal | Text | ✅ |
Reference | Text | ✅ |
String | Text | ✅ |
Suggestion | Text | ✅ |
Time | Date | ❌ |
True-False | Boolean | ✅ |
URL | Link | ✅ |