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

  • VijayP's avatar
    VijayP
    Icon for Community Champion rankCommunity Champion

    Anonymous 

    This article helps you!

    • Anonymous's avatar
      Anonymous
      Not applicable

      Im trying to enable schedule refresh on web contents, as I connect to shar point it says, my data source is dynamic -Im passing parameters to get the data...
      In code I need to set parameters as static ... this can be acheive by setting Relative path and query... I want help regarding how to set those and make above fuction enable for scheduling refresh. Than You

      • v-janeyg-msft's avatar
        v-janeyg-msft
        Icon for Community Support rankCommunity Support

        Hi, Anonymous 

         

        I'm afraid not, how can a dynamic data source set static parameters?

  • Anonymous's avatar
    Anonymous
    Not applicable

    Im Sorry, If i said someting wrong, In order to do schedule refresh on datasource connected to web contents we must set "Relative Path" and define parameters in query, correct me if im wrong.... I want help in doing it on above fuction, then my problem is solved ....