Get folder details for Sharepoint List entries

[NetMare]

Hi gents,

I'm right now struggeling a bit in getting all relevant data for sharepoint online list entries in the correct way.

Actual setup:

- sharepiont online list with folders for different locations (yes, it's a list, not a library)

- several items in the single folders on the list

- online connection to sharepoint list via Power BI

What I actual see in PBI table:

- each single folder of this list

- each single entry of this list

What I do not see:

- folder location of every single entry

What's the actual problem:

- need to filter list entry by folder (location)

Any ideas?

Regards

[Anonymous]

There are types where you can use to connect to sharepoints.
https://docs.microsoft.com/en-us/powerquery-m/sharepoint-contents
Use any of the type according to your requirement in the advanced editor.

[NetMare]

Thanks.

But also woth fetching the contents of the list I can not find any possibilities for this lookup...

Maybe I'm doing it wrong or mybe I oversee something?

[v-deddai1-msft]

Hi @NetMare ，

Would you please show us some screenshot about your issue？I'm puzzled by your description.

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

Best Regards,

Dedmon Dai

[NetMare]

Found what I need. It was in ParentList.ParentWeb.Description

Thanks for your help