Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Cannot do schedule refresh for data connect to SharePoint list ( dynamic data source) PLEASE HELP ME

I connect to sharepoint list online, I used below fuction to get data along with version history from sharepoint...  Im unable to do schedule refresh as it is dynamic data source... Im unaware of how  set relative path and query 

Please Help Me to set schedule refresh.. This is for my project 

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

6 Replies