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 |
---|---|
168 | |
94 | |
64 | |
64 | |
60 |
User | Count |
---|---|
240 | |
163 | |
95 | |
85 | |
82 |