Forum Discussion

lardo5150's avatar
lardo5150
Microsoft Employee
6 years ago

Import filtered column from SharePoint list

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?
Need Help

3 Replies

  • ChrisMendoza's avatar
    ChrisMendoza
    Resident Rockstar
    6 years ago

    lardo5150 -

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

  • v-lid-msft's avatar
    v-lid-msft
    Community Support
    6 years ago

    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,

  • v-lid-msft's avatar
    v-lid-msft
    Community Support
    6 years ago

    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,