Action functions
The Power Query Formula Language is a powerful query language optimized for building queries that mashup data. It's a functional, case sensitive language similar to F#, which can be used with Power Query in Excel, Get & Transform in Excel 2016, and Power BI Desktop. To learn more, see the PowerQueryName reference.
Constants
| Action | Description |
|---|---|
| Action.Donothing | An action that performs no action when executed and returns null as its result. |
| Action.Return | Creates an action that performs no action when executed and returns value as its result. |
| Action.Sequence | Creates an action that executes the sequence of elements in actions in order. |
| Action.Try | Creates an action that executes action, catches any errors that occur while executing the action, and returns a record containing a HasError field and either a Value or Error field depending on whether the action executed successfully. |
| TableAction.DeleteRows | Creates an action to delete rows from a table. |
| TableAction.InsertRows | Creates an action to insert rows into a table. |
| TableAction.UpdateRows | Creates an action to update rows in a table. |
| ValueAction.NativeStatement | Creates an action to execute a statement against a target. |
| ValueAction.Replace | Creates an action that replaces the content of a value with the specified value. |
| WebAction.Request | Creates an action that, when executed, will return the results of performing an HTTP request as a binary value. |
Show: