Import excel into existing list (with data already in it)

It's great to see that you can paste multiple rows in without using IE/IE mode, esp. since SharePoint is going to stop accepting input from IE in early 2023. Here's a quirk I ran into with a list that has content management enabled and has two different content types: Initially I was getting an error for required fields from content type A, even when I had set the default new content type to B. As a workaround, I created a view that corresponded to all of the editable columns of content type B, but was getting an error that my view was missing required fields. As a test, I identified the required columns in content type A that did not also exist in B, and I set those to not required, and after a ctrl-F5 force refresh of the new view, I was able to import multiple rows with no issue. My plan is to import all rows of content type B, then switch the default content type back to A, then import all type A rows. I will also need to disable any required columns that only exist in type B for the import of the type A rows. This is a crude workaround to being unable to choose a content type when adding items in grid view. PowerAutomate would probably be the more elegant approach but sometimes quick and dirty > elegant for one-offs. For PowerAutomate, you could specify the ContentTypeID column, and get the right ID of the lists's sub-version of the site content type ID, found in the URL when in the "Edit All" mode of editing an item of the content type you want the ID for. For example: https://powerusers.microsoft.com/t5/Building-Power-Apps/How-to-pass-content-type-Id-from-PowerApps-to-SharePoint-List/td-p/437498.