Filtered gallery from a filtered sharepoint list

[ErikM9]

Hello,

I hope my explain myself correctly here 🙂

I have a PowerApps that pulls from a list on Sharepoint to a collection.

However, the list is has three sub-topics. PowerApps pulls all list items.

How can I just pull from a particular sub-topic? 

Thank you - Erik

[eka24]

By sub topic are you referring to columns?

Also can you state you current formula?

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[ErikM9]

Ah yes. Thanks eka24.

The SharePoint is filtered to show or exclude certain columns. 

The PowerApps is seeing all documents.

The formula is (I think it is what you are asking for):

ClearCollect(colPAWS, 'AWT Documents')

[eka24 · Accepted solution]

@ErikM9 

You can use DropColumns or ShowColumns

AddColumns, DropColumns, RenameColumns, and ShowColumns functions - Power Apps | Microsoft Docs

ClearCollect(colPAWS, ShowColumns('AWT Documents',"Column1","Column1"))

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[ErikM9]

Thanks eka24,

I'm selecting the columns of interest. 

It is curious that I have lost a preview of the .pptx file - EDIT: I needed to add the thumbnail column

But I'm much further ahead than where I was.

Erik