cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Luka84
Helper V
Helper V

Access SharePoint Document Library Folder Contents in PowerApps

Good day,

I hope everyone is well and safe with your families and loved ones!

 

Need some advice please, been going at this thing for 24 hours now without any success

Basically, I'm building a Digital Archive on a SharePoint Library and using PowerApps as an interface (To support staff working from home); in details I have a SharePoint Document Library (7,000 Folders and about 18,000 files) in a Gallery in PowerApps, showing only folder names without contents.

 

What I want to achieve is the following:

When I click on a folder, I would like to see it's contents (Can't use 'Folder Path' or anything else due to Delegation issues).

I thought the best way is to fetch the folder contents from SharePoint using Flow, and saving them to a gallery - but I don't have any experience with JSON and have no idea how to do this correctly.

I don't know whether to use "GET FILES" or "LIST FOLDER" or "SEND AN HTTP REQUEST" - honestly they all confuse me lol

 

Below is the full Process I would like to Implement - for reference:

- Create a new folder in a SharePoint Library from Powerapps (DONE)

- Add Folder/File properties from Powerapps (DONE)

- Attach new files to SharePoint Library from PowerApps (IN PROGRESS)

- See all the Document Library Folders (DONE)

- Access the folder contents once a user select a folder (All the files listed within the selected folder) (STUCK HERE)

- Display all the columns that describe the file in the SharePoint Document Library (I suppose it's called File Properties or Metadata) (STUCK HERE)

- Be able to update the File Columns/Properties when needed (Such as change the status) (I THINK I KNOW HOW TO DO THIS)

 

I've read over 50 articles and support tickets but still struggling with this thing

Thanks in advance - any help will be truly appreciated

20 REPLIES 20
DavidBP
Frequent Visitor

Hi,

 

I want to list in my gallery the files of a site of Teams, but its dinamic because i had a list of groups ans chanels and i want to see the list of files depending the channel selected.

 

I created a Flow like you explain and the result is correct but i don't know how to give back the information to the power app gallery.

 

Please, can you help me? 

Helpful resources

Announcements
Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Government Carousel

New forum: GCC, GCCH, DoD - Federal App Makers (FAM)

In response to the unique and evolving requirements of the United States public sector, Microsoft has created Power Apps US Government.

Users online (4,280)