Filter/Search a combobox based on another combobox

[i_reminisce]

Hello all and happy Friday!

I feel like I'm missing something extremely basic here, but here goes.

In my app I have two comboboxes. The first combobox is hooked up to a sharepoint list column, using Choices('Document Test'.'Business Unit'). The second combobox is using a Dynamics 365 connector to a table named Projects, with the end goal of only pulling data from a column named 'Project Number'.

Here's what I want to happen. I want to be able to select an option in combobox1 (the business unit) and then Search and/or Filter combobox2 (Project numbers).

I'm going to throw a twist in here now. The project numbers are related to the business unit by the beginning number. If I select business unit 26, there will be 9-digit project numbers that begin with the business unit (26), but with an appending 20. So there could be 262000001-262000010 in the project number column for example.

I want that combobox2 to automatically filter/search the results based on the business unit picked, with a *hopeful* addition of adding the extra 20 to the end of my Selected.Value from combobox1.

Does this sound in anyway possible? I've tried using Filter, Search, IsMatch, and StartsWith with no success thus far. Any advice is appreciated!

[DavesTechTips]

Hi there, happy Saturday to you 

It sounds like there could be various things wrong. IT could be either in the way that the first comboxbox value is referenced in the filter formaly for the second combobox, or it might be with the actual filter formula, or with the way the data is displayed in the combobox.

Try and get the filer going with a gallery and hard coding the filter formula under items, to try and get the gallery to return data for one project number. 

Let me know if you don't come right and maybe send some screen shots of the formulas for us to have a look at.

twitter: dawidvh

youTube: https://www.youtube.com/channel/UCIMe_ErQZP5chbI9UyW0xLw

[i_reminisce]

I appreciate the reply Dawid!

I attached a filter on a gallery that pulls back a single project number, but the same formula doesn't work on a combobox (that I know of).

My situation is a bit more unique where I have to pick a business number (77 for example in combobox1), and have the results (in combobox2) all begin with 77 or preferably 772. I'm not quite sure how to get there and I've tried like I mentioned in my first post using Filter, StartsWith, and Search in various combinations to no avail. I'm hoping someone can shed some light on this for me, I'm not against using a collection. I've tried using a collection and haven't made any progress with it either. I'm sure I'm missing something basic, but I just can't figure it out!

[i_reminisce · Accepted solution]

Update

I couldn't get a working solution for this question of mine. I decided to just go with collecting some filtered data from the Dynamics 365 table and then having a gallery pull and filter data even more from that collection. It wasn't what I was looking for, but gets the job done.