How do I get a single value from a function?

Hi Netrelemo ,

You can try this code for function:

let getPHRdataFromSite = (projectSiteURL as text) =>
    let
        Source = SharePoint.Tables(projectSiteURL, [Implementation=null, ApiVersion=15]),
        PHRFolder = Source{[Title="ReportArchive"]}[Items],
        #"Removed Other Columns" = Table.SelectColumns(#"PHRFolder",{ "Report Date"}),
        #"Kept Last Rows" = Table.LastN(#"Removed Other Columns", 1)

    in
        #"Kept Last Rows"
in
getPHRdataFromSite

And the table query:

let

    Source = OData.Feed("https://xxxxxxxxx.sharepoint.com/sites/edison/_api/ProjectData", null, [Implementation="2.0"]),
    Projects_table = Source{[Name="Projects",Signature="table"]}[Data],

    #"Removed Other Columns" = Table.SelectColumns(Projects_table,{"ProjectId", "ProjectIdentifier", "ProjectLastPublishedDate", "ProjectModifiedDate", "ProjectName", "ProjectWorkspaceInternalUrl"}),
    #"Changed Type" = Table.TransformColumnTypes(#"Removed Other Columns",{{"ProjectIdentifier", Int64.Type}}),
    #"Filtered Rows" = Table.SelectRows(#"Changed Type", each ([ProjectIdentifier] <> null)),
    #"Sorted Rows" = Table.Sort(#"Filtered Rows",{{"ProjectName", Order.Ascending}}),

    #"Added Custom" = Table.AddColumn(#"Sorted Rows", "getPHRdataFromSite", each function([ProjectWorkspaceInternalUrl])),
    #"Expanded Custom" = Table.ExpandTableColumn(#"Added Custom", "getPHRdataFromSite", {"Report Date"}, {"getPHRdataFromSite.Report Date"})

in
    #"Expanded Custom"

 Add invoked column and expand them.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.