Table of Contents
MS Teams frontend
Welcome to Teams frontend
Getting started
Getting started FAQ
Job approval process
Permissions support
SharePoint to SharePoint
FileShare to SharePoint
Too long path and filename for SharePoint
MS Teams job setup
Run jobs
Progress monitor
Create default folders and jobs
Chat
Job Approval
SharePoint setup
DiscoveryJob
MigrationJob
FolderProxy
FileProxy
DashbordItem
TooLongPathIssue
Migration Issue
Duplicate issue
ValidatonIssue
SharePoint user mapping
Job Approval
Modeling design rules and limitation
Reset SMART Migration repository
Product FAQ
SMART Migration
Migration Automation
Data-driven file selection and distribution
Comparison to classic tools
Sharegate
OneDrive Migration – differences
Security and Technology
System requirements
Installation guide
Change log
Privacy statement
License Matrix (per feature)
Data cleansing/transformation
SharePoint authentication
How to create & configure Azure AD app
How to create a legacy M365 AppID/Secret
Other info
Video
Features
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
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()
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
SharePoint user mapping
Use the job to validate the users inthe texrt cols
Last modified:
4 October 2023
