I'm having a bit of an issue with SSL certs. I'm hosting two sites in two providers:
app.mysite.com is hosted on Azure Static Web App
www.mysite.com is hosted on Vercel

Site 1 is working fine with DNS/Custom domain + SSL
Site 2 is working with DNS/Custom domain, but Vercel is not able to automatically configure the SSL cert.

There are some guides about CAA Records, but tbh I don't know if they would solve my problem, and trying them would require me to move from my current DNS provider to ie. Cloudflare

Any experts on this?