Forum Discussion
Solved
(Dataverse) Selective Power query?
Hi, I am new to using Dataverse and power query. I am currently use two excel files - one for material data source and other for partlist. So far, no trouble, but with growing number of mate...
You may filter on partlist
as
let Result = Table.SelectRows(Source, each List.Contains( Partlist[ID], [ID] )) in Result
You may filter on partlist
as
let
Result = Table.SelectRows(Source, each List.Contains( Partlist[ID], [ID] ))
in
Result- Thank you Sergei,
If I may ask, where do I insert the above code?In Power Query editor you may open Advanced Editor to modify M-script code, or for the concrete step you may modify the code in formula bar of the PQ editor.
Thank you SergeiBaklan ,
It is working as well 🙂
For the table name for Partlist, can it be dynamic?
As of right now, we are using the partlist excel file as teams template file that can be used by other users.
And table name tends to get messy.
