You can do this, but it requires a different app. NotateMe is a $40 app with a $30 in-app purchase for PhotoScore which has worked as well as the desktop version of PhotoScore ($250). Another app is Sheet Music Scanner, which is a $5 app that does not scan all things (e.g. Triplets).
These can scan to MusicXML and into Notion, but are not affiliated with Notion.