Forum Discussion
Parameter does not update automatically
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!
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)
6 Replies
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?
Please show the code for the MaxDate (2) query.
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)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)
