Can some help with the syntax to accomplish this task.
1. Compare two columns in a table one is fiscal year and the other is course title. If fiscal year is let say 2017 return the distinct a list of distinct course titles for that year.
The result should look like this
Subject(s) : ENG, JRN, SPE,
Have you seen this? https://powerapps.microsoft.com/en-us/tutorials/function-filter-lookup/
Yes, we could use the following formula to filter the table as you described:
Distinct returns a one-column table that contains the results, with duplicate values removed.
Distinct function in PowerApps
Check it out!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020