question

AngeloFanaras-5501 avatar image
0 Votes"
AngeloFanaras-5501 asked LeonLaude commented

powerautomate

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:

  1. 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

  2. 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






azure-ad-conditional-access
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

LeonLaude avatar image
0 Votes"
LeonLaude answered LeonLaude edited

Hi,

Power Automate is currently not supported in the Q&A forums, the supported products are listed over here https://docs.microsoft.com/en-us/answers/products (more to be added later on).

You can ask the experts in the dedicated Power Automate forum over here:
https://powerusers.microsoft.com/t5/Forums/ct-p/FL_Comm_Forums

(Please don't forget to accept helpful replies as answer)

Best regards,
Leon

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AngeloFanaras-5501 avatar image
0 Votes"
AngeloFanaras-5501 answered LeonLaude commented

Sorry, for posting on the wrong forum.
Thank you for pointing me to the right direction.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

No worries, you're welcome!

0 Votes 0 ·