We can use invoke an HTTP request to get the Dataverse Id of a record via an OData query, e.g. for the cm_outdooractivities table find the record where cm_sqlid eq 1

/api/data/v9.2/cm_outdooractivities?$select=cm_outdooractivityid&$filter=cm_sqlid%20eq%201

cm_sqlid is actually defined as an alternate key so we can also use:

/api/data/v9.2/cm_outdooractivities(cm_sqlid=1)?$select=cm_outdooractivityid

Retrieve the id via the below in the compose action:

first(body('Invoke_an_HTTP_request')?['value'])?['cm_outdooractivityid']