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.
23,138 questions
0 comments No comments
{count} votes

Accepted answer
  1. Leon Laude 85,871 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.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.