web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Combining filter and s...

Power Apps

Unanswered

Combining filter and search in one statement

(0) Share

Report

Report

Posted on by Esben

2

Hi

I have just started making my first app in PowerApps. And I am also new to the programming language

When I am building my app from Sharepoint the default code for the Gallery in the my Browsscreeen is this:

SortByColumns(Filter([@'CBS1 Samples']; StartsWith('Sample Name (GHOST)'; TextSearchBox1.Text)); "ID"; If(SortDescending1; Descending; Ascending))

I want to both filter and search, but right now I can only get the Filter function to work.

How is oit possible to both filter for the column: "ID" and search in the different "ID" numbers?

I have search on the topic and tried different approaches, but without luck.

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

v-yutliu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Esben ,

Do you want to filter based on two conditions?

If so, you just need to use ";" connect with two conditions.

For example, Filter(table;condition1;condition2)

What do you mean "both filter for the column: "ID" and search in the different "ID" numbers"?

Actually ,filter and search function is the same meaning, just use different syntax.

Could you describe more clearly about what do you want to filter based on?

Based on your formula, maybe you want this:

SortByColumns(Filter([@'CBS1 Samples']; StartsWith('Sample Name (GHOST)'; TextSearchBox1.Text);TextSearchBox1.Text in ID); "ID"; If(SortDescending1; Descending; Ascending))

Here's a doc about this function for your reference:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-filter-lookup

Best regards,
Esben 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Phoebe Liu,

Thank you for your response 🙂

I am sorry that I am not more clear in my request. I have attached a picture of the browsescreen, which is the default screen when I make the powerapp through sharepoint.

What I want is:
- When I push the filter button I filter the list for the ID numbers (2,3,4 etc. in the picture)
- When I use the search function I can write a specific ID number and it returns this row in the table. It could also be 'nice to have' if I could do the same for the "sample name" (MB19-test, MB19-20, etc. in the picture)

I hope this specifies it more clearly?

Join the conversation