Skip to main content

Notifications

Power Automate - Using Connectors
Unanswered

Connection to an online SharePoint (error api execution)

(0) ShareShare
ReportReport
Posted on by
  • Dear Power Automate Community,

     

    seeking insights, support and maybe help on my issue:

     

    I have one MS Flow in place since several month - working properly. Our Flow is picking a file from a Shared Folder and should copy/paste it to an Online SharePoint location. But since yesterday - the last step of the Flow is having issues connecting to an Online SharePoint.

     

    This is the error which is thrown by the Flow:

    Error executing the API '/datasets/https%253A%252F%252Fnxp1-portal13.sharepoint.com%252Fsup%252Frdo%252FPCPIT/rootfolders'

     

    We tried already everything: raising a new Flow with different users, renewing the individual connections etc. Always getting the same error message.

     

     

    flow_error.png

     

    Has someone experienced a similar issue or has any insight which could help us maybe?

    Any reply is appreciated and more than welcome.

     

    Thanks and kind regards

    Anna

  • Re: Connection to an online SharePoint (error api execution)

    Hi Jcook,

     

    I can confirm that I did the following already:

     

    • Secured that I have fully access to the SharePoint site - reconfirmed with Owner of the site
    • Compared the URL tons of times
    • Inserted the URL from clipboard and from drop-down

     

    Also my colleagues (who have access too) tried it. W/o success. Tried to rebuild the entire flow from scratch. W/o success.

     

    Yesterday, one person from our IT team - completely external from our team - did a new connection with his user ID and the URL was working for him, but only with his own new SharePoint connection. This brings me to the feeling, that is has something to do with my credentials or user account. BUT it is not explaining why my colleagues have the same problems....

     

    Kind regards

    Anna

  • Jcook Profile Picture
    Jcook 7,770 on at
    Re: Connection to an online SharePoint (error api execution)

    Hi @Anonymous 

     

    How are you populating the SharePoint site address field?

    Can you confirm that the site address is the same as the URL of your homepage in that SharePoint site.

     

    For example:

    Jcook_0-1597081412374.png

     

    and check the URL

    Jcook_1-1597081481428.png

    Try using the base URL for the Site Address instead of selecting from dropdown.

     

    Do this by copy and pasting the URL, and selecting 'Enter custom value'

    Jcook_2-1597082205383.png

     

     

  • Re: Connection to an online SharePoint (error api execution)

    Hi again,

     

    maybe important to add - I am able to connect to a different online SharePoint. This connection is working very nicely w/o any issue. Just this location is making troubles...

     

    I checked with the Owner if my permission have been changed, but that is not the case. The thing is, that also my colleague, who tried to build the Flow from scratch is experiencing the same issue.

     

    Thanks for your help.

  • Re: Connection to an online SharePoint (error api execution)

    Hi Jcook,

     

    sure, tried that several times already. Renewed the connection to SharePoint.

     

    Any other idea?

     

    Kind regards

  • Jcook Profile Picture
    Jcook 7,770 on at
    Re: Connection to an online SharePoint (error api execution)

    Hello @Anonymous 

     

    Have you tried re adding the connection?

     

    Click the 3 dots on the action, and click the Add new connection button.

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,691

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 65,019

Leaderboard

Featured topics