Unable to get column data from lookup

(1) Share

Report

Posted on by KV-04061813-0

Hi,

I am building a flow which populates a word template and converts to pdf.

I need data from 2 tables:

- proddiscs which I successfully take by adding the logical names in the Select field of action List Rows (with entity being Proddiscs which contains most of my info without lookup columns).

-departments which holds the primary column kv_owneremail value. Proddiscs table holds a lookup column to Departments table column kv_owneremail, its logical name is kv_owner

Then using a select action I populate the word file.

If I add kv_owner in the select field of List rows action (entity is Proddiscs) and then link it to the Owner(Value) from the Select dynamic content coming from List Rows I get an error saying that: Action 'List_rows' failed: Could not find a property named 'kv_owner' on type 'Microsoft.Dynamics.CRM.kv_proddisc'.

If I try to expand by using kv_owner($select=kv_owneremail) in the List rows action I get the exact same error as above.

Any help would be highly appreciated.

Kostas

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

Fredrik_A 3,403 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!
Hello,

Without knowing what your list rows looks like, could you try the below code please? If it doesn't work, could you please share an image of your list rows step?

Expand query should be:
kv_owner($select=kv_owneremail)

Select code should be: item()?['kv_owner']?['kv_owneremail']

If my response solved your issue, please mark it as ✅ Accepted Answer and give it a like.

Was this reply helpful? Yes No
KV-04061813-0 31 on at

Like (0)

Report
Copy link

Link copied!

thanks for the prompt response. Using the code in expand and select, resulted in the same error (Action 'List_rows' failed: Could not find a property named 'kv_owner' on type 'Microsoft.Dynamics.CRM.kv_proddisc'). My list rows is as follows. Again, kv_owner is a lookup column in proddiscs.

Was this reply helpful? Yes No
Suggested answer

Fredrik_A 3,403 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Kvowner isnt in the select unless im seeing wrong.

Try adding it there

Was this reply helpful? Yes No
KV-04061813-0 31 on at

Like (0)

Report
Copy link

Link copied!

Even if I add kv_owner in select query I get the same error. However adding _kv_owner_value in select of list rows is retrieving the data (checking this with compose) but the actual email is in _kv_owner_value@OData.Community.Display.V1.FormattedValue.

The _kv_owner_value returns the GUID and I can add this in the word template but cant correlate with the email value.

Now, If I add the _kv_owner_value in select query of listrow and expand with _kv_owner_value($select=kv_owneremail) I get the following error: Action 'List_rows' failed: Property '_kv_owner_value' on type 'Microsoft.Dynamics.CRM.kv_proddisc' is not a navigation property or complex property. Only navigation properties can be expanded.

regards

Was this reply helpful? Yes No
Verified answer

KV-04061813-0 31 on at

Like (0)

Report
Copy link

Link copied!

the solution was simple really, the expand should be with the schemaname not the logical name. So it required the _logicalname_value in the list rows select query and in the expand: schemaname($select=columnlogicalname).

regards,

Kostas

Was this reply helpful? Yes No