Smartsheet

Add-SmartsheetAttachment -Id <UInt64> -Path <String> [-description <String>] [-name <String>] [<CommonParameters>]

Add-SmartsheetAttachment -Id <UInt64> [-Url <String>] [-Type <String>] [-subType <String>] [-description <String>] [-name <String>] [<CommonParameters>]

Add-SmartSheetCellImage [-Id] <UInt64> [-rowId] <UInt64> [-columnId] <UInt64> [-Path] <String> [[-altText] <String>] [<CommonParameters>]

Add-SmartsheetColumn -Id <UInt64> -column <PSObject> [-PassThru] [<CommonParameters>]

Add-SmartsheetColumn -Id <UInt64> -Index <Int32> [-title <String>] [-description <String>] [-type <String>] [-formula <PSObject>] [-hidden <Boolean>] [-autoNumberFormat <PSObject>] [-contactOptions <PSObject>] [-format <String>] [-locked <Boolean>] [-options <String[]>] [-symbol <String>] [-systemColumnType <String>] [-validation <Boolean>] [-width <Int32>] [-PassThru] [<CommonParameters>]

EXAMPLE 1

To add a new colum to a Smartsheet.
PS> $newColumn = $Sheet | Add-SmartsheetColumn -title "Title" -type:TEXT_NUMBER -description 'My new column'

EXAMPLE 2

To insert a new column at position 4 (columns after position 4 are shifted to the right and their index incremented).
PS> $newColumn = $Sheet | Add-SmartsheetColumn -title "Asset" -type:TEXT_NUMBER -Description "Fixed asset" -index 4

EXAMPLE 3

Add a new column with contact objects.
PS> $contacts = @(
    @{
        email = "johndoe@example.com"
        name = "John Doe"
    },
    @{
        email = "janedoe@example.com"
        name = 'Jane Doe
    }
)
PS> $newColumn = $Sheet | Add-SmartsheetColumn -title "EmployeeName" -type:TEXT_NUMBER -contactOption $contacts

Add-SmartsheetColumns [-Id] <UInt64> [-columns] <PSObject[]> [-PassThru] [<CommonParameters>]

Add-SmartsheetComment [-Id] <UInt64> [-discussionId] <UInt64> [-text] <String> [<CommonParameters>]

Add-SmartsheetDiscussion [-Id] <UInt64> [-text] <String> [<CommonParameters>]

Add-SmartsheetRow -Id <UInt64> -Row <PSObject> [-location <String>] [-siblingRowId <String>] [-PassThru] [<CommonParameters>]

Add-SmartsheetRow -Id <UInt64> [-expanded <Boolean>] [-format <String>] [-cells <PSObject[]>] [-locked <Boolean>] [-location <String>] [-siblingRowId <String>] [-PassThru] [<CommonParameters>]

Add-SmartsheetRowDiscussion [-id] <UInt64> [-rowId] <UInt64> [-text] <String> [<CommonParameters>]

Add-SmartsheetRows [-Id] <UInt64> [-Rows] <PSObject[]> [-PassThru] [<CommonParameters>]

Add-SmartsheetShare -Id <UInt64> -accessLevel <String> [<CommonParameters>]

Add-SmartsheetShare -Id <UInt64> -accessLevel <String> [-sendEmail] [-email <String>] [-subject <String>] [-message <String>] [-ccMe] [<CommonParameters>]

Add-SmartsheetWorkspace -Name <String> [-Folders <PSObject[]>] [-Reports <PSObject[]>] [-Sheets <PSObject[]>] [-Sights <PSObject[]>] [-Templates <PSObject[]>] [-ExcludeCellLinksRemap] [-ExcludeReportsRemap] [-ExcludeSheetHyperlinkRemap] [-ExcludeSightsRemap] [<CommonParameters>]

Add-SmartsheetWorkspace -Name <String> [-Folders <PSObject[]>] [-Reports <PSObject[]>] [-Sheets <PSObject[]>] [-Sights <PSObject[]>] [-Templates <PSObject[]>] [-IncludeAll] [-ExcludeCellLinksRemap] [-ExcludeReportsRemap] [-ExcludeSheetHyperlinkRemap] [-ExcludeSightsRemap] [<CommonParameters>]

Add-SmartsheetWorkspace -Name <String> [-Folders <PSObject[]>] [-Reports <PSObject[]>] [-Sheets <PSObject[]>] [-Sights <PSObject[]>] [-Templates <PSObject[]>] [-IncludeAttachments] [-IncludeBrands] [-IncludeCellLinks] [-IncludeData] [-IncludeDiscussions] [-IncludeFilters] [-IncludeForms] [-IncludeRuleRecipients] [-IncludeRules] [-IncludeShares] [-ExcludeCellLinksRemap] [-ExcludeReportsRemap] [-ExcludeSheetHyperlinkRemap] [-ExcludeSightsRemap] [<CommonParameters>]

Add-SmartsheetWorkspaceFolder [-Id] <UInt64> [-Name] <String> [<CommonParameters>]

This function can only create top level folder. To create a subfolder us the Add-SmartsheetFolder function.

Copy-Smartsheet -Id <UInt64> [-newSheetName <String>] [-includeAll] [-includeAttachments] [-includeCellLinks] [-includeFormatting] [-includeFilters] [-includeForms] [-includeRuleRecipients] [-includeRules] [-IncludeShares] [-excludeSheetHyperlinks] [-passThru] [<CommonParameters>]

Copy-Smartsheet -Id <UInt64> [-newSheetName <String>] [-containerId <String>] [-containerType <String>] [-includeAll] [-includeAttachments] [-includeCellLinks] [-includeFormatting] [-includeFilters] [-includeForms] [-includeRuleRecipients] [-includeRules] [-IncludeShares] [-excludeSheetHyperlinks] [-passThru] [<CommonParameters>]

Copy-SmartsheetAttachments [-Id] <String> [-targetSheetId] <String> [-tempDir] <String> [<CommonParameters>]

Copy-SmartsheetDiscussions [-Id] <UInt64> [-targetSheetId] <UInt64> [<CommonParameters>]

Copy-SmartSheetRows -Id <UInt64> -targetSheetId <UInt64> -rowIds <UInt64[]> [-ignoreRowsNotFound] [<CommonParameters>]

Copy-SmartSheetRows -Id <UInt64> -targetSheetId <UInt64> -rowIds <UInt64[]> [-includeAll] [-ignoreRowsNotFound] [<CommonParameters>]

Copy-SmartSheetRows -Id <UInt64> -targetSheetId <UInt64> -rowIds <UInt64[]> [-includeAttachments] [-includeChildren] [-includeDiscussions] [-ignoreRowsNotFound] [<CommonParameters>]

Copy-SmartsheetShares [-Id] <UInt64> [-targetSheetId] <UInt64> [<CommonParameters>]

Copy-SmartsheetWorkspace -Id <UInt64> -NewName <String> [-DestinationId <UInt64>] [-DestinationType <String>] [-ExcludeCellLinksRemap] [-ExcludeReportsRemap] [-ExcludeSheetHyperlinkRemap] [-ExcludeSightsRemap] [<CommonParameters>]

Copy-SmartsheetWorkspace -Id <UInt64> -NewName <String> [-DestinationId <UInt64>] [-DestinationType <String>] [-IncludeAll] [-ExcludeCellLinksRemap] [-ExcludeReportsRemap] [-ExcludeSheetHyperlinkRemap] [-ExcludeSightsRemap] [<CommonParameters>]

Copy-SmartsheetWorkspace -Id <UInt64> -NewName <String> [-DestinationId <UInt64>] [-DestinationType <String>] [-IncludeAttachments] [-IncludeBrands] [-IncludeCellLinks] [-IncludeData] [-IncludeDiscussions] [-IncludeFilters] [-IncludeForms] [-IncludeRuleRecipients] [-IncludeRules] [-IncludeShares] [-ExcludeCellLinksRemap] [-ExcludeReportsRemap] [-ExcludeSheetHyperlinkRemap] [-ExcludeSightsRemap] [<CommonParameters>]

Export-SmartSheet -InputObject <PSObject> -SheetName <String> [-headerRow <Int32>] [-primaryColumn <Int32>] [<CommonParameters>]

Export-SmartSheet -InputObject <PSObject> -SheetName <String> [-FolderId <UInt64>] [-headerRow <Int32>] [-primaryColumn <Int32>] [<CommonParameters>]

Export-SmartSheet -InputObject <PSObject> -SheetName <String> [-WorkspaceId <UInt64>] [-headerRow <Int32>] [-primaryColumn <Int32>] [<CommonParameters>]

As mentioned this function ALWAYS creates a new sheet even if the name already exists. Name IS NOT the unique identifyer in smartsheet, the sheet ID is.
If you want to update a shee use the Update-SmartSheet funcction.

EXAMPLE 1

Create a new sheet in the home folder.
$ObjectArray | Export-Smartsheet -SheetName "MyNewSheet"

EXAMPLE 2

Create a new sheet in the folder.
$Folder = Get-SmartsheetHomeFolders -Recurse | Where-object {$_.FullName like "Inventory/Westcoast"}
$objectArray | Export-Smartsheet -SheetName "MyNewSheet" -folder 'myfolder1/myfolder2'

EXAMPLE 3

Create a new sheet in a workspace folder.
$Workspace = Get-SmartsheetWorkspaces | Where-Object {$_.Name -eq 'Accounting'}
$APFolder = Get-SMartsheetWorkspaceFolders -WorkspaceId $Workspace.Id | Where-Object ($_.Name -eq 'Accounts Payable')
$PaymentsFolder = Get-SmartsheetFolders -FolderId $APFolder.Id -Recurse | Where-Object {$_.FullName -eq "Microsoft/Payments"}
$ObjectArray | Export-Smartsheet -Sheetname 'July Payments' -folder $PaymentsFolder.Id

Export-SmartsheetRows [[-InputObject] <PSObject>] [-sheetId] <UInt64> [-blankRowAbove] [[-title] <String>] [[-titleFormat] <String>] [-includeHeaders] [[-headerFormat] <String>] [-PassThru] [<CommonParameters>]

This function is generally used to create the equivalent of an Excel table in a Smartsheet.
This is sort of "out of functionality" for how Smartsheets work, but some may find it useful.
You can use this function to append rows to an existing Smartsheet. See example 2 below.
Data will always be added starting at the left most column. If you wanted to insert data into a Smartsheet
starting at a certain column you would need to use the Add-SmartSheetRow function inserting blank cells into the beginning of
the cell array.

EXAMPLE 1

The following example imports the array into a Smartsheet, creates a blank row above the data and adds a title and a header row.
(To create the format variables use New-SmartsheetFormatString)
$Array | Export-SmartsheetRows -id $Sheet.Id -blankRowAbove -title "My Title" -TitleFormat $titleFormat -includeHeaders -headerFormat $headerFormat

EXAMPLE 2

The following example imports the array into a smartsheet appending the rows to the existing sheet without any title or headers. 
This can be used to append rows to the Smartsheet. No attempt is made to prevent duplicate data.
If the number of properties in the objects is more than the existing columns, then generic columns are created.
(To update rows based in their primary column values use the Update-Smartsheet function.)
$Array | Export-SmartsheetRows -id $Sheet.id

Get-Smartsheet -id <UInt64> [-level <Int32>] [-includeAll] [-includeAttachments] [-includeColumnTypes] [-includeCrossSheetReferences] [-includeDiscussions] [-includeFilters] [-includeFilterDefinitions] [-includeFormat] [-includeGantConfig] [-includeObjectValue] [-includeOwnerInfo] [-includeRowPermalink] [-includeSource] [-includeWriterInfo] [-excludeFilteredOutRows] [-excludeLinkInFromCellDetails] [-excludeLinkOutToCellDetails] [-excludeNonexistentCells] [-columnIds <PSObject[]>] [-rowIds <PSObject[]>] [<CommonParameters>]

Get-Smartsheet -Name <String> [-level <Int32>] [-includeAll] [-includeAttachments] [-includeColumnTypes] [-includeCrossSheetReferences] [-includeDiscussions] [-includeFilters] [-includeFilterDefinitions] [-includeFormat] [-includeGantConfig] [-includeObjectValue] [-includeOwnerInfo] [-includeRowPermalink] [-includeSource] [-includeWriterInfo] [-excludeFilteredOutRows] [-excludeLinkInFromCellDetails] [-excludeLinkOutToCellDetails] [-excludeNonexistentCells] [-columnIds <PSObject[]>] [-rowIds <PSObject[]>] [<CommonParameters>]

When retrieving a smartsheet by name there is always the chance that there are multiple sheets with the same name in a folder.
If more than one sheet have the same name, you will be prompted to select the sheet yu want from a list.
The list will show Sheet name and modified date.

Get-SmartsheetAttachment -id <UInt64> -attachmentId <String> [<CommonParameters>]

Get-SmartsheetAttachment -id <UInt64> -attachmentId <String> [-saveAs <String>] [<CommonParameters>]

Get-SmartsheetAttachment -id <UInt64> -attachmentId <String> [-asByteArray <Byte[]>] [<CommonParameters>]

Get-SmartsheetAttachments [-id] <UInt64> [<CommonParameters>]

Get-SmartsheetColumn [-Id] <UInt64> [-ColumnId] <UInt64> [<CommonParameters>]

Get-SmartsheetColumns [-Id] <UInt64> [<CommonParameters>]

Get-SmartSheetComment [-Id] <UInt64> [-commentId] <UInt64> [<CommonParameters>]

Get-SmartsheetDiscussions [-Id] <UInt64> [-includeAllComments] [-includeAttachments] [<CommonParameters>]

Get-SmartsheetFolder [-folderId] <UInt64> [<CommonParameters>]

Get-SmartsheetFolders [-Id] <UInt64> [[-Name] <String>] [-recurse] [<CommonParameters>]

Get-SmartsheetHome [<CommonParameters>]

Get-SmartsheetHomeFolders [<CommonParameters>]

Get-SmartsheetImageUrl [-Id] <UInt64> [[-saveAs] <String>] [<CommonParameters>]

Get-SmartsheetRow [-Id] <UInt64> [-rowId] <UInt64> [-includeColumns] [<CommonParameters>]

Get-SmartsheetRowDiscussions [-id] <UInt64> [-rowId] <UInt64> [-includeComments] [-includeAttachments] [<CommonParameters>]

Get-Smartsheets [<CommonParameters>]

Get-SmartSheetShare [-Id] <UInt64> [-shareId] <UInt64> [<CommonParameters>]

Get-SmartsheetShares [-Id] <UInt64> [<CommonParameters>]

Get-SmartsheetWorkspace [-Id] <UInt64> [-IncludeSource] [-IncludeDistributionLink] [-IncludeOwnerInfo] [-IncludeSheetVersion] [-IncludePermaLinks] [-LoadNestedFolder] [<CommonParameters>]

Get-SmartsheetWorkspaceFolders [-Id] <UInt64> [<CommonParameters>]

The returned collection consists of abbreviated folder objects. These object contain only the id, name, and permalink properties.
You cannot return a recursive list with this function. To get a recursive list of subfolder use the Get-SmartsheetFolders function and provide the
Id of one of the top level folders returned by this function.

Get-SmartsheetWorkspaces [<CommonParameters>]

Get-SortedSmartsheet -id <UInt64> -sortCriteria <PSObject[]> [<CommonParameters>]

Get-SortedSmartsheet -id <UInt64> -columnId <UInt64> [-direction <String>] [<CommonParameters>]

If you are retrieving the Smartsheet to process the data within powershell it may be easier and more efficient to do the sorting within powershell.

For Example:

PS> $Sheet = Get-Smartsheet -sheetId 465987456
PS> $Data = $Sheet.ToArray() | Sort-Object -Property Name, HireDate.

EXAMPLE 1

How to create a multi-sort sortCriteria object.
In this example we are going to sort a Smartsheet of employee salary information by Department and Salary in descending order.
To create the criteria create an array of hash table object.
PS> $sortCriteria - @(
        @{
            sortCriteria = @{
                columnId = $Sheet.columns.Where({$_.title -eq "Department"}).ColumnId
                direction = "ASCENDING"
            },
            @{
            {
                columnId = $Sheet.Columns.Where({$_.title -eq "Salary"}).ColumnId
                direction = "DESCENDING"
            }
        }
    )
Now sort the sheet.
PS >$SortedSheet = $sheet | Get-SortedSmartSheet -SortCriteria $sortCriteria

Move-Smartsheet -Id <UInt64> [<CommonParameters>]

Move-Smartsheet -Id <UInt64> [-containerId <String>] [-containerType <String>] [<CommonParameters>]

Move-SmartSheetRows -id <UInt64> -targetSheetId <UInt64> -rowIds <UInt64[]> [-ignoreRowsNotFound] [<CommonParameters>]

Move-SmartSheetRows -id <UInt64> -targetSheetId <UInt64> -rowIds <UInt64[]> [-includeAll] [-ignoreRowsNotFound] [<CommonParameters>]

Move-SmartSheetRows -id <UInt64> -targetSheetId <UInt64> -rowIds <UInt64[]> [-includeAttachments] [-includeDiscussions] [-ignoreRowsNotFound] [<CommonParameters>]

New-CellLink [-sheetId] <UInt64> [-sheetName] <String> [-columnId] <UInt64> [-rowId] <UInt64> [<CommonParameters>]

New-Hyperlink [-reportId <UInt64>] [<CommonParameters>]

New-Hyperlink [-sheetId <UInt64>] [<CommonParameters>]

New-Hyperlink [-sightId <UInt64>] [<CommonParameters>]

New-Hyperlink [-url <String>] [<CommonParameters>]

New-SmartSheetCell [-columnId] <UInt64> [[-conditionalFormat] <String>] [[-format] <String>] [[-formula] <String>] [[-hyperlink] <PSObject>] [[-image] <PSObject>] [[-linkInFromCell] <PSObject>] [[-linksOutFromCell] <PSObject[]>] [-value] <PSObject> [<CommonParameters>]

New-SmartsheetColumn [-title] <String> [-primary] [[-description] <String>] [[-type] <String>] [[-formula] <PSObject>] [-hidden] [[-autoNumberFormat] <PSObject>] [[-contactOptions] <PSObject>] [[-format] <String>] [-locked] [[-options] <String[]>] [[-symbol] <String>] [[-systemColumnType] <String>] [-validation] [[-width] <Int32>] [<CommonParameters>]

New-SmartsheetFolder [-Id] <UInt64> [-folderName] <String> [<CommonParameters>]

New-SmartSheetFormatString [[-fontFamily] <String>] [[-fontSize] <Int32>] [-bold] [-italic] [-underline] [-stikethrough] [[-horizontalAlign] <String>] [[-verticalAlign] <String>] [[-textColor] <String>] [[-backgroundColor] <String>] [[-taskbarColor] <String>] [[-currency] <String>] [[-decimalCount] <Int32>] [-thousandsSeparator] [[-numberFormat] <String>] [-textWrap] [[-dateFormat] <String>] [<CommonParameters>]

New-SmartSheetHomeFolder [-folderName] <String> [<CommonParameters>]

Remove-Smartsheet [-Id] <UInt64> [<CommonParameters>]

Remove-SmartSheetAttachment [-Id] <String> [-attachmentId] <String> [<CommonParameters>]

Remove-SmartsheetColumn [-Id] <UInt64> [-columnId] <UInt64> [-PassThru] [<CommonParameters>]

Remove-SmartsheetComment [-Id] <UInt64> [-commentId] <String> [<CommonParameters>]

Remove-SmartsheetDiscussion [-id] <UInt64> [-discussionId] <UInt64> [<CommonParameters>]

Remove-SmartsheetFolder [-folderId] <UInt64> [<CommonParameters>]

Remove-SmartsheetRow [-Id] <UInt64> [-rowId] <UInt64> [-PassThru] [<CommonParameters>]

Remove-SmartsheetRows [-Id] <UInt64> [-rowIds] <UInt64[]> [[-ignoreRowsNotFound] <Boolean>] [-PassThru] [<CommonParameters>]

Remove-SmartsheetShare [-Id] <UInt64> [-shareId] <UInt64> [<CommonParameters>]

Remove-SmartSheetWorkspace [-Id] <UInt64> [-WhatIf] [-Confirm] [<CommonParameters>]

Rename-SmartSheet [-Id] <UInt64> [-NewSheetName] <String> [<CommonParameters>]

Search-Smartsheet [-Id] <UInt64> [-searchText] <String> [-exact] [<CommonParameters>]

Search-SmartsheetAccount [-searchText] <String> [-exact] [-personalWorkspaces] [[-modifiedSince] <DateTime>] [-favoriteFlag] [[-scopes] <String[]>] [<CommonParameters>]

Send-SmartsheetRowsViaEmail [-Id] <UInt64> [-rowIds] <UInt64[]> [[-columnIds] <UInt64[]>] [-To] <String[]> [[-subject] <String>] [[-message] <String>] [-includeAttachments] [-includeDiscussions] [[-layout] <String>] [-ccMe] [<CommonParameters>]

Set-SmartsheetAPIKey [-APIKey] <String> [-Secure] [<CommonParameters>]

To use a secret store to securely store you API key, you must install the required modules
and configure the store and create a vaule.

To install the modules:
Install-Module Microsoft.PowerShell.SecretManagement
Install-Module Microsoft.PowerShell.SecretStore

Configure the secret store:
You must configure your secret store and set the authenticatio, there are several parameters:
-Authentication: This can ne either 'Password" or 'None'
You should set a password for interactive sessions. For automation on a secure device you can set this to 'None'
-Interaction: This can be set to 'Prompt' or 'None' If -Authentication is set to 'Password' This must be set to 'Prompt', id Authentication is set to 'None' this must ne set to 'None'.
-PasswordTimeOut: The time in seconds befopre the password must be re-entered. The default is 600 seconds.
-Password: The password to unlock the vault. If omitted you will be prompted for the password.

Register the vault:
You must register a vault to store your secrets. At this time the Secret Store does not support multiple vaules.
While you "can" register multiple vaults the store will just be duplicated. This is a known issue with the SecretStore and may be corrected in the future.
Only create 1 vault and register it as the default vault.

Register-SecretVault -Name "MyVault" -DefaultVault -ModuleName Microsoft.Powershell.SecretStore

Set-SmartsheetColumn -Id <UInt64> -ColumnId <UInt64> [-PassThru] [<CommonParameters>]

Set-SmartsheetColumn -Id <UInt64> -ColumnId <UInt64> -column <PSObject> [-PassThru] [<CommonParameters>]

Set-SmartsheetColumn -Id <UInt64> -ColumnId <UInt64> -Index <Int32> [-title <String>] [-description <String>] [-type <String>] [-formula <PSObject>] [-hidden <Boolean>] [-autoNumberFormat <PSObject>] [-contactOptions <PSObject>] [-format <String>] [-locked <Boolean>] [-options <String[]>] [-symbol <String>] [-systemColumnType <String>] [-validation <Boolean>] [-width <Int32>] [-PassThru] [<CommonParameters>]

Set-SmartSheetComment [-Id] <UInt64> [-commentId] <UInt64> [-text] <String> [<CommonParameters>]

Set-SmartsheetRow -Id <UInt64> -Row <PSObject> [-PassThru] [<CommonParameters>]

Set-SmartsheetRow -Id <UInt64> -rowId <UInt64> [-expanded <Boolean>] [-format <String>] [-Cells <PSObject[]>] [-locked <Boolean>] [-PassThru] [<CommonParameters>]

Set-SmartsheetRows [-Id] <String> [[-Rows] <Object[]>] [-PassThru] [<CommonParameters>]

Set-SmartsheetShare [-Id] <UInt64> [-shareId] <UInt64> [-accessLevel] <String> [<CommonParameters>]

Set-SmartSheetWorkspace [-Id] <UInt64> [-Name] <String> [<CommonParameters>]

Update-Smartsheet [-InputObject] <PSObject[]> [-sheetId] <UInt64> [-UseRowId] [-PassThru] [<CommonParameters>]

To return an array of objects from a smartsheet that contains the row id of the row the values are associated with use the ToArray method
on the sheet object returned by Get-Smartsheet passing a value of $true. $sheet.ToArray($true).

Updating sheet rows based on the primary column is maintained for backward compatibility. You should use the RowId method in any new projects
as it is more accurate and does not depend on the primary column being unique. Smartsheet does not force uniqueness on the primary column.

If you are updating a sheet from external data (not modifying the sheet itself) then the properties of external data must match the columns in the sheet.
If the properties of the external data adds, removes, or changes or the sheet adds, removes, or changes coljmns YOU must handle the changes to the sheet or data manually.
You can add, remove, and change columns using the column functions!

Updating sheets by primary column may be removed from future versions of this module.

EXAMPLE 1

Update the rows in the smartsheet based on Primary Columns.

EXAMPLE 2

Update the rows in the smartsheet based on the RowId property.

EXAMPLE 3

Update the rows in the smartsheet based on the RowId property and return the updated sheet.
$Array | Update-Smartsheet -SheetId $Sheet.Id -UseRowId -PassThru