Reference Sharepoint synced folder via local path

[erinkm]

Hello!

I am trying to create a data process for multiple users to access a series of files and folders via Power Query.

I would like to use the local path, rather than pulling from a Sharepoint folder - for both file organization and speed purposes. (Get Data from Sharepoint Folder has proved to be *much* slower than doing it locally.) All users will have the folders and files synced to their devices.

I created a formula and table so that the local path can be isolated via a query, then plugged that query result into the query pulling the data. I am receiving an error. 

Can anyone help me adjust this method to resolve the error or suggest another to accomplish the same result?

Here is the path, when pulling directly from the folder. 

Here is the result of the query to create the specific local path for the user.

And here is where I've plugged the second query into the first and the resulting error.

Please let me know if any additional information would be helpful.

I appreciate any thoughts or suggestions.

Thanks so much,

erin

[dufoq3 · Accepted solution]

https://exceloffthegrid.com/formula-firewall-in-power-query/