Have an issue can't seem to solve. Have a data table MonthTable with 12 months of sales figure and want to display as trailing 12 months eg: if we are in April then sort starting with April (last year) thru March (this year). Table has 2 columns MonthNumber and Sales.
I have a lookup table to get the sort order based on current month. Works when hard coded, but does not using variable.
On Visible screen set the variable, to test I hard coded it for April ie: month 4
Solved! Go to Solution.
Thankyou for the quick reply. That solved that issue perfectly!
However the goal is to have this sort automatically based on current month. So I put all the 12 sort strings (SortOrderMonths) in a table (SortText) and tried this
Suggest you post your additional question in a new thread and close this one. I am not necessarily sure I have the answer here so its best to start a new thread.
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
Check out our new profile badges recognizing authored solutions!
We are excited to announce the Power Apps Super Users!
Did you miss the call? Check out the Power Apps Community Call here.
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!