You make reference to using multiple instances of OneDrive and other storage Apps. Perhaps I'm missing something here, but it remains unclear as to what you are explicitly attempting to achieve - and whether or not you are accessing multiple cloud accounts from the same provider.
To reiterate an earlier point, native integration of external cloud storage providers with iPadOS requires installation of appropriate "helper Apps" - such as MS OneDrive and Google Drive Apps. The helper Apps provide the APIs used by iPadOS to access associated cloud storage.
To access files, you must obviously be signed-in to the associated cloud account(s). Both the OneDrive and Google Drive Apps allow you to sign-in to a single account with that provider. As such, you'll not be able to sign-in to multiple accounts, from the same provider, using the helper-App mechanism. This is a limitation of the third-party provider's App; not Apple; attempting to run multiple instances of the same helper-App will not bypass this imposed limitation.
There is a potential workaround - but at the expense of full native integration with iPadOS. Some third-party File Manager Apps offer considerably more flexibility with external cloud services. Instead of attempting to integrate Google and MS cloud storage at an OS-level, using a "helper App", some third-party File Manager Apps can instead access Google/MS and other external storage/cloud providers resources directly. Using a File Manager allows you to sign-in to multiple accounts from the same provider - and as such bypass many of the functional limitations imposed by iOS/iPadOS and cloud provider helper Apps.
If this is the issue that you have encountered, one such File Manager App that may help with your difficulty is FileBrowser Professional by Stratospherix:
https://apps.apple.com/gb/app/filebrowser-professional/id854618029
This is an App that I both use and recommend for use by advanced users with more complex needs for easy access to (and management of) external and cloud storage. Here is a redacted screenshot that illustrates simultaneous connection to multiple cloud providers/accounts, connected USB storage etc and local folders:

You would be well advised to review the extensive online Manual and help files to determine suitability for your needs.
https://www.stratospherix.com/products/filebrowserprofessional/filebrowser-professional-user-guide.php