Hello,
I'm new to Microsoft Power Automate. I have an Excel file table with 4 columns and one of the columns is 'Amount' where the data in Currency format in Excel
I need to read the data from the Excel where the Amount is greater than $200
For this, I have the following on My Flows:
1. List rows present in Table
2. Apply to each
Select an output from the previous steps: = value
Condition is Amount greater than 200
Fails at 'Apply to each' step. Shows an error 'Unable to process template language expression for action 'Condition' at line '0' and column '0'. 'The template language function 'greater' expects two parameter of matching types. The function was invoked with values of type 'String' and 'Integer' that do not match'.
I used int(200). It still did not work. Can you please assist. Thankyou.