Hello @EnterpriseArchitect ,
I understand that you need some help and guidance to perform the VNET peering of my Azure VM, Azure SQL DBs and Web Apps Private Endpoint with the existing ExpressRoute VNET.
You can setup the environment with Hub and Spoke architecture.
In this case, you can configure the Vnet peering as per the below recommendation:
You must make sure that the address spaces don't overlap across cross-premises locations and Azure locations.
Other things to note:
Requirements and constraints of Vnet peering:
You can't specify a virtual network gateway created as type ExpressRoute in a user-defined route because with ExpressRoute, you must use BGP for custom routes. You can't specify Virtual Network Gateways if you have VPN and ExpressRoute coexisting connections either.
https://learn.microsoft.com/en-us/azure/virtual-network/virtual-networks-udr-overview#user-defined
And then use a Private Endpoint to restrict the Static Web app traffic to only from your On-premises network via the ExpressRoute circuit.
Kindly let us know if the above helps or you need further assistance on this issue.
Please "Accept the answer" if the information helped you. This will help us and others in the community as well.