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
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