I have a requirement to 're-provision' SharePoint access for migrated users. At the moment I have an extract of users and the sites/groups they have access to, some of these users are internal and some are guest/external.
Has anyone found a way to bulk grant access? For example, Ideally I'd like to input the below in to SPO PowerShell via .csv and the script will grant access to the correct group.
Joe.Bloggs@test.com, https://spo.sharepoint.com/sites/Test, Test Members
Grant.Access@test.com, https://spo.sharepoint.com/sites/DEV, Dev Visitors
Any help appreciated!