QuestionQ157

Create and configure Power Apps

You are building a canvas app that uses a data source whose structure has three columns: Id, Value1, and Value2. Id is always unique, while Value1 and Value2 might not be.

You must use Power Fx to perform these operations:

  • Modify Value2 for one row when you know the Id and Value1.
  • Delete every row with a specified Value1.

Create the Power Fx commands. Each function may be used once, more than once, or not at all.

Drag & Drop
Remove
RemoveIf
Update
UpdateIf
Modify knowing Id and Value1.
Delete knowing Value1.
Explanation

UpdateIf modifies records that satisfy a condition, so an Id-and-Value1 predicate changes the single intended record because Id is unique. RemoveIf deletes all records that satisfy its condition, so a Value1 predicate removes every row with that specified value.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!