PowerQueryFormulaFunction

PowerQueryFormulaFunction class

Represents the function of power query.

class PowerQueryFormulaFunction extends PowerQueryFormula;

Constructors

Constructor	Description
constructor(PowerQueryFormula)	Constructs from a parent object convertible to this.

Properties

Property	Type	Description
f	string	Gets and sets the definition of function.
groupName	string	Readonly. Gets the name of group which contains this power query formula.
name	string	Gets and sets the name of the power query formula.
description	string	Gets and sets the description of the power query formula.
powerQueryFormulaItems	PowerQueryFormulaItemCollection	Readonly. Gets all items of power query formula.

Methods

Method	Description
getF()	@deprecated. Please use the ‘f’ property instead. Gets and sets the definition of function.
setF(string)	@deprecated. Please use the ‘f’ property instead. Gets and sets the definition of function.
isNull()	Checks whether the implementation object is null.
getGroupName()	@deprecated. Please use the ‘groupName’ property instead. Gets the name of group which contains this power query formula.
getName()	@deprecated. Please use the ’name’ property instead. Gets and sets the name of the power query formula.
setName(string)	@deprecated. Please use the ’name’ property instead. Gets and sets the name of the power query formula.
getDescription()	@deprecated. Please use the ‘description’ property instead. Gets and sets the description of the power query formula.
setDescription(string)	@deprecated. Please use the ‘description’ property instead. Gets and sets the description of the power query formula.
getPowerQueryFormulaItems()	@deprecated. Please use the ‘powerQueryFormulaItems’ property instead. Gets all items of power query formula.
getType()	Gets the type of power query formula.
getFormulaDefinition()	Gets the definition of the power query formula.

constructor(PowerQueryFormula)

Constructs from a parent object convertible to this.

constructor(obj: PowerQueryFormula);

Parameters:

Parameter	Type	Description
obj	PowerQueryFormula	The parent object.

f

Gets and sets the definition of function.

f : string;

groupName

Readonly. Gets the name of group which contains this power query formula.

groupName : string;

name

Gets and sets the name of the power query formula.

name : string;

description

Gets and sets the description of the power query formula.

description : string;

powerQueryFormulaItems

Readonly. Gets all items of power query formula.

powerQueryFormulaItems : PowerQueryFormulaItemCollection;

getF()

@deprecated. Please use the ‘f’ property instead. Gets and sets the definition of function.

getF() : string;

setF(string)

@deprecated. Please use the ‘f’ property instead. Gets and sets the definition of function.

setF(value: string) : void;

Parameters:

Parameter	Type	Description
value	string	The value to set.

isNull()

Checks whether the implementation object is null.

isNull() : boolean;

getGroupName()

@deprecated. Please use the ‘groupName’ property instead. Gets the name of group which contains this power query formula.

getGroupName() : string;

getName()

@deprecated. Please use the ’name’ property instead. Gets and sets the name of the power query formula.

getName() : string;

setName(string)

@deprecated. Please use the ’name’ property instead. Gets and sets the name of the power query formula.

setName(value: string) : void;

Parameters:

Parameter	Type	Description
value	string	The value to set.

getDescription()

@deprecated. Please use the ‘description’ property instead. Gets and sets the description of the power query formula.

getDescription() : string;

setDescription(string)

@deprecated. Please use the ‘description’ property instead. Gets and sets the description of the power query formula.

setDescription(value: string) : void;

Parameters:

Parameter	Type	Description
value	string	The value to set.

getPowerQueryFormulaItems()

@deprecated. Please use the ‘powerQueryFormulaItems’ property instead. Gets all items of power query formula.

getPowerQueryFormulaItems() : PowerQueryFormulaItemCollection;

Returns

PowerQueryFormulaItemCollection

getType()

Gets the type of power query formula.

getType() : PowerQueryFormulaType;

Returns

PowerQueryFormulaType

getFormulaDefinition()

Gets the definition of the power query formula.

getFormulaDefinition() : string;