Error listing rows from Dataverse table

[jose_farinha]

I’m very disappointed with Power Automate / Apps. Lots of graphics and editing to achieve simple operations that one gets in the blink of the eye with other tools/languages.

And lots of non-sense errors. Like this one:

I have this simple action to get the lines of an order:

and I get this inexplicable error:

Could not find a property named 'cr776_order' on type 'Microsoft.Dynamics.CRM.cr776_orderitem'.

Which is non-sense because I do have a 'cr776_order' property (the last one below):

on table 'cr776_orderitem':

What am I missing?!

Thanks for your attention.

[Expiscornovus · Accepted solution]

Hi @jose_farinha,

Can you check the raw output of the list rows action without the filter?

My guess is that the name of the lookup column should be in a format with a leading underscore character and trailing _value.

_cr776_orderitem_value

Below is a similar kind of filter for retrieving contacts from a related account id which is using the same kind of formatting.

Hope this helps a bit?

[jsorris]

I always forget this. Thanks for the reminder.

[iskguy]

Thanks @Expiscornovus for the tip!  This just saved me a few hours