Let's POWER Automate

From no-code to low-code

Menu
  • Expressions
  • Filters
  • General
  • Application specific solutions
    • Dataverse
    • Excel
    • Forms
    • Outlook
    • Planner
    • Power Apps
    • SharePoint
    • Teams
  • Triggers
  • Ready to use solutions
    • Approval Process Solution
    • Task Delegation App
    • The Ultimate Power Automate expressions cheat sheet
    • Power Automate HTTP requests to SharePoint cheat sheet
    • Power Automate HTTP requests to Graph API cheat sheet
  • ABOUT ME
  • Get help with your flow
  • POWER PLATFORM SERVICES
Menu

How to get SharePoint document library ID?

Posted on May 27, 2020January 23, 2022 by Tom

“Take the SharePoint document library id from the url“ is the most common answer, but from where exactly and how?”


Go to Library settings and copy/paste the url from browser into a text file. It is in the url behind the List= starting with %7B and ending with %7D, here’s an example:

https://<my>.sharepoint.com/sites/<my_site>/_layouts/15/listedit.aspx?List=%7B1ff350c6-80b7-4454-bfa7-5cb662665c64%7D

Remove the %7B (ASCII code for character { )and %7D (ASCII code for character } ) and you get the library ID, in the example above the library ID is:

1ff350c6-80b7-4454-bfa7-5cb662665c64

🚀 Master Power Automate

Join 2,100+ professionals getting actionable Power Automate tutorials, solutions, cheat sheets & tips every week.

No spam. Unsubscribe anytime.

5 thoughts on “How to get SharePoint document library ID?”

  1. Mridul says:
    June 6, 2022 at 1:09 pm

    Hey Tom,
    I am getting the below error:
    Error – “The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold enforced by the administrator – even with view that has 2 columns”
    Please help me with a solution.. I have been trying this from a long but getting same error every time

    Reply
  2. Julie says:
    July 29, 2022 at 7:20 pm

    I don’t have the %7B in my URL…???

    Reply
    1. Tom says:
      August 3, 2022 at 5:14 pm

      Hello Julie,
      it must be there when you go to the library settings. Some browsers might not display it right away but if you click in the address bar it should be there.

      Reply
  3. Sristi Jain says:
    February 15, 2024 at 1:22 pm

    I am trying to dynamically use the library name in my flow. The Excel Online Connector gives the error that the provided drive id appears to be malformed when using the Environment Variable with type as Data Source. I created a text type environment variable containing this id but it still gives the same error.

    Reply
    1. Tom says:
      March 17, 2024 at 12:57 pm

      Hello Sristi,
      you can always see what an action expects if you ‘Peek code’ under the 3 dots. Try to select a random drive from the dropdown and peek code to see the drive format. Then try to add ‘Compose’ actions with the env. variables inside to see what’s in these variables. That might give you some hint why it doesn’t work.

      Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

🚀 Master Power Automate

Join 2,100+ professionals getting actionable Power Automate tutorials, solutions, cheat sheets & tips every week.

No spam. Unsubscribe anytime.

Still exchanging emails to get things approved?

Get the Approval Process solution and the Task Delegation App to skip the hard part and deploy an automated, fully functional approval solution on a SharePoint list in minutes! And then the next one, and the next one...

Approval Template Preview ✨ Learn more ✨

Turn ideas into flows with ease!

Grab the complete Power Automate Cheat Sheet Bundle—everything you need to master expressions, SharePoint HTTP calls, and Graph API in Power Automate.

Cheat Sheet Bundle Preview ✨ Get the Cheat Sheets

Didn't find what you were looking for?
Need to adjust a solution to fit your needs?
Or would you just like to get an assistance from somebody with thousands of hours of experience with Power Automate?

Power Automate blogs worth visiting

Damien Bird
Dennis (Expiscornovus)
Paul Murana

©2025 Let's POWER Automate | Theme by SuperbThemes