Friday, February 19, 2021

Power Query - Sharepoint.List

 let

//Errado =>
//Source = SharePoint.Tables("https://XXX.sharepoint.com/sites/XXX", [Implementation=null, ApiVersion=15]),

//Correto =>
 Source = SharePoint.Tables("https://XXX.sharepoint.com/sites/XXX", [Implementation="2.0", ViewMode="All"]),

//New

  // https://XXX.sharepoint.com/XXX/apprioenergy/Lists/forpostos

  SharePointSite = "https://XXX.sharepoint.com/XXX/apprioenergy/",

  Source = SharePoint.Tables(SharePointSite, [ApiVersion = 15]),

  Navigation = Source{[Id = "818e1c12-b556-4c38-9c78-3fbc8732e848"]}[Items],



No comments:

Post a Comment

Power Query - funcao limpa replace texto numero

//fnc_limpa_texto (TextValue as nullable text) => let     SafeText = if TextValue = null then "" else TextValue,     DigitsOnly...