fetching data from sharepoint gridview

[NadeemAhamed]

Hello everyone.

i have added the month name in sharepoint gridview with respective to the files 

i does not contain the month name in files so i have added month name manually. 

can any one help me out how to bring the month name from sharepoint gridview with respective to the files while combining the multiple files.

[Jonvoge]

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

[NadeemAhamed]

When i am trying to fetch the file name by using the SharePoint list 

List of lifes are coming which we have outsite the folders

but i have saved my files inside the folders so iam not able to find the particular files

[Anonymous · Accepted solution]

Thanks for the reply from  Jonvoge and SamWiseOwl  , please allow me to provide another insight:

Hi, @NadeemAhamed 

Regarding the issue you raised, my solution is as follows:

If you are unable to quickly locate files using a SharePoint list, you might consider an alternative method by using a SharePoint folder:

Please note that the URL you enter needs to point to the root directory after the site:

For detailed information, you can refer to the documentation:

Power Query SharePoint folder connector - Power Query | Microsoft Learn

Power Query SharePoint list connector - Power Query | Microsoft Learn

Best Regards,

Leroy Lu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[SamWiseOwl]

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!