cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
WesleyvdBlom
Level: Powered On

2 formulas into 1 formula

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

 

1 ACCEPTED SOLUTION

Accepted Solutions
Yahya
Level 10

Re: 2 formulas into 1 formula

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))

 

2 REPLIES 2
Yahya
Level 10

Re: 2 formulas into 1 formula

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))

 

Highlighted
WesleyvdBlom
Level: Powered On

Re: 2 formulas into 1 formula

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