Merge 2 formulas

[Gazbeer]

Hi All,

I have 2 formulas that work for my gallery individually, however i would like them both to work together, could anyone rewrite the formula so the both work as one please? if you could explain how to do it would be amazing.

This one is for my filter :

Filter('RFFS Station Manager Event Log', StartsWith('Brief Description', FilterTextBox_1.Text))

and this one is for for sort button:

"(Sort('RFFS Station Manager Event Log', Created, If(vSorted2, Ascending, Descending)))"

Thank you

[mdevaney · Accepted solution]

@Gazbeer
Here you go.

Sort(Filter('RFFS Station Manager Event Log', StartsWith('Brief Description', FilterTextBox_1.Text)), Created, If(vSorted2, Ascending, Descending))

—-
Please Accept as Solution if this post answered your question so others may find it more quickly. If you found this post helpful consider giving it a Thumbs Up.

[timl · Accepted solution]

Hi @Gazbeer 

Something like this should work for you.

Sort(Filter('RFFS Station Manager Event Log', 
             StartsWith('Brief Description', FilterTextBox_1.Text)
     ), 
     Created, 
     If(vSorted2, Ascending, Descending)
)

The first argument that you provide to the Sort function specifies the data source to sort. At the moment, this is set to 'RFFS Station Manager Event Log'. You can replace this data source with a call to the Filter function. This will result in a formula that both sorts and filters your source data.

Hope that's of some help.

[Gazbeer]

he strikes again!

😘