Forum Discussion
Microsoft Exchange - Expand column
Hi Whoule ,
Before expanding the list columns, make sure that only the necessary columns and rows are imported. Use Power Query to filter the dataset to what you actually need for your analysis. You can select Transform Data when connecting to your mailbox and use the Choose Columns feature to limit the data to only those columns you need.
When expanding the list column, try to do this after you have filtered the data to reduce the volume of data that needs to be processed. Consider writing a custom M query to expand only the necessary elements of the list column, which can be more efficient than using the automatic expand feature.
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous Hi, so basically, I am using that list column to filter out all emails with a completed tag on them but in order to filter these out I need to expand that column to get its value. Would you happen to have a good link to share on custom M query for specific expend values?