RecordInfo

How to Use the Power Fx RecordInfo  Function in Power Apps

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.

Power Apps Training Courses by G Com Solutions (0800 998 9248)