count files in mappa

(0) Share

Report

Posted on by Karvalics

Hi,

I'm trying to count the number of files within a specific folder. I've found various solutions online, but they all seem to differ, and none of the syntax examples (like %Files.Count%, length.files, etc., where 'files' represents the retrieved files from the folder) are working for me. Could you assist?"

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

eetuRobo 4,522 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

I recommend you create a new flow with Power Fx not enabled. Seems like you have it enabled. Power Fx and regular PAD flows have very different syntax and most solutions, tutorials and documentation will be for regular flows since Power Fx is still fairly new in Power Automate Desktop.

Power Fx uses = sign to reference functions or variables. It doesn't recognize the %variable% -syntax.

Regular flow
With the regular flow you can get the count easily like so:

Power Fx flow
Use CountRows() -function

Was this reply helpful? Yes No

Suggested answer

Riyaz_riz11

4,150 Super User 2026 Season 1 on at

Like (0)

Report

Copy link

Link copied!

Hi,

When Power Fx expressions are enabled in Power Automate Desktop, the older %Variable.Property% syntax is replaced by the Power Fx formula language, which behaves more like Excel or Power Apps logic.

Mode	Syntax to Count Files	Notes
🟠 Classic PAD mode	`%Files.Count%`	Traditional PAD variable syntax
🟢 Power Fx mode (Fx enabled)	`CountRows(Files)`	Uses Power Fx functions

How to Know You're in Power Fx Mode:

Expression boxes show an fx symbol
Variable names don’t use %...%
You can use Excel-like functions: If(), CountRows(), First(), Text(), etc.