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

4 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

Forum Discussion

Creating Custom Variable

Related content

How creating a Python custom library

Creating a dynamic filtered table variable

Create a custom column containing a variable

Unable to Create Variable library

Creating a custom column