web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Get count of gallery d...

Power Apps

Answered

Get count of gallery document format in a label

(0) Share

Report

Report

Posted on by Iantaylor2050

599

I have a powerapp gallery with SharePoint document library as the datasource.

Gallery Items Property

Filter(
 Documents,
 'Folder path' = "Shared Documents/Finance/" &DataCardValue3_2.Text&"/" 
)

Gallery Label

ThisItem.'FileNameWithExtension'

I need to get count of the documents in gallery whose file extension is pdf/pptx/docx/xlsx. May i know how to achieve this?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

wolenberg_ 1,476 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hello @Iantaylor2050 ,
You can create a If statement to count the files filtering the ending sufix
Something like this:
If(EndsWith( FileNameWithExtension, "pdf" ),Collect(colPdfs,ThisItem)) Set(varTotalPdfs, CountRows(colPdfs))

And the same for the rest of extensions that you got.

-------------------------------------------------------------------
If my reply helped you, please give a 👍
If it solved your issue, please give a 👍 & accept it as the Solution to help other community members find it.

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
HI @Iantaylor2050,

Set the Label text property as:

CountIf(Gallery4.AllItems,Last(Split(Label_Extension.Text,".")).Value in ["pdf","pptx","docx","xlsx"])

Was this reply helpful? Yes No

Join the conversation