How to login to network share when Microsoft Account is tied to windows login?

You must use MicrosoftAccount\[email protected] (this MicrosoftAccount prefix is important) as username. Now enter your Microsoft account password into the password box.

Try disabling PIN login for the Microsoft Account (Settings > Accounts > Sign in options > PIN). Windows rejected my credentials until I removed the PIN, then I could sign in just using my email address.

I created a local "dummy" account with admin privileges and use it only as a login for sharing.