How to add multiple filters and conditions on a gallery items property - powerapps

%3CLINGO-SUB%20id%3D%22lingo-sub-1876188%22%20slang%3D%22en-US%22%3EHow%20to%20add%20multiple%20filters%20and%20conditions%20on%20a%20gallery%20items%20property%20-%20powerapps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1876188%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%3CBR%20%2F%3EI'm%20quite%20new%20with%20powerapps%20and%20i'm%20having%20it%20difficult%20regarding%20how%20i%20can%3C%2FP%3E%3CP%3E-%20Have%20multiple%20filters%20e.g%20on%20a%20gallery%20(items%20property)%3C%2FP%3E%3CP%3E-%20Have%20multiple%20if%20statements%3F%3CBR%20%2F%3ESometimes%20I%20see%20semicolon%20being%20used%20sometimes%20comma%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%20in%20one%20of%20the%20scenario%20i'm%20strugging%20with%20is%3A%3CBR%20%2F%3EI%20have%20a%20gallery%20i%20inserted%20showing%20data%20from%20a%20sharepoint%20list%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3EAs%20you%20can%20see%20below%20the%20search%20items%20textbox%20works%20ok%20but%20as%20highlighted%20i%20also%20have%20a%20dropdownlist%3C%2FP%3E%3CP%3E(showing%20Test)%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Capture.PNG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F232909iC34EA97B8C5DA211%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Capture.PNG%22%20alt%3D%22Capture.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3EWhat%20i%20want%20to%20be%20able%20to%20do%3A-%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EIs%20to%20be%20able%20to%20filter%20the%20gallery%20using%20the%20dropdown%20list.%3C%2FP%3E%3CP%3EHow%20do%20i%20combine%20this%20two%20below%20together%20in%20the%20items%20property%20of%20the%20gallery%3CBR%20%2F%3E%3CBR%20%2F%3ESortByColumns(Filter(%5B%40ClientPowerApps%5D%2C%20StartsWith(Title%2C%20TextSearchBox1.Text))%2C%20%22Title%22%2C%20If(SortDescending1%2C%20Descending%2C%20Ascending)%3C%2FP%3E%3CP%3Eand%26nbsp%3B%3C%2FP%3E%3CP%3EFilter(ClientPowerApps%2C'Last%20Name'%20%3D%20Dropdown1.Selected.'Last%20Name')%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1876188%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Frequent Contributor

Hi All,
I'm quite new with powerapps and i'm having it difficult regarding how i can

- Have multiple filters e.g on a gallery (items property)

- Have multiple if statements?
Sometimes I see semicolon being used sometimes comma

 

For example in one of the scenario i'm strugging with is:
I have a gallery i inserted showing data from a sharepoint list

 

 

As you can see below the search items textbox works ok but as highlighted i also have a dropdownlist

(showing Test)

Capture.PNG

What i want to be able to do:-

Is to be able to filter the gallery using the dropdown list.

How do i combine this two below together in the items property of the gallery

SortByColumns(Filter([@ClientPowerApps], StartsWith(Title, TextSearchBox1.Text)), "Title", If(SortDescending1, Descending, Ascending)

and 

Filter(ClientPowerApps,'Last Name' = Dropdown1.Selected.'Last Name')

 

Thanks

0 Replies