Parameter issue Switching Sharepoint Folder

[BlueWhite3699]

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.

[BlueWhite3699 · Accepted solution]

Worked it out chaneg 

https://change.sharepoint.com/sites/M365Healthcheck-ClientData/Shared Documents/Client Data/CIFF/apples/"]}[Content]

to

Filepath &"/apples/"]}[Content]

[BlueWhite3699]

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],