Unanswered

Search and Filters Using SharePoint Lists

(0) Share

Report

Posted on by mperez4

Hi everyone,

This may be a simple question, but this is my first week using Power Apps and have tried many solutions to fix my problem but unfortunately nothing has worked for me so far.

Im currently making an inventory list of tools being kept on site, and currently have around 1500 items on the list. I have created a search bar that allows me to search throughout my list which looks like this:

Which works great for just searching for the items that i am looking for

What I'm currently trying to do is add the ability to filter the list initially using the controls i have added, and then based on those filters, use the search function to search for an specific item within that already filtered list.

here is what my layout currently looks like:

I have the

dropdown1 Items = Choices('Methods Tooling Inventory'. 'Tool Type')

DropDown2 Items= Choices('Methods Tooling Inventory'. Manufacturer)

DropDown3 Items = Choices('Methods Tooling Inventory'. 'Storage Location')

Additionally, I want to be able to use the scan function to be able to scan a barcode of each individual tool and be able to search through search bar for that specific tool. Im not sure if this is possible to do additional to the search bars and the filter.

I really appreciate any help I can get and thanks so much in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Ben_Hoople 81 on at

Like (0)

Report
Copy link

Link copied!
Hi,

I would use the filter function here,

its easier to maintain and add more functionality to.

the pseudo code for this would look something like:
Filter("Methods Tooling Inventory", textBox.Name in Name, If(IsEmpty(dropdown1.Selected),true,'Tool Type' = dropdown1.selected), If(IsEmpty(dropdown2.Selected),true,Manufacturer = dropdown2.selected), If(IsEmpty(dropdown3.Selected),true,'Storage Location' = dropdown3.selected) )

it works by first checking the name,
then the next checks are all similar.
if they haven't chosen something, return true (dont filter anything)
else return if the item matches the selection (with the appropriate fields).

Hopefully that makes sense.

If you want to add a barcode scanner, thats fine, you need another input box, on selecting the input (or by button) set the value of the box equal to the input. you can do a filter function or a First function to get the item:

Filter('methods tooling inventory', If(textBoxBarcode.Text <> Blank, textBoxBarcode.Text = BarcodeField, true) )

I hope this helps

Was this reply helpful? Yes No
mperez4 4 on at

Like (0)

Report
Copy link

Link copied!

@Ben_Hoople Thanks so much thats really helpful. Im just wondering how i should put the function? Do i put it after the current formula that i have?
SortByColumns(Search('Methods Tooling Inventory',TextSearchBox1.Text,"Title"), "Title",If(SortDescending1,Descending,Ascending))

or does it completely replace this formula?

Im sorry, I'm still struggling on how to set up and understand the formulas

Was this reply helpful? Yes No
Ben_Hoople 81 on at

Like (0)

Report
Copy link

Link copied!

sorry for the later reply, yesterday got busy.

It doesn't replace your whole function, just the function that returns your table. in this case it would replace your search() function.

Remember that you can always press Shift+Enter in the top formula bar to format your function properly for easier reading, alternatively there is the prettify button at the bottom of the menu

Was this reply helpful? Yes No
mperez4 4 on at

Like (0)

Report
Copy link

Link copied!

@Ben_Hoople thanks that seemed to help! Now my only issue is that the screen is returning as a blank screen. Im not sure if there was something in the formula that i might of misspelled or used the wrong thing?

SortByColumns(Filter('Methods Tooling Inventory', TextSearchBox1.Name in Name, If(IsEmpty(Dropdown1.Selected),true,'Tool Type' = Dropdown1.Selected),
If(IsEmpty(Dropdown2.Selected),true,'Manufacturer' = Dropdown2.Selected),
If(IsEmpty(Dropdown3.Selected),true,'Storage Location' = Dropdown3.Selected)
), "Title",If(SortDescending1,Descending,Ascending))

Was this reply helpful? Yes No