Power Fx Formula Basics for Developers

1. In Power Fx, what does the Patch() function accomplish?

Updates or creates records in a data source

Deletes records from a table

Merges two tables together

Exports data to Excel

Submit

3. What does the ForAll() function iterate over in Power Fx?

Each record in a table

Each character in a string

Each property of an object

Each column in a table

4. Which function removes whitespace from the beginning and end of text?

Trim()

Strip()

Clean()

Compress()

5. True or False: The With() function creates a local scope for variables.

True

False

Submit

7. What does the Concat() function do?

Joins text values from a table with a separator

Combines two numbers

Merges multiple tables

Concatenates only the first two values

8. Which operator performs logical AND in Power Fx?

&&

AND

And

Both a and b

9. What is the correct way to reference a control's property in a formula?

ControlName.PropertyName

[ControlName].PropertyName

ControlName->PropertyName

$ControlName.PropertyName

10. True or False: The LookUp() function returns only the first matching record.

True

False

11. What is the primary purpose of the Power Fx language in Power Platform?

To define formulas and expressions for apps and cloud flows

To manage database schemas

To create user interface designs

To configure security policies

12. Which function extracts text from the middle of a string?

Mid()

Extract()

Substr()

Slice()

13. What does the Filter() function do in Power Fx?

Returns rows from a table that meet specified conditions

Sorts a table in ascending order

Removes duplicate records

Groups records by a column

14. True or False: Power Fx is case-sensitive for function names.

True

False

15. Which function counts the number of rows in a table?

CountRows()

Count()

Length()

Rows()

16. What is the correct syntax for an IF statement in Power Fx?

If(condition, value_if_true, value_if_false)

If condition then value_if_true else value_if_false

Condition ? value_if_true : value_if_false

IfThen(condition, value_if_true, value_if_false)

17. In Power Fx, what is a context variable?

A variable scoped to a screen or control

A global variable across all apps

A variable stored in the cloud

A read-only system variable

18. Which function returns the current date and time in Power Fx?

Now()

Today()

Current()

DateTime()

19. What does the Set() function do in Power Fx?

Creates or updates a variable with a value

Removes a variable from memory

Compares two values

Filters a table of records

20. In Power Fx, which operator is used for string concatenation?

&

+

||

..

Power Platform Developer Power Fx Formula Basics Quiz

1. In Power Fx, what does the Patch() function accomplish?

2.

What first name or nickname would you like us to use?

2. The ____ function rounds a number to a specified number of decimal places.

3. What does the ForAll() function iterate over in Power Fx?

4. Which function removes whitespace from the beginning and end of text?

5. True or False: The With() function creates a local scope for variables.

6. In Power Fx, a ____ variable persists across screen navigation.

7. What does the Concat() function do?

8. Which operator performs logical AND in Power Fx?

9. What is the correct way to reference a control's property in a formula?

10. True or False: The LookUp() function returns only the first matching record.

11. What is the primary purpose of the Power Fx language in Power Platform?

12. Which function extracts text from the middle of a string?

13. What does the Filter() function do in Power Fx?

14. True or False: Power Fx is case-sensitive for function names.

15. Which function counts the number of rows in a table?

16. What is the correct syntax for an IF statement in Power Fx?

17. In Power Fx, what is a context variable?

18. Which function returns the current date and time in Power Fx?

19. What does the Set() function do in Power Fx?

20. In Power Fx, which operator is used for string concatenation?