Definitions
Condition
A logical statement used to branch a flow into different paths based on whether the condition is met or not. It helps make decisions in a flow.
Which function will return the current date and time?
a. utcNow
b. formatDateTime
c. UTCnow
d. Now
a. utcNow
Yes, just add an action into your flow and search excel!
Create a variable that adds the class size variable and the number 1.
add(variables('Class size'),1)
Create a variable that concatenates (sandwhiches) together my first name KIRSTEN and last name PANCRATZ together.
concat('KIRSTEN', ' PANCRATZ')
Expression
A formula or function used to perform calculations, or manipulate data.
Which of the following IS NOT A FUNCTION
a. concat()
b. addMinutes()
c. not()
d. play()
d. play()
Who is the best power automate instructor
Kirsten :-)
Create a variable that multiplies 5 times the class size.
mul(variables('Class size'),5)
Create a variable that concatenates (sandwiches) together the input of flow and my last name PANCRATZ together.
concat(triggerBody()['text'],' Pancratz')
Expression Editor
a tool used to write and manage expressions within a flow. It allows for complex logic and calculations to use in your flow.
What is the output of the expression
if ( equals(5,5), 'True', 'False' )
a. True
b. False
c. Error
d. 5
True
Show me how to copy and paste an action in power automate
1. click on three dots of the action.
2. copy to my clipboard
3. go to add a new action to flow
4. go to my clipboard tab
5. select action you copied
Create a variable that finds the maximum of the following numbers.
(10,36,4,9,50)
max(10,36,4,9,50)
Remember that if you are referencing the first s in sunshine, your index value would be 0.
substring('Sunshine',0,3)
Strings must always be contained in what?
' '
Explain what the function sort() would do to the following list of values.
(30,20,90,15,5)
The function would sort the list of values in order from smallest to largest.
(5,15,20,30,90)
What is Siemens first name
Werner Von
create a variable that will act as a random number generator between the numbers 1 to 50.
rand(1,50)
Set up a condition that checks if the class size variable is > than 10. Which way will we expect flow to run?
Class size is greater than 10
We expect it to return false or run down the No side since 7 is less than 10.
Please list out the steps to format an expression in power automate.
1. open the expression editor tab
2. enter the function name
3. add parenthesis after the function
4. follow input guide for function
5. separate inputs with a comma
6. close parenthesis of function
7. use dynamic content if needed in the expression
which of the following expressions DOES NOT use the input 'sunshine' and return the integer 3.
a. equals('sunshine','3')
b. sub(length('sunshine'),5)
c. length(substring('sunshine',0,3))
a. equals('sunshine','3')
When we are editing our flows, we always use the add an action button. What does the add a parallel branch button do?
A parallel branch allows you to run multiple actions at the same time within a flow. Instead of executing actions sequentially (one after the other)you can set up branches that execute at the same time. This helps improve efficiency and reduce the total time it takes for a flow to complete.
Create a variable that returns the number of characters in your flow input. Test run your flow and type in the input california.
length(triggerBody()['text'])
Set up a condition that checks if 2 times the class size variable is greater than 10. Which way will expect the flow to run?
mul(variables('Class size'),2) is greater than 10
We expect it to return true or run down the Yes side since 14 is greater than 10.