Answered

Error in getting row from Dataverse Table

(0) Share

Report

Posted on by asynadinou

Hello,

I would appreciate any help on the following. I am trying to get a Dataverse table row by Id. The value for the Id is the value from a parameter of an Http request. The value is 'Subcategory 2'. The Row Id field of the table is the one defined as primary key (primary name column), correct?

The retrieval fails with ' 'Not Found' error as you can see below, although there is a record with this Id in the table. Can anybody explain why this happens and what is the entity name 'crbc1_modifyfieldses' that I see in the input parameters of Get a row by Id in the 3rd screenshot below?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

LukeMcG 48 on at

Like (0)

Report

Hi @asynadinou,

When using the Dataverse connector, the actions will be expecting a GUID for the Row ID parameter which is not the same as the Primary Name value. This Learn page explains the difference between Primary Key and Primary Name: Table definitions in Microsoft Dataverse - Power Apps | Microsoft Learn

The entity name that you see in the input parameters will be the logical name of your Dataverse table (I believe the "Deflection" table based on your screenshots), this value is based on the table name provided when the table is created and can't be changed.

To get the row that you're looking for which matches the specific "Subcategory intent" text value that is passed in from your HTTP request trigger, I'd recommend using a "List Rows" action and using the "Filter Rows" input to provide an ODATA filter instead.

You'll need the logical name of your "Subcategory intent" column which you should able to see in your table definition by navigating to "Columns":

Your filter should then look similar to this:

Was this reply helpful? Yes No
asynadinou 61 on at

Like (0)

Report

Perfect, @LukeMcG ! It worked.

Was this reply helpful? Yes No