Forum Discussion

jesly_ajin's avatar
jesly_ajin
Icon for Helper III rankHelper III
4 years ago

Dynamic from date and to date in web source query

Hi All,   In the below code, I need the bold ones to read data based on user selection of start and end date. Kindly guide me to achieve this.   let Source = Json.Document(Web.Contents("https:/...
Need Help
Show and Tell
jesly_ajin's avatar
jesly_ajin
Icon for Helper III rankHelper III
4 years ago

Vijay_A_Verma , I did create a parameter as suggested from your side.

However, when I look to bind the parameter, i see no option for it.

Kindly guide me with steps to use RangeStart & RangeEnd as parameters.

Vijay_A_Verma's avatar
Vijay_A_Verma
Icon for Most Valuable Professional rankMost Valuable Professional
4 years ago

You need not bind just put the dates such as 2022-07-01 in these parameters. Make sure that you select Text as type for parameter value not as date.

  • jesly_ajin's avatar
    jesly_ajin
    Icon for Helper III rankHelper III
    4 years ago

    I do not wish to hard code the start & end date. I need it to change based on user selection. Hence trying to bind

    • Vijay_A_Verma's avatar
      Vijay_A_Verma
      Icon for Most Valuable Professional rankMost Valuable Professional
      4 years ago

      What will be the source of your start and end dates?