Answered

Why doesn't this expression work?

(0) Share

Report

Posted on by rmeany

I'm trying to create a collection that contains a list of inventory models belonging to a certain item type when a user selects the item type from a dropdown. This query returns a zero-sized collection every time though, even though there are definitely items of the type I selected from the dropdown..

ClearCollect(
 ModelTypesFilter,
 Filter(
 'Inventory Item Models',
 'Inventory Item Type'.'Type Name' = drpItemType.Selected.'Type Name'
 )
)

Categories:

Building Power Apps

All responses (9)

Answers (1)

Sort by

mdevaney 29,993 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@rmeany
At least one of the Filter criteria must reference the datasource being filtered 'Inventory Item Models'. Nothing will show if you try to Filter a datasource according to 'Inventory Item Type'

ClearCollect( ModelTypesFilter, Filter( 'Inventory Item Models', 'Inventory Item Type'.'Type Name' = drpItemType.Selected.'Type Name' ) )

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
rmeany 35 on at

Like
a
(0)

Report
Copy link

Link copied!
Ahh, I thought that the filtered table would be implied in the filter expression if not specified, but I also tried the following and it still does not work:

ClearCollect( ModelTypesFilter, Filter( 'Inventory Item Models', 'Inventory Item Models'.'Inventory Item Type'.'Type Name' = drpItemType.Selected.'Type Name' ) )
mdevaney 29,993 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@rmeany
I am little bit confused now. I thought 'Inventory Item Type' was a datasource name but now it seems to be a column. What column type is 'Inventory Item Type'?
rmeany 35 on at

Like
a
(0)

Report
Copy link

Link copied!

'Inventory Item Type' is a foreign key reference to the 'Inventory Item Types' table..

An item model (example: HP EliteDesk 800) has a type (example: desktop computer) ... Desktop computer can belong to many different models.
mdevaney 29,993 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@rmeany
So is it a Sharepoint LookUp column?
rmeany 35 on at

Like
a
(0)

Report
Copy link

Link copied!

No, it's accessing common data services entities.
mdevaney 29,993 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@rmeany
Sorry, I am not yet familiar with Common Data Service.
rmeany 35 on at

Like
a
(0)

Report
Copy link

Link copied!

When I try to reference the parent table in the collection, the data type of foreign key column is actually a record itself.. I'm guessing it's supposed to be returning the actual record in the parent table... But referencing it this way seems to be returning a blank record for some reason...

First('Inventory Item Models').'Inventory Item Type' = blank even though I know every model in my database has a type associated with it...
Verified answer

rmeany 35 on at

Like
a
(0)

Report
Copy link

Link copied!

I'm giving up on CDS for now.. Just doesn't seem fully implemented yet to me..