- 24 - items
- Power BI Training for Operations Professionals (2 Days) 1 x £1,990.00
- Power BI Training for Marketing Professionals (2 Days) 1 x £1,990.00
- Power BI Training for Facility Management Professionals (2 Days) 19 x £1,990.00
- Power BI Training for HR Professionals (2 Days) 1 x £1,990.00
- Power BI Training for IT Management Professionals (2 Days) 1 x £1,990.00
- View All 24 Items
A
C
D
I
R
S
T
Understanding the RecordInfo Function
The RecordInfo function retrieves information about a record in a table. The function takes a single argument, which is the record you want to retrieve information about. The syntax of the RecordInfo function is as follows:
RecordInfo( Record )
The Record argument is a reference to the record you want to retrieve information about. The Record argument can be a record from a table or a collection.
Retrieving Entity Information
The RecordInfo function allows you to retrieve the entity name of a record. This is useful when you want to perform operations on the entity, such as creating or updating records. To retrieve the entity name of a record, you can use the following expression:
RecordInfo(MyRecord).EntityName
In this expression, MyRecord is a reference to the record you want to retrieve the entity name of. The EntityName property returns the name of the entity that the record belongs to.
Retrieving Primary Key Information
The RecordInfo function also allows you to retrieve the primary key of a record. This is useful when you want to perform operations on a specific record. To retrieve the primary key of a record, you can use the following expression:
RecordInfo(MyRecord).PrimaryKey
In this expression, MyRecord is a reference to the record you want to retrieve the primary key of. The PrimaryKey property returns the value of the primary key for the record.
Retrieving Record Type Information
The RecordInfo function also allows you to retrieve the record type of a record. This is useful when you want to perform operations on a specific type of record, such as an account or a contact. To retrieve the record type of a record, you can use the following expression:
RecordInfo(MyRecord).RecordType
In this expression, MyRecord is a reference to the record you want to retrieve the record type of. The RecordType property returns the name of the record type for the record.
Retrieving Other Information
The RecordInfo function also allows you to retrieve other information about a record, such as the date and time it was created or modified. To retrieve this information, you can use the following expressions:
RecordInfo(MyRecord).CreatedOn
RecordInfo(MyRecord).ModifiedOn
In these expressions, MyRecord is a reference to the record you want to retrieve information about. The CreatedOn property returns the date and time the record was created, while the ModifiedOn property returns the date and time the record was last modified.
The RecordInfo function is a powerful tool that allows you to retrieve metadata about a record in Power Apps. By using the RecordInfo function, you can easily access information about a record, such as its entity name, primary key, and record type. This information can be used to perform operations on the record, such as creating or updating it. If you are using Power Apps to create custom business solutions, the RecordInfo function is a tool that you should definitely add to your toolkit.