All Collections
Setup and Management
Login and Permissions
Verify user email addresses and logins from Microsoft 365 or Teams
Verify user email addresses and logins from Microsoft 365 or Teams

If you need to make sure everyone can login and access SchoolWise from Microsoft 365 or Teams this article will show how

Isa from SchoolWise avatar
Written by Isa from SchoolWise
Updated over a week ago

When we set up your platform, all user information including a persons email address is synced from your schools SIS/MIS system. This is what we use to authenticate them when they log in to SchoolWise. If we do not get an email address as part of the sync then we generate one using the pattern you use. This is a 'best match' scenario and is not 100% accurate. If your school uses a mixture of patterns for either or both staff and student emails, then this would cause further issues.

To help with this, you can cross-check the emails you have in your Microsoft 365/Teams with what we have generated in SchoolWise. You can also resolve any of the users who failed to match. Here are the steps you need to follow.

Export a list of users from your Microsoft 365

The first step is to get a list of all the active users in your Microsoft 365 so we can then use this to cross-check the email addresses in SchoolWise.

1. Log in to and expand the Users menu and then click Active users

2. Then click on the three dots menu and click on Export users

3. The CSV file will download and save to your Downloads folder

Import the list of users into SchoolWise and cross-check the list

The second step is to now import this file into SchoolWise to perform the cross-checking. This will highlight anyone who does not match with the email address list in the CSV file you just exported from Microsoft 365.

1. Open User Manager in SchoolWise and click on the Menu button. Then click CSV Import to display the import screen.

2. Click on the download box to select the CSV file from your downloads folder (or drag-and-drop the file)

3. This will then display the list of users in SchoolWise whose email does not exist in the CSV file from Microsoft 365 and allow you to match/verify them.

4. Simply click on a user to match them by searching for either their first or last name. If their name has fada's, apostrophes, accents, etc. it is best to search for part of their name rather than the whole word. Once you have found the correct email click the Assign button to match them.

Did this answer your question?