powerautomate

Angelo Fanaras 21 Reputation points
2020-06-14T15:00:48.09+00:00

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

Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
19,559 questions
0 comments No comments
{count} votes

Accepted answer
  1. Leon Laude 85,666 Reputation points
    2020-06-14T15:05:54.427+00:00

    Hi,

    Power Automate is currently not supported in the Q&A forums, the supported products are listed over here https://learn.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

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Angelo Fanaras 21 Reputation points
    2020-06-14T15:07:29.323+00:00

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