Hi everyone,
I am using Power Automate with a form trigger. This form allows users to select a material for purchase (we are in a school), and students choose the material and specify the quantity. The data is then transferred to an Excel sheet, which is used for stock management.
Within the flow, I also create a Teams approval request for the requested material, which we manually approve. Now, I want the flow to send an email to the individuals responsible for making a purchase when a material is running low and falls below 20 units.
Unfortunately, I am encountering an issue. Everything else works perfectly fine. I am receiving the message: 'Unable to process template language expressions for action 'Condition_1' at line '0' and column '0': 'The template language function 'lessOrEquals' expects two parameters of matching types. The function was invoked with values of type 'String' and 'Integer' that do not match.'
In my table, there are 5 columns and 10 rows (representing 10 types of materials). I want an email to be sent if a material falls below 20 units. I am also struggling with the 'For each' loop because it sends several emails when I only want to send one.
I am not sure if I am being clear, but I have attached some screenshots. Thank you for your assistance.
