Parameter does not update automatically

[Anonymous]

There is a list MaxDate (2) (which is basically a table with one cell that calculates yesterday's date, which is converted into a list in order to be referred by the parameter as a query)

The parameter which i need to update automatically is referring to the above list

But as you see above, the current value is 13/02/2023, which was when i created this parameter and hasn't updated since, even when the MaxDate (2) list has updated to 28/02/2023.

Is there any possible way to update this parameter. I need not necessarily use this list/table, if there is any other way to update the parameter everyday automatically, I'm open to that solution as well.

Thanks in advance!

[Anonymous · Accepted solution]

Instead of using a paramter, I just created a table with a single cell that calculates the yesterday's date using the formula: Date.AddDays(Date.From(DateTime.FixedLocalNow()),-1)

I then add this column to my original table, where I was initially using the parameter.
Now that column updates as the above created table updates (everytime i refresh)

[Anonymous]

Instead of using a paramter, I just created a table with a single cell that calculates the yesterday's date using the formula: Date.AddDays(Date.From(DateTime.FixedLocalNow()),-1)

I then add this column to my original table, where I was initially using the parameter.
Now that column updates as the above created table updates (everytime i refresh)

[lbendlin]

Needs more details. Is that an issue on Desktop only, or also in the service? Did you set up scheduled refresh in the service?  How often?

[Anonymous]

Its on Desktop, not on service.
Even on manual refresh, the parameter does not change

[lbendlin]

Please show the code for the MaxDate (2) query.

[Anonymous]

It doesn't accept a query in the parameter, it only accepts a list.
Anyway I found an alternate solution without using the parameter. Thanks for your help