Table of Contents
GrabGrab
GrabGrab
  • SMART Migration
    • Features
    • Migration Automation
    • Data-driven file selection and distribution
    • Comparison to classic tools
      • Sharegate vs. SMART Migration
      • OneDrive Migration – differences
    • Security and Technology
    • System requirements
    • Installation guide
    • Change log
      • Release Candidate
      • Road Map 2025
    • Privacy statement
    • License Matrix (per feature)
    • Data cleansing/transformation
    • SharePoint authentication
      • Create App Registration
        • Install cert on the computer
      • How to create a legacy M365 AppID/Secret
      • Rate Limit Headers
    • Blob Storage
      • Microsoft Azure Blob Storage
      • Amazon S3 Bucket
    • Other info
  • SMART Migration from Teams
    • Welcome
      • Getting started
        • Step 1 – Get URL to a Team
        • Step 2 – Connect to the Team
          • How create an App Registration
        • Step 3 – PowerShell
        • Finished – Start the server
        • Getting started FAQ
        • Installing PowerApp for Restore
      • Team – User’s guide
        • How it works
          • Job – Thread (1-n)
          • «Progress monitor» job
        • Too long path and filename for SharePoint
        • FAQ
        • Reporting
          • Report layout
      • What it is
      • SMART Migration Job
        • Discovery
        • Migration
        • Discovery + Migration
        • OneDrive
        • Delete
        • Validation
        • Content Report
        • Site Provisioning
        • Site Provisioning Template
        • Import Jobs
        • Job Approval
        • Metadata mapping
    • SMART Storage Saver
      • Offload – System requirements
      • Microsoft Blob Storage Pricing
      • Amazon S3 Pricing
      • Implementation
      • Offload Job
      • Restore Job
      • Microsoft 365 Archive
      • Access to SharePoint & Blob Storage
    • Video
    • Workpoint 365 support
      • Product documentation
        • DevOps Version Control
        • File Management
          • Override Variables
          • Data ETL
            • Apply Retention Label
          • For-Each Loop
            • Group-By (For-Each)
          • Group
          • PowerShell
            • Get-FlowVariable
            • Set-FlowVariable
            • Add-FlowLogRow
            • Connect-PnPOnline from SMART Migration
            • PowerShell samples
            • PnP.PowerShell installation
          • Migration Reporting and Action
            • SharePoint user mapping
            • Migrated files database-view
              • File migration validation
            • Data validation warnings database-view
            • SharePoint user mapping database-view
          • Function reference
            • Logical
              • Case()
              • If()
              • IsNull()
            • Text
              • Asc()
              • Char()
              • CharNewLine()
              • CharTab()
              • ExtractMetadataColumn()
              • Fill()
              • IndexValue()
              • LastPos()
              • Left()
              • LeftTrim()
              • LeftTrimChar()
              • Len()
              • Lower()
              • Match()
              • Mid()
              • Pos()
              • Replace()
              • ReplaceAll()
              • ReplaceTextInFile()
              • Right()
              • RightTrim()
              • RightTrimChar()
              • Space()
              • String()
              • Trim()
              • TrimChar()
              • Upper()
              • WordCap()
            • Date & Time
              • Date()
              • DateTime()
              • DateTimeToNumber
              • Day()
              • DayName()
              • DayNameLocal()
              • DayNumber()
              • DaysAfter()
              • FirstDayOfMonth()
              • FirstDayOfWeekISO()
              • FirstDayOfWeekUS()
              • Hour()
              • HoursAfter()
              • IsDate()
              • LastDayOfMonth()
              • LastDayOfWeekUS()
              • LastDayOfWeekISO()
              • Minute()
              • Month()
              • MonthsAfter()
              • MonthName()
              • MonthNameN()
              • Now()
              • RelativeDateTime()
              • RelativeMonth()
              • RelativeYear()
              • Second()
              • SecondsAfter()
              • SecondsAfterDateTime()
              • Time()
              • Today()
              • Year()
              • YearsAfter()
              • WeekNumberISO()
              • WeekNumberUS()
            • Numeric
              • Dec()
              • IsNumber()
              • Mod()
              • Number()
              • Truncate()
              • Rand()
              • Round()
            • File handling
              • FileCheckSum
              • FileExist()
              • GetFileNamePart
              • GetFolderCreated()
              • GetFolderModified()
              • ReadTextFile
              • RemoveIllegal
            • SharePoint
              • GetSharePointLibraryURL()
              • SharePointPlatform()
          • SharePoint data types
          • SQL support
          • External articles
          • Job notification
            • Power Automate Notification
          • Windows Event Log
          • Business Intelligence

        SharePoint authentication

        How to create & configure Microsoft App Registration
        How to create Office 365 legacy Client/Secret

        Last modified: 8 June 2024
        Copyright © 2024 MigrateDMS