Unanswered

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

(1) Share

Report

Posted on by lacmac

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:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Shashank Bhide 946 Moderator on at

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
lacmac 8 on at

Like (0)

Report
Copy link

Link copied!

No luck, it returns with the same error.

Was this reply helpful? Yes No
Shashank Bhide 946 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
lacmac 8 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Flec_t 3 on at

Like (0)

Report
Copy link

Link copied!
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 ?

Was this reply helpful? Yes No