Forum Discussion

HennSarv's avatar
HennSarv
Helper I
6 years ago
Solved

Optional options as nullable record

Hi PowerQuery people,   Could You give me ANY hint where to find some reference for options? Several functions have subject like parameter - for example Folder.Files Only I find from docs or sear...
Need Help
  • mahoneypat's avatar
    mahoneypat
    6 years ago

    You can get a little more info by using #shared as your source in a blank query.  Convert that to a table and then filter to and click on the function of interest.  In the case of Folder.Files(), the optional parameter is "PreserveLastAccessTimes" and accepts true or false.

     

    Here is the query I used to get to this function, if you want to see for yourself.

     

    let
    Source = #shared,
    #"Converted to Table" = Record.ToTable(Source),
    #"Filtered Rows" = Table.SelectRows(#"Converted to Table", each ([Name] = "Folder.Contents" or [Name] = "Folder.Files")),
    Value = #"Filtered Rows"{1}[Value]
    in
    Value

     

     

    Regards,

    Pat

     

mahoneypat's avatar
mahoneypat
Microsoft Employee
6 years ago

You can get a little more info by using #shared as your source in a blank query.  Convert that to a table and then filter to and click on the function of interest.  In the case of Folder.Files(), the optional parameter is "PreserveLastAccessTimes" and accepts true or false.

 

Here is the query I used to get to this function, if you want to see for yourself.

 

let
Source = #shared,
#"Converted to Table" = Record.ToTable(Source),
#"Filtered Rows" = Table.SelectRows(#"Converted to Table", each ([Name] = "Folder.Contents" or [Name] = "Folder.Files")),
Value = #"Filtered Rows"{1}[Value]
in
Value

 

 

Regards,

Pat

 

  • HennSarv's avatar
    HennSarv
    Helper I
    6 years ago

    Thanksa lot for help

     

    this #shared thing I never reached. Somewhere documented? Something more hidden : )

     

    Henn