Forum Discussion

edhans's avatar
edhans
Community Champion
7 years ago

Has anyone been able to reliably use Table.ColumnsofType() in Power Query?

I get random success/failures with this function. I have a table called Sales with several columns - number, text, Int64.Type, etc.   The following in a new query returns nothing in the list. No er...
Need Help
hansei's avatar
hansei
Helper V
6 years ago

For anyone else who may have hit this page, see this blog for insight. The solutions is to expand type list as such

 

Table.ColumnsOfType(Patients1, {type nullable text})

 

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Lars Schreiber's investigation, solution and explanation from blog link above worked for me!

hansei wrote:

For anyone else who may have hit this page, see this blog for insight. The solutions is to expand type list as such

 

 

Table.ColumnsOfType(Patients1, {type nullable text})

 

 

Thanks LarsSchreiber