Forum Discussion
Choose columns from list
Hi Anonymous ,
Please make sure the type of the list is in text format in the Power Query Editor instead of Desktop model.
Or you can try the Number.ToText function to convert the type of the list to text.
= Table.RemoveColumns(#"Changed Type", List.Transform(pixellist, each Number.ToText(_)))If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community SupportHi Anonymous ,
Please make sure the type of the list is in text format in the Power Query Editor instead of Desktop model.
Or you can try the Number.ToText function to convert the type of the list to text.
= Table.RemoveColumns(#"Changed Type", List.Transform(pixellist, each Number.ToText(_)))
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I found the error. The list I had contained selections from another tab, not just the tab I was using for the example. So the data is broken across zones, zones 1-10 on a tab, 11-20 on a tab, etc etc. The list I was using had all the ones I needed across all the tabs. Once I adjusted the list to just have the values on the 1st tab, it worked like a dream. Thank you!