0

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

Cyril Cereaic Joseph
  • 268
  • 5
  • 14

1 Answers1

1

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

dspn
  • 314
  • 2
  • 9
  • Distinct(Energy_Facilities,City) this is the first formula & Filter(Energy_Facilities, Country = DataCardValue8.Selected.Result) this is the second – Cyril Cereaic Joseph Sep 18 '20 at 09:10
  • simply nesting them like the example should do the trick: Distinct(Filter(Energy_Facilities, Country = DataCardValue8.Selected.Result), City) – dspn Sep 18 '20 at 09:20
  • will need more details. where are you trying to use that function? on a second dropdown? what error are you getting? – dspn Sep 18 '20 at 10:00
  • That worked for me. it was my small mistake. Thanks a lot sir – Cyril Cereaic Joseph Sep 18 '20 at 10:34