Connecting existing document library to sharepoint site

Question

I was experimenting with MS Flow in Office 365, trying to automatically extract info from excel files. However, it turns out we made some "design error" in our sharepoint structure.

We have multiple central document libraries that are only linked to the Onedrive for Business environment and not connected to a Sharepoint site. (The latter turns out to be necessary for MS flow.) Is it possible to link existing document libraries to a sharepoint site?

EDITS: Some background: within onedrive for business we have created multiple document libraries. See the screenshot below (blacked out are the ones we created). Screenshot of Onedrive for Business "Site Contents"

Using MS flow I want to extract info from some of the Excel sheets in those doc libs. However, when using the wizards, I can only access files in document libraries that are created from a Sharepoint site (mine were apparently created directly in the OnedrivefB environment) or the main document library from OnedrivefB (as shown below; when choosing Onedrive, the File wizard only shows the files in the 'Documents' doc lib as also listed in the previous screenshot. Screenshot from Flow wizard

Elsewhere, I was told I should connect the document libraries we created to a Sharepoint site. But this person couldn't tell me how... Other suggestions are of course welcome as well!

Thanks, J

For completeness: Step 1 in the wizard, showing sharepoint sites and onedrive for business

Step 2 in the wizard, showing options when choosing for OdfB

Step 3 in the wizard, only showing files from the document library called "Documents" in the first screenshot

A screenshot from one such document library with the Excel I am trying to access

Answer 1

Both OneDrive for Business and Sharepoint sites can be connected to MS Flow. If you are looking for the connection with OneDrive for Business, check the below link for triggers and sample templates

https://us.flow.microsoft.com/en-us/connectors/shared_onedriveforbusiness/onedrive-for-business/

Sharepoint -

https://us.flow.microsoft.com/en-us/connectors/shared_sharepointonline/sharepoint/

EDIT: To access an Excel file in an OneDrivefB folder, browse and select the excel using file option. It will list all the folders in your OneDrive library.

.Second screenshot which you attached is sharepoint assets. they cant be linked to OneDrive. It can only be linked to sharepoint sites