cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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))

 

View solution in original post

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

 

View solution in original post

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

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Users Online
Currently online: 105 members 5,379 guests
Please welcome our newest community members: