Hi @WarrenBelz,
Whoops, sorry!
Currently, the user is being presented with a sorted, distinct-ized gallery. When they click an item in the gallery, it loads that info to a data table.
I basically want to add a text_input box that will filter the gallery by employee name.
Your code does work! Thank you 😊
But now that I see it working, I have a new question...
Is there a way to display sorted and distinct results in the gallery before a user sends an input? Currently, the gallery is blank until you type the majority of a name... I was hoping to just have the list displayed in alphabetical order, updating once you type in the textbox
^ Oops, fixed this. Had some sneaky text in the input_box ^
Which brings me to one last inquiry... It seems I need to type the entire employee name for the filter function to work. For that reason, I think I would be better off with a search function, or startswith, rather than filter. Do you know how I could combine one of those functions with sort and distinct? I tried dropping them in place of the filter function, but of course that isn't good enough for PowerApps 🙃
^ Fixed as well
Sort(
Distinct(
Filter(
'Safety Training', StartsWith('Employee Name', TextInput1.Text)
),
'Employee Name'
),
Result
)
Thanks again @WarrenBelz!
