cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ErikM9
Helper I
Helper I

Filtered gallery from a filtered sharepoint list

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

1 ACCEPTED SOLUTION

Accepted Solutions

@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.

View solution in original post

4 REPLIES 4
eka24
Super User
Super User

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
Helper I
Helper I

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')

@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.

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

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (1,672)