Forum Discussion

Mat42's avatar
Mat42
Resolver I
5 years ago
Solved

2 Parameters

So, I've put together a query that uses a parameter. Currently, the basic code looks like this (ignore the capitalised sharepoint stuff, I just needed to anonymise stuff):       Source = SharePo...
Need Help
  • v-janeyg-msft's avatar
    v-janeyg-msft
    5 years ago

    Hi, Mat42 

     

    Yes, you can do it. You can use 'DateTime.LocalNow()' function in 'name' instead of using parameter.

    Try like this: 

     #"P_List xlsx_https://SHAREPOINTFOLDERFILELOCATION" = Source{[Name=Date.ToText(Date.From(DateTime.LocalNow()),"MMMM yyyy")
,#"Folder Path"="https://SHAREPOINTFOLDERFILELOCATION"]}[Content],

    Reference:DateTime.LocalNow - PowerQuery M | Microsoft Docs

    If it doesn’t solve your problem, please feel free to ask me.

     

    Best Regards

    Janey Guo

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Mat42's avatar
Mat42
Resolver I
5 years ago

Thanks for the reply amitchandak. Sorry, I didn't actually realise anyone else had replied.

 

Despite not seeing them previously, those links will be really helpful, thanks.

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Community Support
    5 years ago

    Hi, Mat42 

     

    Yes, I didn't actually say that #"January 2021_Sheet" should be changed because this is the name of the step in your pq. You only need to change the name or item to make it dynamic.

     

    Best Regards

    Janey Guo