powerappspowerapps-formulapowerapps-canvaspowerapps-collectionpowerapps-modeldriven

How can i combine two formulas in formula bar in powerapps?

I need to apply two formulas on a dropdown field. How to apply both the formulas?I want to use the distinct funciton to avoid the duplicate values & the dropdown values depend on another column values. I have the formulas in hand but dont know how to apply both

Solution

  • you can just chain them like in most other languages fn1(fn2(x)). Not knowing the second function i'll just assume it to be filter:

    Distinct(Filter(MyTableVariable, MyFilterColumn = "MyFilterCriteria"), MyReturnValuesColumn)

    an additional note: this code goes into the Items property of the dropdown