Forum Discussion
Cascading Drop Downs using result shows error
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 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
2 Replies
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
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