Sharepoint folder locations as flow variables

I have an existing KNIME workflow using shared network locations that I want to update to use Microsoft sharepoint locations. The existing workflow uses a table of strings that become path flow variables that are used later in excel reader, rule engine and empty table switch logic, and various file manipulation nodes (transfer files node, writing multiple processed files that have some logic based on what is in the data).

I have done testing on very simple sharepoint node workflow that simulates the start of my existing workflow with simulated files in the sharepoint locations, and I cannot determine how to create a proper flow variable that the excel reader node (for example) can utilize for the file location. The workflow will read a target file just fine if I manually brows to the sharepoint location, but I have tried many permutations of formats / inputs and always results in an error saying “does not exist”.

I assume that this should work, but I am assuming the error is not getting the proper format into the variable for sharepoint (I have tried with and without “string to path (variable)” node).

If anyone can provide some insight would be extremely helpful, the use case will have multiple benefits if I can get this to work using Sharepoint file system.