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

984 Views Asked by At

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

1

There are 1 best solutions below

4
On BEST ANSWER

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