March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
l am trying to create a tool that extracts information from multiple pdf files from a folder on Sharepoint using
Source = SharePoint.Files(CurrentDirectory),
where my CurrentDirectory is the sharepoint website with the path to the subfolder I want to get my date from, however it shows me this error below:
DataSource.Error: SharePoint: Request failed: The remote server returned an error: (400) Bad Request. (Bad Request)
Details:
DataSourceKind=SharePoint
DataSourcePath=
SPRequestGuid=8fa061a1-d04d-a000-6acb-9cf255b6c7a4
Url=Documents/Labor Calculation Tool/_vti_bin/ListData.svc
------------------------------------------------------------
When I try to use Source = SharePoint.Contents(CurrentDirectory) instead with CurrentDirectory being the main folder, not subfolders, I have to use Helper Queries to be able to transform my binary data into table, which I dont want to because I would need to create too many helper queries which makes my tool extramely heavy and slow.
Can anyone help me fix the error using either Source = SharePoint.Contents(CurrentDirectory) or Source = SharePoint.Files(CurrentDirectory)
SharePoint.Files requires the Site URL, not the "current directory" . You need to do the folder navigation in a subsequent step.
Even when I use the site url it does not work either.
Please elaborate what "does not work" means. Do you get an error message?
when asked to specify the Site URL you should only use
https://sidel.sharepoint.com/sites/SPMNAMContinuousImprovement
When I use this URL I have to use Helper Queries to be able to transform my binary data into table, which I dont want to because I would need to create too many helper queries which makes my tool extramely heavy and slow. Do you know any way around it?
No. This is the correct way to do it. You only need a single helper query and you can craft that one yourself. No need to use the default option offered via the "Combine binaries" button.
Can you help me crafting it? I am not sure how to create one myself that will convert the binary data to table
would you be able to post two sample PDF files and indicate what you want to extract from it?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
20 | |
13 | |
10 | |
9 | |
7 |
User | Count |
---|---|
39 | |
27 | |
16 | |
15 | |
10 |