fetching data from sharepoint gridview

Hi NadeemAhamed 

Have you already done the Folder connector part?

Assuming you have your query will have multiple steps including Remove Columns you need to edit these:

Click on the cog logo next to the steps and tick the column you want to keep:

Hope this helps!

Hi NadeemAhamed

This is possible if you create two separate queries.

First, create a normal query with your Sharepoint Connector, and filter it down to the files you wish to connect to. Ensure that your Query shows the File Name:

Second, create a new query, but connect to a Sharepoint List, and navigate to the Table containing your files. In my case, I connect to the documents table. This allows us to grab all the metadata about our documents:

Now, expand the tables, and again filter down to get the files you are looking for. Make sure to expand the File property to expose the File.Name column, so that we now have the filename and manual column info:

Finally, Join this second query on the first using the filename, to get a merged query with both the document contents, and the metadata info needed:

I've also uploaded a pbix file with the Power Query, but it will of course not load for you as it uses my Sharepoint Site.

_____________________________________________________
I hope my comment was helpful.
If your question was answered, please mark your post as 'Solved' and consider giving me a 'Thumbs Up'.
Find me on LinkedIn, Sessionize, or my blog Downhill Data