I have a form that collects: name, location, 3 yes/no questions and a numeric value temperature. I created a powerautomate flow that writes to an excel (excel1) file and has two conditions. If any of the 3 yes/no answers are yes send an email to a predefine address, if no then write the name, location and time to a separate excel (excel2) sheet. The flow works great but I want to add some more to it and so far I haven't been able to manage. What I am trying to do is:
- Add the temperature to the yes/no conditions as another "or" like: if temperature is equal or greater than 100, or any of the 3 yes/no questions is a yes send and email. But I keep getting an error that it needs two values and cant figure out how to correct it
- If the condition is false it writes to an excel file- excel2. Is it possible to email a manager based on the location column? i created another column that with a vlookup formula inserts the manager email based on the location.
Learning powerautomate, still a novice, any help will be greatly appreciate it.
Angelo