Answered

Argument 'EndRow' must be an integer value

(1) Share

Report

Posted on by Nevul

Hello,

I'm trying an operation on the End Row field, then I check another question about the same problem. They indicate using %operation%.
Example:
%FirstFreeRowOnColumn2 - 1%

But it generates the same error: Argument 'EndRow' must be an integer value

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

eetuRobo 4,206 Super User 2025 Season 2 on at

Like (1)

Report

You are using wrong syntax since you seem to have Power Fx enabled. That syntax would work with regular flow like in the thread you linked. But since you are using power fx enabled flow you shouldn't use percent signs (%) since thats just text to Power Fx. With Power Fx you use equal sign before the operation. So =operation instead of %operation%

In the end row use =FirstFreeRowOnColumn2 -1

Like so:

Was this reply helpful? Yes No
Nevul 4 on at

Like (0)

Report

I tried different ways, including the one you mention, and it still always gave the same error.

.
However, I tried one last time with the way you indicated and it actually worked. I honestly didn't understand what the change was to make it work, but thanks anyway @eetuRobo👍

Was this reply helpful? Yes No