Forum Discussion

Oelshamy's avatar
Oelshamy
Helper I
4 years ago

Reterive SharePoint List Multiple appeneded Text in Power Bi

I have a MS List with multiple line of text column with "Append Changes to existing text" turned ON called Updates   I created a Power BI report to display information related to the list, I am tryi...
Need Help
Show and Tell
Oelshamy's avatar
Oelshamy
Helper I
4 years ago

I have found a workaround which is by creating a function: 

 

= () =>
let
Source = (VersionsRelevantSharePointListName as text, VersionsRelevantSharePointLocation as text, VersionsRelevantItemID as number) => let
Source = Xml.Tables(Web.Contents(Text.Combine({VersionsRelevantSharePointLocation,"/_api/web/Lists/getbytitle('",
VersionsRelevantSharePointListName ,
"')/items(",
Text.From(VersionsRelevantItemID),
")/versions"}
))),
entry = Source{0}[entry],
#"Removed Other Columns2" = Table.SelectColumns(entry,{"content"}),
#"Expanded content" = Table.ExpandTableColumn(#"Removed Other Columns2", "content", {"http://schemas.microsoft.com/ado/2007/08/dataservices/metadata"}, {"content"}),
#"Expanded content1" = Table.ExpandTableColumn(#"Expanded content", "content", {"properties"}, {"properties"}),
#"Expanded properties" = Table.ExpandTableColumn(#"Expanded content1", "properties", {"http://schemas.microsoft.com/ado/2007/08/dataservices"}, {"properties"})
in
#"Expanded properties"
in
Source

 

 

But it only reterieves 1 Item since the function requires 3 parameters, Any idea how to use the function with 2 parameters only and as well to invoke it automatically and have this is a query to be used in the visuals page? 

 

Thanks 

  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    Community Support
    4 years ago

    Hi Oelshamy ,

     

    {VersionsRelevantSharePointLocation,"/_api/web/Lists/getbytitle('",
    VersionsRelevantSharePointListName ,
    "')/items(",
    Text.From(VersionsRelevantItemID),
    ")/versions"}

     

    The purpose of this formula is to get a url. if possible, you can enter only one url as a parameter. You can directly enter the url with the arguments as a parameter.

     

    let
    Source = (URL as text) => let
    Source = Xml.Tables(Web.Contents(URL
    ))),
    entry = Source{0}[entry],

     

    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.