You’re offline. This is a read only version of the page.
8
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.
does the issue got resolved ?
Nived N 🚀
LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌
Hi @LULU5
based on error details which you have shared, i think this is due to highlighted content
So may that value is considered as string even though it is integer. So one way would be resolve this error would be to wrap int() function around the highlighted dynaimaic content. I hope that would helps !
#1
WarrenBelz
146,618
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,962
Most Valuable Professional
Share
Report
All responses (
Answers (
