web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Increment Excel Column...
Power Automate
Unanswered

Increment Excel Column if Value specific Value in Forms selected

(0) ShareShare
ReportReport
Posted on by 2
I have a Microsoft Forms form which queries values in a predefined list.
The value that is passed should increase the value in an Excel table (ID, Key, Value) by 1 as soon as it is passed. 
I have created a flow that does the following: 
 
  • When a new response is submitted
  • Retrieve response details
  • Condition - was value XY passed? 
  • If yes
    • get row
    • update row
 
Here I use the following formula to increase the value: 
 
add(int(outputs('get_row')?['body/Counter']), 1)

The curious thing here is that this formula works for exactly one value. For all other values it throws the following error: 
 
Unable to process template language expressions in action 'Zeile_aktualisieren_-_Xing' inputs at line '0' and column '0': 'The template language function 'int' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'.
 

 
The column of the table in which the value is to be increased by +1 is defined as “Number”. 
Does anyone have a solution for this problem? 
 
Kind regards
Categories:
I have the same question (0)
  • Infamous_Let Profile Picture
    330 on at
    The error happens because the int() function expects a valid number, but for some rows, the value might be empty, null, or contain unexpected characters.
    A quick fix would be to use coalesce() to ensure there’s always a default value, like this:

    add(int(coalesce(outputs('get_row')?['body/Counter'], '0')), 1)
    This makes sure that if the column is empty, it defaults to 0 instead of causing an error.

    To see what’s actually being retrieved, you might want to add a Compose action before the update and check outputs('get_row')?['body/Counter']. That way, you can check if the issue comes from unexpected data.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 525 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 324 Moderator

#3
abm abm Profile Picture

abm abm 232 Most Valuable Professional

Last 30 days Overall leaderboard