Power Platform Community Forum Thread Details

Hi Community,

I’m working on a Power Automate flow that pulls data from the Vehicles table in Dataverse using the List rows action. The goal is to filter the table based on a Vehicle ID and return the matching record(s).

Here’s the current setup:

Entity Name: cr43b_vehicles
Fields I'm trying to select:
1. cr43b_vehicleregistration (Single line of text)
2. cr43b_vehicle2id (Unique Identifier for Vehicle
Filter Rows expression:

cr43b_vehicle2id eq @{triggerBody()?['text_2']}

4. Peak Code (List rows):

{

"{entityName": "cr43b_vehicles",

"$select": "cr43b_vehicleregistration,cr43b_vehicle2id",

"$filter": "cr43b_vehicle2id eq @{triggerBody()?['text_2']}"

}

Problem:

I keep getting this error:

Could not find a property named 'cr43b_vehicleregistration' on type 'Microsoft.Dynamics.CRM.cr43b_vehicle'.

I’ve double-checked the column names in Dataverse:

Vehicle Registration → Logical name: cr43b_VehicleRegistration
Vehicle (Primary Name) → Logical name: cr43b_vehicle2id

I’ve tried different combinations (lowercase, uppercase, using lookup references), but the same error persists.

Questions:

Is there something wrong with my $select or $filter Syntax?
Could the logical name cr43b_vehicleregistration be incorrect even though it’s shown in the column properties?
Is there a way to confirm valid field names for the List rows query (using metadata or a different action)?

Any guidance or examples would be greatly appreciated.

Attachments:

Vehicle table columns (highlighting the Vehicle field) – Image: Vehicle columns screen.
Vehicle Registration column properties – Image showing schema name and logical name.
Trip Log table columns – Image showing relevant relationships and fields.
Trip Log sample data – Image with sample records to show how Vehicle Registration is populated.
Flow run failure details – Image showing the full flow with the List Rows step failing, including the error message on the right panel.
List Rows step configuration – Close-up image showing $select and $filter settings.