Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago
Solved

Creating Custom Variable

I am new to Power Query and am using Power Apps to build a blank query connection to an API source. I am needing the startTime always to be constant, which is simple, but the endTime needs to be the ...
  • BA_Pete's avatar
    BA_Pete
    3 years ago

    Hi Syndicate_Admin ,

     

    Try this:

    Text.Combine(
    {
        Date.ToText(DateTime.Date(DateTime.LocalNow()), "yyyy-MM-dd"),
        "T19%3A08%3A25Z"
    }
)

     

    As a query:

    let
    Source =
    Text.Combine(
        {
            Date.ToText(DateTime.Date(DateTime.LocalNow()), "yyyy-MM-dd"),
            "T19%3A08%3A25Z"
        }
    )
in
    Source

     

    Output:

     

    Pete

BA_Pete's avatar
BA_Pete
Super User
3 years ago

Hi Syndicate_Admin ,

 

Try this:

Text.Combine(
    {
        Date.ToText(DateTime.Date(DateTime.LocalNow()), "yyyy-MM-dd"),
        "T19%3A08%3A25Z"
    }
)

 

As a query:

let
    Source =
    Text.Combine(
        {
            Date.ToText(DateTime.Date(DateTime.LocalNow()), "yyyy-MM-dd"),
            "T19%3A08%3A25Z"
        }
    )
in
    Source

 

Output:

 

Pete