Forum Discussion

AbhinavJoshi's avatar
AbhinavJoshi
Responsive 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)

AbhinavJoshi's avatar
AbhinavJoshi
Responsive Resident
2 years ago

Thanks amitchandak . It intially gave me an error: We cannot convert the value #datetime(2023, 10, 18, 11, 6, 4.7513611) to type Date. But I passed Date.ToText(Date.From(DateTime.LocalNow())) instead of Date.ToText(DateTime.LocalNow(), "yyyy-MM")

Have a great day!