Displaying Lists of Objects in a Data GridLast Updated: 03/28/2018 Introduced in Version: 2.0
The Data Grid form component displays a list of data objects in a grid. Each row in the grid represents an object, and each column represents an object property – much like a spreadsheet.
To use the Data Grid component in the Form Designer, drag it from the Toolbox panel, under the category List, to the workspace and configure the required properties in the Properties panel.
Our example form will display a list of products from the Northwind database within a data grid. This examples requires integrating the Northwind database with the Portal and generating database steps. To follow our example you can download Northwind here.
Navigate to a Designer Projects folder, and create a new flow.
To edit the form, click the Pick or Create Form link at the top of the Properties panel.
In the resulting Pick or Create Form pop-up, name the new form “Display Products” and click OK to open it in the Form Designer.
Next, configure the data grid. With the grid selected, in the Properties panel, under the Input Data section, click the Type selector.
Back in the Properties panel, under the Input Data section, fill in Data Name with AllProducts. Since this example simply displays products, the InfoOnly grid mode selection is sufficient.
This completes the form, so save it and close the Form Designer.
In the Mapping Editor, map the Get Product step’s output – Products_Result – to the form step’s input – AllProducts. Click OK to close the Mapping Editor.
Back in the portal, test our example flow by selecting the flow’s thumbnail and clicking the Action link. In the Action menu, select Run > Run Flow.
In the resulting pop-up, we’re presented with the data grid showing the products list. The table looks much like a spreadsheet with rows representing objects and columns representing object properties.