2 formulas into 1 formula

[WesleyvdBlom]

Hello PowerApps-community, 

I want to combine 2 formulas, which work 'standalone'. Question is how to integrate or combine both formulas into one that works? The gallery is connected to data from the Common Data Service. Please help. I greatly appreciate your support! 

Formula 1: 

SortByColumns(Search('VHR Leveranciers'; TextSearchBox3_1.Text; "Naamleverancier";"GeografischeFocus";"SolutionType";"Validatiestatus"); "Naamleverancier"; If(SortDescending1; Descending; Ascending))

Formula 2: 

Filter('VHR Leveranciers'; Validatiestatus <> "Inactief")

Kind regards, 

Wesley van der Blom

VroomHR

Netherlands

[Yahya · Accepted solution]

Hi @WesleyvdBlom,

I put Filter inside the Search, so try this it works for me

SortByColumns(Search(Filter('VHR Leveranciers'; Validatiestatus <> "Inactief"); TextSearchBox3_1.Text; "Naamleverancier";"GeografischeFocus";"SolutionType";"Validatiestatus"); "Naamleverancier"; If(SortDescending1; Descending; Ascending))

[WesleyvdBlom]

Hi @Yahya,

Thanks it works great. I've been puzzeling, so thanks for your support. 

Tip: copy / paste does not work (PowerApp bug), but typing in PowerApps works.

Kind regards,

Wesley