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.
For your condition, see my example below:
With regards to your second question, you can't do a VLOOKUP. If you provide some additional information I might be able to suggest an alternative.
Really appreciate taking the time to help.
Your condition is in the right place.
If your org chart has been defined in Office 365, you can use the Office 365 Users Get Manager action to find the managers email. See my screen shot below:
The temperature solution is more important to resolve and in dire need! Thank you for your suggestions but I really can't make it work. Could you please elaborate on your solution? The way I have it right now it gives me an error that it is looking for two values to compare. What am I missing? again, please treat it as working with someone with basic knowledge on flows.
I couldn't get the temperature to work, it seems that it should be an easy thing, so I ended up asking a question on my form if the temp was higher than 99 or not and based on the text yes/no i can condition the flow.
As far as the email notification, we have the form to work outside the organization so i cannot filter for emails. Any other suggestions? Power automate does not have excel on row creation Triger yet, thinking i could had created a second flow to send out the email.
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
Many congratulations to the Season 1 2021 Flownaut Crew!
Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.
Check out the community blog page where you can find valuable learning material from community and product team members!