Hi there, I am pretty new to Powerapps so please be gentle with me 😊
I need some advice and guidance on how to check for two values, but only one when the Job Number is not blank.
Scenario:
I have a SharePoint list called Assembly Master.
I want to display ALL Assembly Jobs and put them all into 5 different galleries depending on the QC Status. A bit like McDonalds when you order, you see the screen that shows where your order is, Ordered, Preparing & Ready.
Against each record is a QC Status. There are 5, Not Started, WIP, Pass, Fail & End of Day
I want to display 5 different galleries, displaying all the jobs that are in WIP or Pass etc
I think I have this working all ok with this code for each gallery, using a different QC Status for each:
Filter(
‘Assembly Master’,
'QC Status'.Value = "Not Started"
)
Now what I need is to add the ability to display a list of Job Numbers down the left had side and to select one and the galleries only display the selected Job Number.
As you can see, I have the search field, “txtMainSearch” there and the gallery “grdJobNumber”
So, if I enter the Job Number 090470-4-4, the galleries will only display the 090470-4-4 jobs and status.
My search text field is called txtMainSearch.
My Jobs Gallery, looks at the same SharePoint list with the following code.
Filter('Assembly Master', StartsWith('Job Number',txtMainSearch.Value))
Any help & advice would be greatly appreciated!
Cheers
