SharePoint user mapping database-view

REAL TIME: Report SharePoint user mapping results

The view is named report_validatedsharepointusers and defined on the “Internal Database”.
Use it with a DataETL Step or a For-Each Step.
See also: How SharePoint user mapping works

From the DataETL Step you can output the reporting result to:
  • Excel table in a new or existing workbook that subsequently can be uploaded to SharePoint
  • CSV file that subsequently can be uploaded to SharePoint
  • Items in a SharePoint List
  • Records in a database (Internal database, SQL Server or generic ODBC)

Active integrated reporting

The report can be a stand alone job you run or an integrated part of your migration set up since it is based on a standard DataETL Step.
You can choose to create the report at the end of a job or for each iteration in a For-Each and for example only if any errors happen (test the Variable [<ETL-Count>] > 0 to determine if any rows were reported). Then upload an output CSV or XLSX to SharePoint and name it according to the context in which it was created (for example ProjectId or CustomerId etc). Or create Items in a SharePoint list for review. Then finally notify someone or start a workflow using PowerAutomate.

Column name Column description for database view: report_validatedsharepointusers
inputname Name of the user to be validated or mapped
inputname_mapto The name that the inputname was mapped to
result The result of the validation (also if mapped to a different name)
  • Value: Ok The validation was successful and the user was found.
  • Value: Not found The validation did not succeed and no user was found.
result_notfound_mapto The fallback user name the inputname is mapped to if it does not it self validate or a naem it is mapped to does not validate.
result_notfound_rule The rule being used for selecting the fallback name.
  • Value: Allow all M365 File Management: Any user is allowed hence no specific fallback name is selected.
    See Options tab Allow any user name (Only O365)
  • Value: Connection user The user name specified in the SharePoint connection
  • Value: Default user The default user name specified on the options tab
result_timestamp The date and time when the validation took place.
user_email The validated users login email
user_loginname The validated users login name
user_title The validated users title
user_type The validated users type
  • Value: User The validated name is a user.
  • Value: AD Group The validated name is an Active Directory group.
Last modified: 6 July 2022