Answered

Using Search, Filter and SortByColumns

(0) Share

Report

Posted on by XDUKERMANX

I admit defeat! I've spent about 7 hours (no exaggeration) trying to solve this myself by using various sources online and I just can't.

I'm creating a computer asset management "system" in Power Apps and all the asset data is held in a SharePoint list with various column formatting.

I've got my gallery setup but I'm now trying to create a search bar. I want to use all 3 of the formulas below:

SortByColumns(Assets_Computer,"Computer_x0020_Name")

Search(Assets_Computer,SearchBox.Text,"Computer_x0020_Name","Title","ServiceTag")

Filter( Assets_Computer, StartsWith(Model.Value,SearchBox.Text)||StartsWith('Assigned to'.DisplayName,SearchBox.Text))

By process of elimination I know all of these formulas work individually but I'm unable to get them all to work together, I have tried every conceivable combination so I'm obviously missing something (I'm still relatively new to Power Apps)

I'm not sure if I'm using the correct functions for each and think other issue's will arise but I will try to provide as much info as I can:

Computer_x0020_Name, Title and ServiceTag are single line text I believe.

Model is being pulled in to Assets_Computer from another SharePoint List (I didn't set this up so not sure why)

Assigned to is a person column.

I'm not sure if it should be filtered or searched first as the model is going to have a lot more of the same entries where as title and service tag are all going to be unique along with persons for the most part.

Thanks in advance and hopefully I make sense.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

WarrenBelz 155,983 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @XDUKERMANX ,

Have you tried this?

SortByColumns( Search( Filter( Assets_Computer, StartsWith( Model.Value, SearchBox.Text )|| StartsWith( 'Assigned to'.DisplayName, SearchBox.Text ) ), SearchBox.Text, "Computer_x0020_Name", "Title", "ServiceTag" ), "Computer_x0020_Name" )

This should also work

SortByColumns( Filter( Assets_Computer, StartsWith( Model.Value, SearchBox.Text )|| StartsWith( 'Assigned to'.DisplayName, SearchBox.Text ) || SearchBox.Text in 'Computer Name' || SearchBox.Text in Title || SearchBox.Text in ServiceTag ), "Computer_x0020_Name" )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
XDUKERMANX 25 on at

Like
a
(0)

Report
Copy link

Link copied!

Neither seem to be working.

It is returning results when searching for 'Assigned to' and 'Model but 'Computer Name', 'Title' and 'ServiceTag' don't appear to be returning any results.

Was this reply helpful? Yes No
WarrenBelz 155,983 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@XDUKERMANX ,

Not sure why the first one does not work - the syntax is correct - corrected second one (dangers of free-typing).

If it does not work now on the second one, you need to look at your data.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
XDUKERMANX 25 on at

Like
a
(0)

Report
Copy link

Link copied!

The second one works. It now returns results from searching from all fields.

Thanks dude.

Was this reply helpful? Yes No