Help using M code for Source

Stuart74

New Member
Joined
Mar 17, 2023
Messages
4
Office Version
  1. 365
Platform
  1. Windows
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?!

1679396956715.png


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

Thank you for any help.

Thanks

Stuart
 

Attachments

  • 1679396815772.png
    1679396815772.png
    46.9 KB · Views: 6

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
You should try a web link instead of sharepoint file. Although that should work too
 
Upvote 0
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
 
Upvote 0
Solution

Forum statistics

Threads
1,223,360
Messages
6,171,630
Members
452,411
Latest member
sprichwort

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top