Forum Discussion

AbhinavJoshi's avatar
AbhinavJoshi
Icon for Responsive Resident rankResponsive Resident
2 years ago
Solved

Reference a query in the source step

Hello,   I would like to reference a query or a parameter in the source step. I am using sharepoint as my data source. I would like to get the current month and year value that changes every month ...
Need Help
Show and Tell
  • amitchandak's avatar
    amitchandak
    2 years ago

    AbhinavJoshi , You can get a date in the format like

     

    = Excel.Workbook(Web.Contents("www.mysharepoint.com"  & Date.ToText(DateTime.LocalNow(), "yyyy-MM") &  "FileName"), null, true)

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
2 years ago

AbhinavJoshi , You can get a date in the format like

 

= Excel.Workbook(Web.Contents("www.mysharepoint.com"  & Date.ToText(DateTime.LocalNow(), "yyyy-MM") &  "FileName"), null, true)