Error getting user email from external provider only with public Azure /consumers/ tenant

[automaton82]

Bug report

• I confirm this is a bug with Supabase, not with my own application.
• I confirm I have searched the Docs, GitHub Discussions, and Discord.

Describe the bug

When using oauth with Azure and the personal accounts only tenant, the oauth call does not work and the error Error getting user email from external provider happens everytime.

To Reproduce

Steps to reproduce the behavior, please provide code snippets or a repository:

1. Setup an oauth call with MSFT. When you set it up, ensure your app registration is Personal accounts only
2. As per supabase documentation and microsoft's, use https://login.microsoftonline.com/consumers/ as the tenant URL
3. Ensure email is added in the scope as per the docs, like:

async function signInWithAzure() {
  const { data, error } = await supabase.auth.signInWithOAuth({
    provider: 'azure',
    options: {
      scopes: 'email',
    },
  })
}

Expected behavior

This should work

System information

• OS: Windows and hosted
• Browser all
• Version of supabase-js: 2.39.3
• Version of Node.js: 20.12.2

Additional context

This appears similar to #550 but in that issue people said personal accounts worked fine, it was /common/ that did not. Now it seems the opposite