Forum Discussion
Solved
Parameter issue Switching Sharepoint Folder
Hi Experts
How would i change the following sharepoint file path to pick up different client data in different sharepoint folder...
= Source{[Name="apples.csv",#"Folder Path"="https://change.sharepoint.com/sites/M365Healthcheck-ClientData/Shared Documents/Client Data/CIFF/apples/"]}[Content]
where CIFF is the client folder and we are looking at apples CSV.
Worked it out chaneg
https://change.sharepoint.com/sites/M365Healthcheck-ClientData/Shared Documents/Client Data/CIFF/apples/"]}[Content] to Filepath &"/apples/"]}[Content]
2 Replies
let Source = SharePoint.Files("https://change.sharepoint.com/sites/M365Healthcheck-ClientData/", [ApiVersion = 15]), #"apples csv_https://change sharepoint com/sites/M365Healthcheck-ClientData/Shared Documents/Client Data/CIFF/apples/" = Source{[Name="apples.csv",#"Folder Path"="https://change.sharepoint.com/sites/M365Healthcheck-ClientData/Shared Documents/Client Data/CIFF/apples/"]}[Content],Worked it out chaneg
https://change.sharepoint.com/sites/M365Healthcheck-ClientData/Shared Documents/Client Data/CIFF/apples/"]}[Content] to Filepath &"/apples/"]}[Content]