Applies to Product - Microsoft Dataverse
What’s happening?
The Dataverse 'List Rows' connector is not returning the expected GUID for the field new_parenttransactionid, even though data exists for this field. The flow runs without error and successfully retrieves the new_transactionid GUID.
The Dataverse 'List Rows' connector is not returning the expected GUID for the field new_parenttransactionid, even though data exists for this field. The flow runs without error and successfully retrieves the new_transactionid GUID.
Reason:
This is by design; the Power Automate 'List Rows' connector will only return the reference to any lookup fields. To retrieve the GUID, an Expand Query must be used.
This is by design; the Power Automate 'List Rows' connector will only return the reference to any lookup fields. To retrieve the GUID, an Expand Query must be used.
Resolution:
To resolve this, use the following Expand Query format in the 'List Rows' connector: - new_ParentTransactionId($select=new_transactionid)
This will allow the retrieval of the lookup GUID for the new_parenttransactionid field.
To resolve this, use the following Expand Query format in the 'List Rows' connector: - new_ParentTransactionId($select=new_transactionid)
This will allow the retrieval of the lookup GUID for the new_parenttransactionid field.