Import filtered column from SharePoint list

[lardo5150]

I currently am using a SharePoint list.
I have the columns filtered out.
I just realized I need to bring in another column that has data I need.
How do I unfilter the column I need?

[v-lid-msft]

Hi @lardo5150 ,

How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?

Best regards,

[v-lid-msft]

Hi @lardo5150 ,

If you have removed some column ( For example Column B and Column C) before applied some other steps:

Then We can go to the Removed Columns step in Applied Steps Panel, then remove "Column B“, from the query of this step:

All the queries are here: 

Origin Table:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUTIBYnOlWJ1oJSMgyxSILcA8YyDLDIgtlWJjAQ==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [#"Column A" = _t, #"Column B" = _t, #"Column C" = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column A", Int64.Type}, {"Column B", Int64.Type}, {"Column C", Int64.Type}}),
    #"Removed Columns" = Table.RemoveColumns(#"Changed Type",{"Column B", "Column C"}),
    #"Added Index" = Table.AddIndexColumn(#"Removed Columns", "Index", 1, 1)
in
    #"Added Index"

Restore Column B:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUTIBYnOlWJ1oJSMgyxSILcA8YyDLDIgtlWJjAQ==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [#"Column A" = _t, #"Column B" = _t, #"Column C" = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column A", Int64.Type}, {"Column B", Int64.Type}, {"Column C", Int64.Type}}),
    #"Removed Columns" = Table.RemoveColumns(#"Changed Type",{ "Column C"}),
    #"Added Index" = Table.AddIndexColumn(#"Removed Columns", "Index", 1, 1)
in
    #"Added Index"

Best regards,

[ChrisMendoza]

@lardo5150 -

You should be able to retrieve the removed column in the Query Editor. Go to the Step where it was removed.