I have a table of events, sorted by their start time, and filtered to hide events whose end time has passed. In the table, this is working, so the first event in the table is always the next event, or the event that’s currently going on.
I’m trying to create a variable outside of the table that grabs the next upcoming meeting by simply grabbing the first row. The code in the variable is literally just
[Table Name].First(). Somehow this is returning the fourth item in the table. When .First() is applied to a table, what is used as the index? Does it not respect sorting?