
Hello
I'm trying to figure out how to pass dynamic value for Document Library field in List rows present in a table of Excel Online (Business) connector.
If I simply enter Library name it doesn't work. It will work if I select it from dropdown list, then use peek code and copy highlighted value from "drive" key:
Then my question is: how do I find this value based on Library name? I've explored some API's (SharePoint Api, Ms Graph API v 2.0), but the closest I got to the answer was this reddit post below:
https://www.reddit.com/r/sharepoint/comments/ghcfyo/where_to_get_doc_library_id/
That was the only place I've found that mentioned something starting with b! as Library ID. Unfortunately the whole procedure gave me information about SP site in the response. If anybody have have any idea how to get this I would really appreciate that.
My friend just helped me. It was already something I tried, but somehow I overlooked that property in response.
You need to call HTTPS SharePoint API endpoint {sharepoint site addres}/_api/v2.0/drives