Text input to search a gallery?

[MaxWendorff]

Hi, I have a screen in my app that groups certain data into a gallery. The data comes from a sharepoint list. Essentially there is a Work Order Number that has a location and a part number for someone to scan. Each work order has 3-7 different locations and part numbers which is why I grouped them into a gallery called "WorkOrderGallery" 

Everything Works except there are 300 different work orders and I need to be able to search the gallery based on the work order number. I can not get it to work with the current GroupBy code which is:

GroupBy(WorkOrder,"BASE_ID","WorkOrderDetail")

Is there a way I can nest a search function in here and set it to a text box?? Below are pictures of how the gallery looks and how it looks in tree format. Any help would be appreciated!

[RandyHayes]

@MaxWendorff 

Do you have a specific text input control for searching?  If not, you'll want to have something where you can enter the WorkOrder number - let's call it TextWorkOrder for now.

If that is the case, then you can modify your formula to the following:

GroupBy(Filter(WorkOrder, StartsWith(WorkOrderNumber, TextWorkOrder.Text),"BASE_ID","WorkOrderDetail")

This will filter the Gallery based on the work order number you enter in the text box.

I hope this is helpful for you.

[MaxWendorff]

Thank you so much for your response!

I plugged that in and it all makes sesne but I get this error here:

..StartsWith(WorkOrderNumber, TextWorkOrder.Text)

It says its looking for a text value not a control. The value that it is referenceing is a label that is set to the Work Order Numbers so I am unsure as to why it is not working. Any Ideas?

[RandyHayes]

@MaxWendorff 

Yes, that was a "generic" name.  You didn't mention the names of your columns in SharePoint, so I went with the logical name.

Replace that WorkOrderNumber with whatever the column name is in your list.

[MaxWendorff]

I replaced it and I received no error messege! However, when I load up the screen the gallery loads as usual but when I type in the search box, all the data goes away. When I delete what I put in the search box, the gallery loads in as normal. Any idea?

[RandyHayes]

@MaxWendorff 

What are you typing into your text box?  From your Photo, it should be something like "WO-09563"

This formula uses the StartsWith to find information that starts with the information in the textbox.  It is not a search function, so make sure you are putting in the correct accurate work order number.

[MaxWendorff]

Yes I am making sure the data is accurate, could it be an issue with my sub gallery? It also holds labels with information from sharepoint collums. Otherwise could it be the size of the gallery as there are about 300 different work orders loading in?

[RandyHayes · Accepted solution]

@MaxWendorff 

No, none of those should be a factor in this.

I assume that this formula is the Items property formula for the WorkOrderGallery control.

I'm going to surmise that the work order number is in a Column called BASE_ID in your SharePoint list.

To summarize:

You have a Text Input control on your screen called TextWorkOrder

Your SubGallery items property should be set to : ThisItem.WorkOrderDetail

Your WorkOrderGallery items property should be set to: GroupBy(Filter(WorkOrder, StartsWith(BASE_ID, TextWorkOrder.Text)), "BASE_ID", "WorkOrderDetail") (by the way...sorry I had a missing parenthesis in my original formula)

Let me know if the above is all true and if not and you correct it, if you are seeing the results you want.

[MaxWendorff]

NEVERMIND! I accidently had "" around the collumn name lol! Thank you so much! I appreciate all the help I could not have got it without it! Cheers