Hi all,
I am admittedly very new to Power Apps, so I apologize if the answer is fairly straightforward and I've missed it.
I have a dataset with a search function for the "ID Number". I'm trying to filter it to the most recent entry via a variable called "Run Number". I want my gallery to only show only the IDs with the the highest run number and my search function to also be based off this filtered data. Here is a visualization to make it more clear.
The complete table:
The data that I want to pull:
What I want the gallery to visually show and search from;
The function I have currently is
Search('Example', textInput.Text, "ID Number")
and it's obviously showing every row like in image 1 but I want it to look like image 3 and for that table to be the one that is searchable.
Any help is appreciated, thanks!