| Property | Description | Type |
|---|---|---|
| Theme | Styles the grid with one of several themes. | Input |
| Auto-Size | Size the grid columns with three different options
Size to Fit – auto-sizes the grid content to fit the width of the component
| Input |
| Row Drag | Enables or disables the ability for end users to re-order rows by dragging rows | Input |
| Grouped Rows | Enables or disables the ability for end users to use the row grouping function. The row grouping feature allows the data to be grouped by a column or hierarchy of columns. | Input |
| Use Custom Grouping | Boolean to determine if rows should be grouped based on the column schema definition instead of what the end user does as run-time | Input |
| Columns Sidebar | Enables or disables the ability for end users to see the columns sidebar. The columns sidebar allows users to select which columns to show in the grid at run-time | Input |
| Filters Sidebar | Enables or disables the ability for end users to see the Filters sidebar. The filters sidebar provides advanced data filtering capability for users at run-time | Input |
| Column Search | Enables or disables the in-column search function for users | Input |
| Use Dataset API | Enables or disables use of the Dataset API feature. The Dataset API is new feature from Microsoft and simplifies how data is saved back to a data source. There are currently limitations and known issues with this approach which is why it is not always suitable for saving data back to your data source | Input |
| Hide Toolbar | Boolean to hide or show the PowerGrid toolbar which is above the grid. | Input |
| items | Used to bind to your data source | Input |
| ColumnsDataSet_Items | Used to define column schema in JSON so that advanced grid column features can be used. | Input |
| Load All Rows | Preloads all rows instead of loading data on scroll | Input |
| Font Size | Sets the font size of the grid content | Input |
| Row Height | sets the height of rows for the grid | Input |
| Set Filter | definition of the pre-defined filter settings to apply to the grid | Input |
| filter | JSON output of the filters currently applied to the grid. Can be copied and pasted into Set Filter input property for setting predefined filters | Output |
| onSelectedItems | Returns a collection of the items selected on the grid | Output |
| onEventType | Outputs the current event which has been triggered on the grid. | Output |
| actionButtonRowId | Returns the id of the row from where the user invoked an action button | Output |
Defines the column Data Type. Supported values are:
String
Number
Date
Choices
html
rating
actionButton
Clear(updatedRowsCol);
Clear(updatedItemsCol);
If(
Self.onEventType = "pastedData",
// 1. Parsing pasted rows into a collection
ForAll(
Split(
Self.onUpdatedItems,
"</Row>"
),
Collect(
updatedRowsCol,
Result
)
);
// 2. Parsing the ID, ColumnName and new value for each pasted row
ForAll(
updatedRowsCol,
Collect(
updatedItemsCol,
{
id: First(
Split(
ThisRecord.Value,
"</>"
)
).Result,
fieldName: First(
LastN(
Split(
ThisRecord.Value,
"</>"
),
2
)
).Result,
value: Last(
LastN(
Split(
ThisRecord.Value,
"</>"
),
2
)
).Result
}
)
);
// Patch any new records from the paste operation. New rows hav an id value of NEW_ROW
ForAll(
Filter(
updatedItemsCol,
id = "NEW_ROW"
) As UpdatedItems,
Switch(
UpdatedItems.fieldName,
"Payment",
Patch(
colltestData,
Defaults(colltestData),
{Payment: UpdatedItems.value}
),
"Title",
Patch(
colltestData,
Defaults(colltestData),
{Title: UpdatedItems.value}
),
"JoinDate",
Patch(
colltestData,
Defaults(colltestData),
{JoinDate: DateValue(UpdatedItems.value)}
)
)
);
//Patch Updates for pasted rows which already exist
ForAll(
updatedItemsCol As UpdatedItems,
Switch(
UpdatedItems.fieldName,
"Payment",
Patch(
colltestData,
LookUp(
colltestData,
ID = Value(UpdatedItems.id)
),
{Payment: UpdatedItems.value}
),
"Title",
Patch(
colltestData,
LookUp(
colltestData,
ID = Value(UpdatedItems.id)
),
{Title: UpdatedItems.value}
),
"JoinDate",
Patch(
colltestData,
LookUp(
colltestData,
ID = Value(UpdatedItems.id)
),
{JoinDate: DateValue(UpdatedItems.value)}
)
)
),
//Handle regular updates to rows
// 1. Parsing chnaged rows into a collection
ForAll(
Split(
Self.onUpdatedItems,
"</Row>"
),
Collect(
updatedRowsCol,
Result
)
);
// 2. Parsing the ID, ColumnName and new value for updated row
ForAll(
updatedRowsCol,
Collect(
updatedItemsCol,
{
id: First(
Split(
ThisRecord.Value,
"</>"
)
).Result,
fieldName: First(
LastN(
Split(
ThisRecord.Value,
"</>"
),
2
)
).Result,
value: Last(
LastN(
Split(
ThisRecord.Value,
"</>"
),
2
)
).Result
}
)
);
//Patch Updates for chnaged rows
ForAll(
updatedItemsCol As UpdatedItems,
Switch(
UpdatedItems.fieldName,
"Payment",
Patch(
colltestData,
LookUp(
colltestData,
ID = Value(UpdatedItems.id)
),
{Payment: UpdatedItems.value}
),
"Title",
Patch(
colltestData,
LookUp(
colltestData,
ID = Value(UpdatedItems.id)
),
{Title: UpdatedItems.value}
),
"JoinDate",
Patch(
colltestData,
LookUp(
colltestData,
ID = Value(UpdatedItems.id)
),
{JoinDate: DateValue(UpdatedItems.value)}
)
)
)
);