Office.AddBindingFromPromptOptions interface

Provides options for configuring the prompt and identifying the binding that is created.

Properties

asyncContext

A user-defined item of any type that is returned, unchanged, in the asyncContext property of the AsyncResult object that is passed to a callback.

id

The unique ID of the binding. Autogenerated if not supplied.

promptText

Specifies the string to display in the prompt UI that tells the user what to select. Limited to 200 characters. If no promptText argument is passed, "Please make a selection" is displayed.

sampleData

Specifies a table of sample data displayed in the prompt UI as an example of the kinds of fields (columns) that can be bound by your add-in. The headers provided in the TableData object specify the labels used in the field selection UI.

Note: This parameter is used only in add-ins for Access. It is ignored if provided when calling the method in an add-in for Excel.

Important: We no longer recommend that you create and use Access web apps and databases in SharePoint. As an alternative, we recommend that you use Microsoft PowerApps to build no-code business solutions for web and mobile devices.

Property Details

asyncContext

A user-defined item of any type that is returned, unchanged, in the asyncContext property of the AsyncResult object that is passed to a callback.

asyncContext?: any

Property Value

any

id

The unique ID of the binding. Autogenerated if not supplied.

id?: string

Property Value

string

promptText

Specifies the string to display in the prompt UI that tells the user what to select. Limited to 200 characters. If no promptText argument is passed, "Please make a selection" is displayed.

promptText?: string

Property Value

string

sampleData

Specifies a table of sample data displayed in the prompt UI as an example of the kinds of fields (columns) that can be bound by your add-in. The headers provided in the TableData object specify the labels used in the field selection UI.

Note: This parameter is used only in add-ins for Access. It is ignored if provided when calling the method in an add-in for Excel.

Important: We no longer recommend that you create and use Access web apps and databases in SharePoint. As an alternative, we recommend that you use Microsoft PowerApps to build no-code business solutions for web and mobile devices.

sampleData?: Office.TableData

Property Value

Office.TableData