I have a Power Apps app that uses the Excel Online (Business) connector to connect to multiple tables in an Excel file (*.xlsx) that is stored in a SharePoint site. I understand that, initially, you could only connect to Excel files stores in OneDrive, but this is no longer the case. I was able to do it a week ago. Now, however, I need to connect to an additional table, but...the SharePoint site no longer appears in the list that pops up for potential SP sites in the Excel Online (Business) connector. What happened? Where did it go?
Even weirder, I went to Power Automate, made a new Flow, made a new action with the Excel Online (Business) connector and...same thing! A whole bunch of SP sites are there, but not the specific one I need. The problem is that, in Power Automate, you have the option to manually enter a location. When I copy/paste the site's URL into that location, I'm good to go. The rest of the action autofills the library options, then I can use the file picker to pick the excel file, etc. It just doesn't the SP list in the pre-genereated drop-down list.
In Power Apps, though, I do not have the option to manually enter a site's URL.
Relevant information:
- This site was created two weeks ago.
- The Power App was created last week and the connection was made to an excel sheet in the SP site I need last week (when the SP site still did appear in the drop down list).
- Now, I can't do it again
I either need to know how to "fix" the problem of SP sites not appearing in that list OR be able to manually add the SP URL.
Any ideas??
To clarify, the connections that I already made (those other tables that I connected last week) are still functioning. I can still use the app to add new rows to those tables, for instance, so the connection still works.
