SOLVED

Cascading Drop Downs using result shows error

Copper Contributor

Why does this formula generate an error?  If I just do Distinct(InvoiceExpenseType,FundName) I will get a list of Values that are distinct but when trying to generate results I get this error.  Error message is The function Filter has some invalid arguments.  The same results occur for if I were to replace Filter with Sort.

heathboroff_0-1678909915367.png

 

2 Replies

@heathboroff Which authoring version of Power apps are you using in Power apps studio while editing application?

 

I read somewhere Microsoft recently made changes to few functions like Distinct.


Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs

best response confirmed by heathboroff (Copper Contributor)
Solution

@heathboroff In case you are using latest authoring version of Power Apps, try using Value instead of Result.

 

Example: 

 

Filter(
    Distinct(
        CityPopulations,
        Country
    ),
    Value
)

 


Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs

1 best response

Accepted Solutions
best response confirmed by heathboroff (Copper Contributor)
Solution

@heathboroff In case you are using latest authoring version of Power Apps, try using Value instead of Result.

 

Example: 

 

Filter(
    Distinct(
        CityPopulations,
        Country
    ),
    Value
)

 


Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs

View solution in original post