Forum Discussion

DANK's avatar
DANK
New Member
3 years ago
Solved

SharePoint - get file list from folder with subfolders

Hi,

 

I searched for SharePoint folders and couldn't see anyone asking what I am looking for, so I hope this isn't a duplicate question!

 

I can connect to my SharePoint just fine, but I have https://mysharepoint.sharepoint.com/sites/Finance/FY 2023/Invoices

And I want to grab all the file names from Invoices and its subfolders (01 - Jan, 02 - Feb etc)

When I filter, it seems to default to selecting each of the subfolders automatically, but I'm not sure if that is future proof for when I create the next months subfolder (ie: whether it'll automatically add 06 - Jun or 07 - Jul to the filter as they occur.

So I would prefer to be able to do something like filter to FY 2023/Invoices/* if at all possible.

 

Does anyone know how I can work that?

  • DANK's avatar
    DANK
    3 years ago

    Thanks for that 🙂

    Your answer was 90% of the way there, it just needed to be

    https://mysite.sharepoint.com/sites/Finance

    (the Sharepoint URL section)

    then

    /Shared Documents/Finance/FY 2023/Invoices/

    the folder part (it just needed the Shared Documents section basically).

2 Replies

  • v-jingzhang's avatar
    v-jingzhang
    Icon for Community Support rankCommunity Support

    Hi DANK 

     

    There is a "Folder path" column. You can filter it by "Begins With..." with https://mysharepoint.sharepoint.com/sites/Finance/FY  2023/Invoices/

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

    • DANK's avatar
      DANK
      New Member

      Thanks for that 🙂

      Your answer was 90% of the way there, it just needed to be

      https://mysite.sharepoint.com/sites/Finance

      (the Sharepoint URL section)

      then

      /Shared Documents/Finance/FY 2023/Invoices/

      the folder part (it just needed the Shared Documents section basically).