Hi there!
I have a list with several column.
I want a function that does the same as teh LookUp function but instead of returning one value only, i want it to return a list of values that fulfills the condition, from a given column of the source.
Hope there is someone who know a workaround or better yet know a function that does just that.
Cheers
- Anthon
Solved! Go to Solution.
Hello @Anonymous,
I believe "Filter" is the function you're looking for. It has a similar format as "LookUp". Please see this page: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-filter-lookup
Thank you for the reply.
But this is not what i am looking for.
Filter does not have an option to only return data from one column of a list. Which LookUp does.
- Anthon
Filter(myDataSource, ID=myConditionID).myColumn
User | Count |
---|---|
153 | |
93 | |
83 | |
77 | |
58 |
User | Count |
---|---|
194 | |
176 | |
104 | |
96 | |
89 |