Skip to main content

Notifications

Power Automate - Using Connectors
Answered

Cannot connect to SharePoint hub site get rows excel

(0) ShareShare
ReportReport
Posted on by

Hello,

I am trying to get the rows in an excel table in order to append that row to a SharePoint list.

However, the "Location" tab does not show the site that I am trying to access. 

The site I am trying to connect to is a hub site, at least according to all the SharePoint connectors.

I have attached some screenshots. I work for a company, so I am covering the names but will make the site I want appear in red.

is there any way to input the URL manually? all the methods I have tried so far have not worked.

 

Doesn't appear hereDoesn't appear hereAppears hereAppears here

  • Re: Cannot connect to SharePoint hub site get rows excel

    Thanks! I'm not sure why it wasn't working for me yesterday.

     

     

  • Verified answer
    v-LilyW-msft Profile Picture
    v-LilyW-msft on at
    Re: Cannot connect to SharePoint hub site get rows excel

    Hi @Anonymous 

    If you don't find your site in the dropdown, you can enter it directly. Scroll down in the 'Location' dropdown to 'Enter custom value' choice, click on it, and then copy/paste Sharepoint site url into the 'Location' field.

    vLilyWmsft_0-1626410667462.png

    vLilyWmsft_1-1626410742075.png

    Hope the content above may help you.

    Best Regards

    If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,343

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard

Featured topics