# Group Set
Creates or updates SharePoint groups on a site by processing rows from an Excel file. Each row either applies a named group configuration template or creates a group with inline properties.
Filename pattern: filename must contain groupset (case-insensitive).
Example: 20240115 groupset groups.xlsx
# Columns
| Name | Required | Description |
|---|---|---|
| Url | Yes | Server-relative URL of the site where the group will be created or updated. |
| GroupSet / Group / Set | Conditional | Name of a GroupCfg template defined in config.json. Required when not using inline group columns. |
| GroupName / Name | Conditional | Name of the group to create or update. Required when GroupSet is not provided. |
| GroupOwner / Owner | No | Login name of the group owner. Used in inline mode only. |
| GroupMembers / Members | No | Semicolon-separated list of login names to add as group members. Used in inline mode only. |
| GroupDescription / Description | No | Description for the group. Used in inline mode only. |
| GroupAllowMembersEditMembership / AllowMembersEditMembership | No | Boolean. Whether group members may add or remove other members. Used in inline mode only. |
| GroupOnlyAllowMembersViewMembership / OnlyAllowMembersViewMembership | No | Boolean. Whether only group members can see the membership list. Used in inline mode only. |
Url is always required. Either GroupSet or GroupName must be provided.
# Behavior
Template mode: Provide GroupSet with the name of a GroupCfg template from config.json. The template defines all group settings. Inline columns (GroupName, GroupOwner, etc.) are not needed. If the named template is not found, the row fails.
Inline mode: Provide GroupName directly. The group is created or updated using the inline columns from the same row. GroupSet must be absent or empty.
Any columns not listed above are passed as additional properties and forwarded to the group configuration.
# Related links
- Permission Set handler — assign groups to permission levels after creation