Table of Contents
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
No Throttling (Rate Limit Management)
Blob Storage
Microsoft Azure Blob Storage
Amazon S3 Bucket
Other info
Nextcloud
Accesses to Nextcloud Team Folders
SharePoint Content Governance
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
SMART Business Intelligence
PostgreSQL configuration
Team – User’s guide
How it works
Job – Thread (1-n)
«Progress monitor» job
Too long path and filename for SharePoint
FAQ
Onedrive
What it is
Job types
Discovery and Migration
Offload
Restore
Report
Import Job Items
Offload SharePoint files
Offload – System requirements
Microsoft Blob Storage Pricing
Amazon S3 Pricing
Implementation
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()
ReplaceFirst
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()
FolderExist()
GetFileNamePart
GetFolderCreated()
GetFolderModified()
ReadTextFile
RemoveIllegal
WriteFile
SharePoint
GetSharePointLibraryURL()
SharePointPlatform()
SPConvertToDirectFolderURL
SharePoint data types
SQL support
External articles
Job notification
Power Automate Notification
Windows Event Log
Business Intelligence
PostgreSQL configuration
Last modified:
16 November 2025
