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

ActionDescription
Action.DonothingAn action that performs no action when executed and returns null as its result.
Action.ReturnCreates an action that performs no action when executed and returns value as its result.
Action.SequenceCreates an action that executes the sequence of elements in actions in order.
Action.TryCreates 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.DeleteRowsCreates an action to delete rows from a table.
TableAction.InsertRowsCreates an action to insert rows into a table.
TableAction.UpdateRowsCreates an action to update rows in a table.
ValueAction.NativeStatementCreates an action to execute a statement against a target.
ValueAction.ReplaceCreates an action that replaces the content of a value with the specified value.
WebAction.RequestCreates an action that, when executed, will return the results of performing an HTTP request as a binary value.
Show: