TableValue Class
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Represents a table (both single columna and multi-column).
public abstract class TableValue : Microsoft.PowerFx.Types.ValidFormulaValuetype TableValue = class
inherit ValidFormulaValuePublic MustInherit Class TableValue
Inherits ValidFormulaValue- Inheritance
- Derived
Constructors
| TableValue(RecordType) | |
| TableValue(TableType) |
Fields
| ValueDName |
DName for ValueName. |
| ValueName |
Often marshalling an array will create a Single Column Tables with a single "Value" column. |
Properties
| CanShallowCopy | (Inherited from FormulaValue) |
| IsColumn | |
| Rows | |
| Type | |
Methods
| AppendAsync(RecordValue, CancellationToken) | |
| AsBoolean() | (Inherited from FormulaValue) |
| AsDecimal() | (Inherited from FormulaValue) |
| AsDouble() | (Inherited from FormulaValue) |
| CastRecord(RecordValue, CancellationToken) |
Casts |
| ClearAsync(CancellationToken) | |
| Count() | |
| First(Boolean) |
Lookup the first record, or return blank if the table is empty. |
| GetRowsHashCode() | |
| Index(Int32, Boolean) |
With mutation support, lookup the record at the given 1-based index, or return an error value if out of range. |
| Index(Int32) |
Lookup the record at the given 1-based index, or return an error value if out of range. |
| Last(Boolean) |
Lookup the last record, or return blank if the table is empty. |
| MaybeShallowCopy() |
Before mutation operations, call MaybeShallowCopy() to make a copy of the value. For most values this is a no-op and will not make a copy. Only types which implement IMutationCopy will have the opportunity to provide a copy. (Inherited from FormulaValue) |
| PatchAsync(RecordValue, CancellationToken) |
Modifies a single record based on primary key within the record itself. |
| PatchAsync(RecordValue, RecordValue, CancellationToken) |
Modifies one record in a data source. |
| PatchCoreAsync(RecordValue, RecordValue, CancellationToken) |
Patch implementation for derived classes. |
| PatchSingleRecordCoreAsync(RecordValue, CancellationToken) |
Patch single record implementation for derived classes. |
| RemoveAsync(IEnumerable<FormulaValue>, Boolean, CancellationToken) | |
| ToExpression() |
Provides serialization. Return an expression that, when evaluated in the invariant locale, recreates an equivalent formula value, including its type. This may not be the same as the expression used to originally create this type. (Inherited from FormulaValue) |
| ToExpression(StringBuilder, FormulaValueSerializerSettings) | |
| ToObject() | |
| TryGetIndex(Int32, DValue<RecordValue>, Boolean) | |
| TryGetIndex(Int32, DValue<RecordValue>) | |
| TryGetPrimitiveValue(Object) | (Inherited from FormulaValue) |
| TryShallowCopy(FormulaValue) | (Inherited from FormulaValue) |
| Visit(IValueVisitor) | |
Extension Methods
| CanCoerceToStringValue(FormulaValue) |
Can convert value to String format or not. |
| TryCoerceTo(FormulaValue, RuntimeConfig, StringValue) |
Try to convert value to String format. |
| TryCoerceTo(FormulaValue, RuntimeConfig, CancellationToken, StringValue) |
Try to convert value to String format. |
| TryCoerceTo(FormulaValue, BooleanValue) |
Try to convert value to Boolean format. |
| TryCoerceTo(FormulaValue, DateTimeValue) |
Try to convert value to DateTime format. |
| TryCoerceTo(FormulaValue, DecimalValue) |
Try to convert value to Number format. |
| TryCoerceTo(FormulaValue, FormulaType, FormulaValue) | |
| TryCoerceTo(FormulaValue, NumberValue) |
Try to convert value to Number format. |
| TryCoerceTo(FormulaValue, StringValue) |
Try to convert value to String format. |
| TryCoerceToTable(TableValue, TableType, TableValue) | |