141
My backing Sharepoint list has multiple occurrences of StudentId so when I use the list from a PowerApps gallery, I get all the occurences, leading to dupliace entries for the multiple StudentId, as expected. Is there a way to use Distinct without knowing the StudentId to make the gallery only show the first occurrence of each StudentId?
e.g, in SQL it would be along the lines of SELECT DISTINCT StudentId. Is there an equivalent for PowerApps?
thanks,
Alistair
Turns out it was fairly easy. In the Items for the list:
Share
Report
All responses (
Answers (
If (IsBlank(TextSearchBox1.Text), Distinct('The List', StudentId), Distinct(Filter('The List', TextSearchBox1.Text in Text(StudentId)), StudentId))then in the list tem Text I initially had:
ThisItem.StudentId
but that no longer works as Distinct returns a Table so the final part of the solution is to set the list item Text to:
Result
The above now displays only a single instance of a StudentId when there are multiple entries in the Sharepoint list.
