Help using M code for Source

[Stuart74]

Hello



I hope someone can help.



All my power queries to date have used a fixed drive letter on the path. As my company is moving to SharePoint/One Drive. I have tried the code below but it does just does not want to work. I am trying to make my Power Query workbooks work for several users, some using online storage, some using fixed drive letters (network shares) Help?!

The getvar part works, it its the if then I need to work.

Thank you for any help.

Thanks

Stuart

 

[JEC]

You should try a web link instead of sharepoint file. Although that should work too

 

[jdellasala]

This might help:

 

[Stuart74]

Hello

Thank you for the replies. I have found that the issue is that the IF statement at the start was in CAPS and not lower case, if.

Thanks

Stuart