I am facing a issue to bind the lookup column in the collection. In collection, It is giving me an error "The data is unsupported for..."
Is there any way to get the data of lookup column into collection?
Can you show a screenshot of the formula you are using to set the collection?
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.
I am having same issue when using CDS and i did following code:
ClearCollect(CollectionA,Filter('ABC','ABC (Views)'.'AbcView',TypeId < 2000)),
ClearCollect(CollectionB,Filter('ABC','ABC (Views)'.'AbcView',TypeId >= 2000 And TypeId < 4000)),
ClearCollect(CollectionC,Filter('ABC','ABC (Views)'.'AbcView',TypeId >= 4000 And TypeId < 6000))
I am getting data for all columns except LOOKUP columns.
I am getting error for LOOKUP columns which is "This datatype is unsupported for evaluation"
Thanks for clarifying. The filter then seems wrong on TypeId lookup column/field. You'll need to select (with intellisense) the amount column from the lookup to filter on the desired amount. Ex:
ClearCollect(CollectionA, Filter('ABC', 'ABC (Views)'.'AbcView', TypeId.AmountColumn < 2000))
Check out new user group experience and if you are a leader please create your group
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.