Skip to main content

Notifications

Power Apps - Microsoft Dataverse
Answered

Could not find a property named - Lookup field API column Data

Posted on 17 Aug 2023 21:28:19 by 34

Hello,

 

I am actually trying to create a power automate flow and within that I'm trying filter rows using a lookup field. I'm using the logical name of the lookup field in the table being used which in this case is "new_stageid", however, I keep getting a parsing error and the exception name is Microsoft.OData.ODataException: Could not find a property named 'new_stageid'.

 

So I went into dataverse and found the column and within tools, clicked on API Link to Column Data, however, even from the API call, I am getting the same error saying that it could not find a property named that within the table.

 

This is a very frustrating error, because I tried many other things but for some reason this just keeps happening with lookup fields, but works fine with regular fields. I can add another action to filter the list but I would prefer to have it in that action itself.

 

Any clues?

  • RCSI_SIA_BAH Profile Picture
    RCSI_SIA_BAH 34 on 21 Aug 2023 at 10:14:26
    Re: Could not find a property named - Lookup field API column Data

    @Fubar Thank you for this, apparently that was it, I called the API for the column data and adjusted the URL to have the column name as _columnlogicalname_value and within the filter on Power Automate remove the quotes since it is a GUID and it works as it should.

  • Verified answer
    Fubar Profile Picture
    Fubar 7,561 on 21 Aug 2023 at 04:18:04
    Re: Could not find a property named - Lookup field API column Data

    the API link to Column in the make interface is not correct for lookups.  The column for a lookup should be _logicalschemaname_value (https://learn.microsoft.com/en-us/power-apps/developer/data-platform/webapi/query-data-web-api#lookup-property-data)

    if you do the API link to Column and then adjust the browser url to what should be the correct column name (_ prefix and _value suffix) - do you get any results? if get a similar error make sure you have published the Table.

  • PowerThomas Profile Picture
    PowerThomas 277 on 20 Aug 2023 at 20:33:24
    Re: Could not find a property named - Lookup field API column Data

    This is indeed highly recommend. I always have FetchXML builder open when working in Power Automate with Dataverse tables.

  • a33ik Profile Picture
    a33ik 3,310 on 20 Aug 2023 at 20:04:07
    Re: Could not find a property named - Lookup field API column Data

    Hello,

    I would highly recommend checking Dataverse Rest Builder plugin of XrmToolbox. It should help you build the query you want to build.

  • RCSI_SIA_BAH Profile Picture
    RCSI_SIA_BAH 34 on 20 Aug 2023 at 07:50:30
    Re: Could not find a property named - Lookup field API column Data

    @parvezghumra I have tried even with the underscore ad a prefix yet still the results are the same. I will try out the FetchXML Builder tool regardless, but it does seem as you said a bug in the API Column Data.

  • Parvez Ghumra Profile Picture
    Parvez Ghumra 1,584 on 18 Aug 2023 at 11:49:06
    Re: Could not find a property named - Lookup field API column Data

    @RCSI_SIA_BAH It should be _new_stageid_value not new_stageid or new_stageid_value. In other words you need to include the leading underscore ( _ ) prefix

     

    The FetchXML Builder tool in XRM Toolbox is a great help. You can use it to build your query using a GUI and then convert it from the underlying FetchXML to other formats like oData query, Power Automate parameters, C#, or JavaScript code. I would highly recommend this. But from what you're describing here, there might be a bug here in the 'API Link to Column Data' functionality

  • RCSI_SIA_BAH Profile Picture
    RCSI_SIA_BAH 34 on 17 Aug 2023 at 23:24:56
    Re: Could not find a property named - Lookup field API column Data

    @parvezghumra 
    Getting the API Column data from DataverseGetting the API Column data from DataverseThe API call response stating that the property name could not be foundThe API call response stating that the property name could not be foundPower Automate Trigger using the lookup field logical name to filter (Even the original logical name when used gives the same error)Power Automate Trigger using the lookup field logical name to filter (Even the original logical name when used gives the same error)Exception foundException found

    I have attached 4 screenshots above, the first one showing the way I get the API column data.
    The second one showing the results from the API call stating that the property name does not exist under the table.
    The third one shows the trigger action within Power Automate using the fields for filtering the rows (the screenshot is using the suggested logical names, however, using the original logical name provides the same result).
    The fourth one shows the exception found within Power Automate that prevents the flow from executing, the full error message is as follows:
    Exception parsing new_stageid_value eq '54bf33f3-c120-ee11-9966-000d3a296018' or new_stageid_value eq '067b9dfd-c120-ee11-9966-000d3a296018' or new_stageid_value eq '50e3ab04-c220-ee11-9966-000d3a296018' for attribute filterexpression of callback registration. Target entity: new_appealstage. Exception: Microsoft.OData.ODataException: Could not find a property named 'new_stageid_value' on type 'CallbackRegistration.new_appealstage'.
    at Microsoft.OData.UriParser.EndPathBinder.GeneratePropertyAccessQueryForOpenType(EndPathToken endPathToken, SingleValueNode parentNode)
    at Microsoft.OData.UriParser.EndPathBinder.BindEndPath(EndPathToken endPathToken)
    at Microsoft.OData.UriParser.MetadataBinder.Bind(QueryToken token)
    at Microsoft.OData.UriParser.BinaryOperatorBinder.GetOperandFromToken(BinaryOperatorKind operatorKind, QueryToken queryToken)
    at Microsoft.OData.UriParser.BinaryOperatorBinder.BindBinaryOperator(BinaryOperatorToken binaryOperatorToken)
    at Microsoft.OData.UriParser.MetadataBinder.Bind(QueryToken token)
    at Microsoft.OData.UriParser.BinaryOperatorBinder.GetOperandFromToken(BinaryOperatorKind operatorKind, QueryToken queryToken)
    at Microsoft.OData.UriParser.BinaryOperatorBinder.BindBinaryOperator(BinaryOperatorToken binaryOperatorToken)
    at Microsoft.OData.UriParser.MetadataBinder.Bind(QueryToken token)
    at Microsoft.OData.UriParser.BinaryOperatorBinder.GetOperandFromToken(BinaryOperatorKind operatorKind, QueryToken queryToken)
    at Microsoft.OData.UriParser.BinaryOperatorBinder.BindBinaryOperator(BinaryOperatorToken binaryOperatorToken)
    at Microsoft.OData.UriParser.MetadataBinder.Bind(QueryToken token)
    at Microsoft.OData.UriParser.FilterBinder.BindFilter(QueryToken filter)
    at Microsoft.OData.UriParser.ODataQueryOptionParser.ParseFilter()
    at System.Web.OData.Query.FilterQueryOption.get_FilterClause()
    at Microsoft.Crm.ObjectModel.EdmModelEvaluator.EvaluateFilterExpression(String filterExpression, ODataQueryOptions queryOptions)
    at Microsoft.Crm.ObjectModel.EdmModelEvaluator.EvaluateFilterExpression(String filterExpression)
    at Microsoft.Crm.ObjectModel.CallbackRegistrationService.<>c.<.cctor>b__73_0(EdmModelEvaluator evaluator, String testValue)
    at Microsoft.Crm.ObjectModel.CallbackRegistrationService.ValidateInputEntity(IBusinessEntity entity, ExecutionContext context, IFeatureDetailContainer featureDetailContainer)

  • Parvez Ghumra Profile Picture
    Parvez Ghumra 1,584 on 17 Aug 2023 at 23:09:07
    Re: Could not find a property named - Lookup field API column Data

    @RCSI_SIA_BAH Can you share a screenshot of the error and of the trigger showing how you have set its properties

  • RCSI_SIA_BAH Profile Picture
    RCSI_SIA_BAH 34 on 17 Aug 2023 at 23:06:23
    Re: Could not find a property named - Lookup field API column Data

    @parvezghumra This isn't a polymorphic relationship, however, I did try the suggested and got the same result.

    We get the same output when we try to get the API column data from any other table that contains any other lookup from any other table, which is that it is unable to find the property name "Given Logical Name" under the specified table.

  • Parvez Ghumra Profile Picture
    Parvez Ghumra 1,584 on 17 Aug 2023 at 22:46:10
    Re: Could not find a property named - Lookup field API column Data

    @RCSI_SIA_BAH Is this a polymorphic lookup? If not, try _new_stageid_value in your filter expression

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,137

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,813

Leaderboard

Featured topics