Add-PnPDataRowsToSiteTemplate
SYNOPSIS
Adds datarows to a list inside a PnP Provisioning Template
SYNTAX
Add-PnPDataRowsToSiteTemplate [-Path] <String> -List <ListPipeBind> [-Query <String>]
[-Fields <String[]>] [-IncludeSecurity] [[-TemplateProviderExtensions] <ITemplateProviderExtension[]>]
[-TokenizeUrls] [-Experimental] [-Connection <PnPConnection>]
DESCRIPTION
Allows to add datarows to list inside a PnP Provisioning Template. The command allows to specify the fields which should be retrieved using -Fields option and filter the datarows to be used by using -Query option.
EXAMPLES
EXAMPLE 1
Add-PnPDataRowsToSiteTemplate -Path template.pnp -List 'PnPTestList' -Fields 'Title','Choice'
Adds datarows from the provided list to the PnP Provisioning Template at the provided location
EXAMPLE 2
Add-PnPDataRowsToSiteTemplate -Path template.pnp -List 'PnPTestList' -Query '<Query><Where><Geq><FieldRef Name="Modified"/><Value Type="DateTime"><Today OffsetDays="-7" /></Value></Geq></Where></Query>' -Fields 'Title','Choice' -IncludeSecurity
Adds datarows from the provided list to the PnP Provisioning Template at the provided location, only the items that have changed since a week ago
PARAMETERS
-Connection
Optional connection to be used by the cmdlet. Retrieve the value for this parameter by either specifying -ReturnConnection on Connect-PnPOnline or by executing Get-PnPConnection.
Type: PnPConnection
Parameter Sets: (All)
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False
-Experimental
Runs this cmdlet on the experimental PnP.Core.Provisioning engine instead of PnP Framework, which builds the data rows with its own list extract. It needs more permissions than PnP Framework, and a .pnp package can only be opened by the engine that created it. See The experimental PnP.Core.Provisioning engine.
Type: SwitchParameter
Parameter Sets: (All)
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False
-Fields
The fields to retrieve. If not specified all fields will be loaded in the returned list object.
Type: String[]
Parameter Sets: (All)
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False
-IncludeSecurity
A switch to include ObjectSecurity information.
Type: SwitchParameter
Parameter Sets: (All)
Required: False
Position: 5
Default value: None
Accept pipeline input: False
Accept wildcard characters: False
-List
The list to query
Type: ListPipeBind
Parameter Sets: (All)
Required: True
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False
-Path
Filename of the .PNP Open XML site template to read from, optionally including full path.
Type: String
Parameter Sets: (All)
Required: True
Position: 0
Default value: None
Accept pipeline input: False
Accept wildcard characters: False
-Query
The CAML query to execute against the list. Defaults to all items.
Type: String
Parameter Sets: (All)
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False
-TemplateProviderExtensions
Allows you to specify ITemplateProviderExtension to execute while loading the template.
Type: ITemplateProviderExtension[]
Parameter Sets: (All)
Required: False
Position: 4
Default value: None
Accept pipeline input: False
Accept wildcard characters: False
-TokenizeUrls
If set, this switch will try to tokenize the values with web and site related tokens. With -Experimental, an absolute url is written as {hosturl}{site} rather than {site}, so that it stays absolute on the site the template is applied to.
Type: SwitchParameter
Parameter Sets: (All)
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False