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
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
User | Count |
---|---|
208 | |
97 | |
60 | |
51 | |
51 |
User | Count |
---|---|
255 | |
158 | |
87 | |
79 | |
59 |