web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps COmbining sort with fi...

Power Apps

Unanswered

COmbining sort with filter with Document Library as source

(0) Share

Report

Report

Posted on by EriSto

137

I have built an app to e-mail project specific documents to the user.

I can outline the app quick:

The welcoming screen has a gallery (BrowseGallery1) that shows a list of projects (source is a SharePoint list with project name, and number)

When you select the project you want, you navigate to the next screen which has a new gallery (Gallery1). The gallery in this screen uses a document library (ProjForPADocs) as the source.

You then get a list of all of the files that have the same project number (they are .pdf files).

To get the items in the gallery to display the name of the files, I have added a title (Title3), where the Text = ThisItem.’File name with extension’

The gallery then lists every .pdf connected to that project.

My problem is, I can not figure out how to get the gallery to sort alphabetically. Right now it just lists up the .pdf’s in any random order.

I have tried sorting like I do when I have pure SharePoint lists, but that doesn’t work with items in a gallery.

Any tips? I think I have to combine the sort code to include both the source (ProjForPADocs), and the title (Title3) somehow.

Thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Verified answer

SkiDK 1,016 on at

Like (2)

Report
Hi @EriSto
Can't you do it like this in the gallery items property:
Sort(ProjForPADocs, 'File name with extension', Ascending)
Could you show what line of code you used for sorting? It might help tracking down why it doesn't work.

Was this reply helpful? Yes No
EriSto 137 on at

Like (1)

Report

@SkiDK thanks for the response, I need to facepalm rihgt now..... 😄

I was using:
Sort(Filter(ProjForPADocs, ItemID=Text(BrowseGallery1.Selected.ProjNr), 'File name with extension', Ascending)

instead of:
Sort(Filter(ProjForPADocs, ItemID=Text(BrowseGallery1.Selected.ProjNr)), 'File name with extension', Ascending)

Was this reply helpful? Yes No
appdevelopermcs 6 on at

Like (0)

Report

wait what

Was this reply helpful? Yes No

Join the conversation