Forum Discussion

heathboroff's avatar
heathboroff
Copper Contributor
Mar 15, 2023

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...
PowerApps
SharePoint
  • ganeshsanap's avatar
    ganeshsanap
    Mar 16, 2023

    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

ganeshsanap's avatar
ganeshsanap
MVP
Mar 16, 2023

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

Resources