I also wanted to add that this will be like B2B collaboration. User sign-in with their Workspace account to the Azure tenant and access the resource from there. The account should be added to Azure Active Directory once an invitation is sent. And there is not need to do any account synchronization or pre-creation.
Thanks.