Skip to main content

Notifications

Power Apps - Microsoft Dataverse
Unanswered

Dataverse lookup column filter, could not find property named...

(1) ShareShare
ReportReport
Posted on by 8

Hi all, I am trying to fill a collection with filtered data from Dataverse but getting an error when trying to filter up two lookups.

 

Formula:

 

ClearCollect(collectionSwitchboardFaults, Filter(SwitchboardInspectionFaults, Switchboard_Inspection__c.Inspection__c.Work_Order_Line_Item__c = varInspection.Work_Order_Line_Item__c));

 

Error:

 

Error when trying to retrieve data from the network: Could not find a property named 'irs_Inspection_c' on type 'Microsoft.Dynamics.CRM.irs_switchboardinspectionfault'.

 

Edit: This error doesn't make any sense to me. Why is it trying to find the Inspection_c field on the SwitchboardInspectionFault table when I am trying to lookup to the SwitchboardInspection table first?

 

Database Schema:

(Table names are slightly different)

image (4).png

 

Looking at the Monitor the getRows call that failed had this request URL:

 

https://xxxxxx.xxxx.dynamics.com/api/data/v9.0/irs_switchboardinspectionfaults?%24filter=irs_Inspection__c%2Firs_work_order_line_item__c+eq+%271WL2w000001lLSXGA2%27&%24expand=irs_Switchboard_Panel__c%28%24expand%3Dirs_Switchboard__c%29%2Cirs_Switchboard_Inspection__c%28%24expand%3Dirs_Inspection__c%29&%24count=true

 

Filtering through only one lookup works fine but is obviously not the data I need.

 

ClearCollect(collectionSwitchboardFaults, Filter(SwitchboardInspectionFaults, Switchboard_Inspection__c.PrimaryKey = varSwitchboardInspection.PrimaryKey));

 

Anyone have any ideas?

Categories:
  • Flec_t Profile Picture
    Flec_t 3 on at
    Re: Dataverse lookup column filter, could not find property named...

    Hello ! I have the same problem I didn't have before. ! (worked like a charm 1 week ago).

    I try to populate a collection with a Filter on my Dataverse Table "Prestations". This table has a link (LookUp) to a table Vacation which itself has a link (LookUp) to a table "Feuilles" 

    I try to get all the prestations linked to a "Feuilles" like this : Filter( Prestations; vacation.feuille.Name = myVariable)

    I now have the error "

    Error when trying to retrieve data from the network: Could not find a property named 'fdt_feuille' on type 'Microsoft.Dynamics.CRM.fdt_prestation'.

    "
    which is normal since : I don't have this property on my table Prestations, it is only linked to my table Vacations.
    When I look at the url of the request : it seems that PowerApps is trying to expand my Prestations Table with the Vacations Table AND with the Feuilles Table and is looking for the corresponding lookup column there (and it is obviously not there). 

    Were there any updates last week concerning the topic which could have created this new way of linking tables in a Filter request ?

     

  • lacmac Profile Picture
    lacmac 8 on at
    Re: Dataverse lookup column filter, could not find property named...

    Please actually read my post. That's the problem, the fields do exist.

     

    If I modify the URL to have the correct filter, it then returns the records correctly. For some reason Power Apps is not forming the correct URL. (I added what is in bold)

     

    https://xxxxxx.xxxxxx.dynamics.com/api/data/v9.0/irs_switchboardinspectionfaults?%24filter=irs_Switchboard_Inspection__c%2Firs_Inspection__c%2Firs_work_order_line_item__c+eq+%271WL2w000001lLSXGA2%27&%24expand=irs_Switchboard_Panel__c%28%24expand%3Dirs_Switchboard__c%29%2Cirs_Switchboard_Inspection__c%28%24expand%3Dirs_Inspection__c%29&%24count=true

     

    This filter would then match what the Filter in the formula is trying to do.

    i.e. Switchboard_Inspection__c.Inspection__c.Work_Order_Line_Item__c

  • Shashank Bhide Profile Picture
    Shashank Bhide 932 on at
    Re: Dataverse lookup column filter, could not find property named...

    So it's absolutely clear that the fields you are trying to read from Dataverse don't actually exist

  • lacmac Profile Picture
    lacmac 8 on at
    Re: Dataverse lookup column filter, could not find property named...

    No luck, it returns with the same error.

  • Shashank Bhide Profile Picture
    Shashank Bhide 932 on at
    Re: Dataverse lookup column filter, could not find property named...

    paste the monitor query in a browser and see if it's returning records.

     

    https://xxxxxx.xxxx.dynamics.com/api/data/v9.0/irs_switchboardinspectionfaults?%24filter=irs_Inspection__c%2Firs_work_order_line_item__c+eq+%271WL2w000001lLSXGA2%27&%24expand=irs_Switchboard_Panel__c%28%24expand%3Dirs_Switchboard__c%29%2Cirs_Switchboard_Inspection__c%28%24expand%3Dirs_Inspection__c%29&%24count=true

     

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,495

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,822

Leaderboard

Featured topics