From Power Apps, we can build a search feature by adding search text box, and a gallery control with the Items property set to the following formula:
Search(vwSearchIssue, txtSearchInput.Text, "IssueResponseDesc")
To display these distinct values in a gallery control, we would call the GroupBy function to group the result by IssueID. We would set the Items property of our gallery control to this same formula.
GroupBy(Search(vwSearchIssue, txtSearchInput.Text, "IssueResponseDesc"),
"IssueID",
"Data"
)
This effectively produces a result that looks like this.
Each record in this result includes an IssueID field and a child table called 'Data' that contains all the rows that match the corresponding issue ID.
From the item template of the gallery, we can show the distinct 'Issue Description', and 'Target Close Datetime' fields by looking up the first row in the data child table. The syntax to return the IssueDescription would look like this:
First(ThisItem.Data).IssueDescription
Likewise, this would return the 'Target Close Datetime' field.
First(ThisItem.Data).TargetCloseDateTime
As the screenshot beneath shows, we can use this technique to configure our gallery control to show just the distinct IssueID, 'Issue Description', and 'Target Close Datetime' fields that relate to the search.
