Form-Based App with AI and SharePoint

Background and Setup

Examples

(External) GenAI for Building Master – Detail Forms
Examples - Step-by-step use case examples, information about what types of examples are provided in the AgilePoint NX Product Documentation, and other resources where you can find more examples.

Prerequisites

An AgilePoint license that supports GenAI.
These access rights:
- Enable App Builder Access
- Create, Delete, And Import Apps
- Create Process Models
- Allow Generative AI Access
For more information, refer to:
- Roles
- (Example) Add a Role
On the App Builder > Common > Settings tab, turn on these settings:
- Generative AI
- Let AI Decide
AgilePoint NX OnDemand (public cloud), or AgilePoint NX PrivateCloud or AgilePoint NX OnPremises v9.0 Software Update 1 or higher.

Good to Know

SharePoint does not have a date-only data type. If you configure a field in SharePoint to show the date only, it is stored in SharePoint as date-time in UTC format. The regional settings of the SharePoint site where this value is stored can result in data changes based on the time zone.
If you want to use time zone conversion for a date-only value in SharePoint, AgilePoint recommends you use a field that is not data-bound. If a SharePoint date-time field is configured to show the date only, a data-bound field will always send an absolute date.
These time zones are not supported for SharePoint data-bound date-only fields. If the regional settings for your SharePoint site is configured to use one of these time zones, you might see a different date in the SharePoint UI.
- UTC – 11:00 Coordinated Universal Time-11
- UTC – 12:00 International Date Line West
When you create a new app, the first version is automatically checked in.
After you create a form-based app, you cannot change the app to use a different data source. For example, you can not change a form-based app to use a different entity or SharePoint list than the one specified when the app was created. This limitation also applies to cloned apps. That is, you cannot clone a form-based app, and then change the data source in the cloned app.
Once configured, the primary data source in a data source bound app cannot be deleted. Deleting the primary data source can lead to unexpected behavior or errors in your app because it is the main source of data for the app.

How to Start

Click App Builder.
On the App Builder Home screen, click Add App.
On the What type of app would you like to build? screen, click Form-Based App.

What type of app would you like to build? screen

Configures the type of app to create.

Fields

Field Name	Definition
App Type	Description: Specifies the type of app to create. Allowed Values: Processed-Based App - Creates a process-based app. Form-Based App - Creates a form-based app. Default Value: Process-Based App

How will people identify your app? screen

Configures the basic information for your app.

Fields

Field Name	Definition
App Name	Description: Specifies a name for your app. Allowed Values: One line of text (a string). Accepted: Letters Numbers Spaces Default Value: None
Language	Description: Specifies the language for your app. Allowed Values: A language from the list. Default Value: None Accepts Variables: No
Category	Description: Specifies a category for your app. Allowed Values: A category from the list. The category list comes from Tenant Settings > Categories tab. Default Value: None
Description	Description: An optional description for your app. Allowed Values: More than one line of text. Default Value: None
Enable Collaborative Development	Description: Specifies whether app designers can use collaborative development to work on the app. Allowed Values: Selected - App designers can use collaborative development to work on the app. Deselected - Collaborative development is not enabled for the app. Only one user at a time can check out the files for the app. Default Value: Deselected Example: Refer to: (Example) Open an App in a Collaborative Development Mode Limitations: On the App Builder > Common screen (Settings), turn on Allow Collaborative Development For Apps. This field is available in these releases: AgilePoint NX OnDemand (public cloud) AgilePoint NX PrivateCloud or AgilePoint NX OnPremises v9.0 or higher

Do you want create widget form (not typical) screen

Specifies whether to create a widget form.

Good to Know

Widget forms are not supported for GenAI.

Procedure

On the Do you want create widget form (not typical) screen, click Not Required.
Click Next.

Do you want AI to create your form? screen

Specifies whether to create the form with GenAI.

Fields

Field Name	Definition
Create Form With AI / Auto Generate Form From SharePoint / Create Form Myself	Description: Specifies whether to create an eForm with GenAI. Allowed Values: Create Form With AI - GenAI creates the form based on input the app designer provides as a prompt. For more information, refer to Form-Based App with AI. Auto Generate Form From SharePoint - Creates the form with a SharePoint list. Create Form Myself - Opens the Where do you want to store the data for your app? screen to let you create the form. For more information, refer to: Form-Based App with an Existing AgilePoint Data Entity as the Data Source (Modern) Form-Based App with a Database as the Data Source (Modern) Form-Based App with Salesforce as the Data Source (Modern) Form-Based App with SharePoint as the Data Source (Modern) Form-Based App with Microsoft Excel as the Data Source (Modern) Default Value: Create Form With AI

Field Name

Definition

Create Form With AI / Auto Generate Form From SharePoint / Create Form Myself

Description:

Specifies whether to create an eForm with GenAI.

Allowed Values:

Create Form With AI - GenAI creates the form based on input the app designer provides as a prompt.
For more information, refer to Form-Based App with AI.
Auto Generate Form From SharePoint - Creates the form with a SharePoint list.
Create Form Myself - Opens the Where do you want to store the data for your app? screen to let you create the form.
For more information, refer to:

Default Value:

Create Form With AI

How do you want to set up your entity? > Configuration tab

Configures how to get data from SharePoint for your app.

Fields

Field Name	Definition
Data Source Name	Description: Specifies a name for your data source. Allowed Values: One line of text (a string). Not Accepted: Spaces Default Value: None Accepts Variables: No
SharePoint	Description: Specifies the access token that connects to your SharePoint site. Allowed Values: A list of access tokens configured for your environment. Default Value: None Accepts Variables: No Example: Refer to: (Example) Create a SharePoint Access Token
Create	Opens this Screen: Access Token for SharePoint Function of this Screen: Configure an access token to connect to SharePoint. Example: Refer to: (Example) Create a SharePoint Access Token
Site URL	Description: Specifies the URL for your SharePoint site. Allowed Values: A valid SharePoint site URL. Default Value: None Accepts Variables: No Example: http://[machine name]:[port]/sites/[site name] Note: You must include the /sites in the Site URL for the site to be created successfully.
List Name	Description: Specifies the name of the SharePoint list. Allowed Values: The name of your SharePoint list. Default Value: None Accepts Variables: No

How do you want to set up your entity? > Fields tab

Specifies the fields from your SharePoint list to use in your app.

Prerequisites

Complete the How do you want to set up your entity? > Configuration tab.

Fields

Field Name	Definition
Show Internal Fields	Description: Specifies whether to show the default fields in the SharePoint list. Allowed Values: Selected - Shows the default fields in the SharePoint list. Deselected - Does not show the default fields. Default Value: Deselected
Check box	Description: Specifies whether to show a SharePoint field on your process. Allowed Values: Selected - Your process contains the field. Deselected - The field does not show on your process. Default Value: Selected
Display Name	Description: Shows the fields in your SharePoint list. Allowed Values: Read only.
Data Type	Description: Shows the data type of a SharePoint field. Allowed Values: Read only.
Required	Description: Specifies whether the value is required in the SharePoint field. Allowed Values: Read only.
Unique	Description: Shows whether a duplicate value is permitted in the SharePoint field. Allowed Values: Read only.

How do you want to set up your entity? > Related Entities tab

Specifies the SharePoint list relationships to use in a process-based app.

Prerequisites

Complete the How do you want to set up your entity? > Configuration tab.
The Related Entity tab is available if the primary entity has a related entity.

Good to Know

The word entity on this screen refers to a container within your data model. For Data Entities or Salesforce, this container is called an entity. For a database, entity refers to a database table. For SharePoint Integration, entity refers to a SharePoint list. For Microsoft Excel, entity refers to an Excel table.

Fields

Field Name	Definition
Check box	Description: Specifies whether to use the SharePoint list relationship on your form. Allowed Values: Selected - Your form uses the relationship. Deselected - Your form does not use the relationship. Default Value: Deselected Example: Refer to: (External) Form Based Apps – SharePoint Data Source
Display Name	Description: Shows other SharePoint lists that have relationships with SharePoint parent list. Note: The word entity on this screen refers to a container within your data model. For Data Entities or Salesforce, this container is called an entity. For a database, entity refers to a database table. For SharePoint Integration, entity refers to a SharePoint list. For Microsoft Excel, entity refers to an Excel table. Allowed Values: Read only.
Data Type	Description: Shows the data type of your SharePoint list. Allowed Values: Read only.
Required	Description: Specifies whether the related entity is required. Allowed Values: Read only.
Unique	Description: Shows whether a duplicate value is permitted in the related entity. Allowed Values: Read only.

Review the data fields for your app screen

Configures the fields for your eForm.

Good to Know

GenAI creates the form fields based on the fields in the SharePoint list.

Fields

Field Name	Definition
Show Internal Fields	Description: Specifies whether to show the default fields in the SharePoint list. Allowed Values: Selected - Shows the default fields in the SharePoint list. Deselected - Does not show the default fields. Default Value: Deselected
Apply Layout	Opens this Screen: Apply Fields Layout screen Description: Specifies a file that stores the form layout for an eForm.
Name	Description: Shows the display name of the field in the SharePoint list. Allowed Values: Read only.
ID	Description: Shows the unique, technical name for the field in the SharePoint list. Allowed Values: Read only.
Data Type	Description: Shows the data type of a SharePoint field. Allowed Values: Read only.
Field Type	Description: Specifies the type of form control used for the field. Allowed Values: A form control from the list. Default Value: A form control type that is interpreted from the input. For example, a field called "Amount" might be assigned a Currency form control.
Regenerate	Description: Deletes the changes and restores the default values for the form.
Delete Field	Function: Deletes the selected row from the fields list.
Mark as Mandatory	Description: Specifies whether the form field is required. Allowed Values: Selected - The field must have a value. Deselected - A value is not required for the field. Default Value: The value configured for the field.
Number Of Columns	Description: Specifies the number of columns to show on the eForm. Allowed Values: An integer. Range: 1-10 Default Value: 2
Show Line Break Fields	Description: Specifies whether to group the form fields based on the column layout on the form template you upload. Allowed Values: Selected - Groups the form fields with horizontal line breaks based on the column layout shown in the uploaded file. If you create the fields with the Excel or Generate using AI options, the fields are grouped based on the number of columns specified in the Number Of Columns field. Deselected - Groups the form fields in a single list in the order shown in the uploaded file, as it reads left to right. Default Value: Deselected

Apply Fields Layout screen

Specifies a file that stores the form layout for an eForm.

Fields

Field Name	Definition
Select File to Upload	Function: Specifies a file that stores the form layout for an eForm. You can drag the image file from your local machine. Allowed Values: A PDF or an image file that shows a form layout. Click Upload File to select a file from your local machine. The file can be one of these types: .pdf .png .jpg .jpeg Default Value: None

Anything else right now? screen

Configures the optional features for your form-based app.

Fields

Field Name	Definition
Access Tokens	Opens this Screen: The configuration screen for your access token. The specific screen that shows depends on your access token type. For more information, refer to Access Tokens. Function of this Screen: Configures an access token.
Document Repositories	Opens this Screen: The configuration screen for your document repository. The specific screen that shows depends on your document repository type. For more information, refer to Document Repositories. Function of this Screen: Configures your document repository.
Style Sheets	Description: Uploads CSS files to change the look and feel of your eForms.
Groups and Roles	Description: Creates groups and roles for the access rights for an app.
Images	Description: Uploads image files to customize your app.
JavaScript	Description: Uploads JavaScript files to use in eForms.

Who can access your app? screen

Configures the permission groups for an app.

Fields

Field Name	Definition
App Owners	Opens this Screen: App Owners Function: Specifies the users and groups who are App Owners.
App Designers	Opens this Screen: App Designers (permission group) Function: Specifies the users and groups who are App Designers.
App Initiators	Opens this Screen: App Initiators Description: Specifies the users and groups who are App Initiators for an app. Limitations: Users and groups can only be assigned to the App Initiators permission group after an app is published.