How to select row in a table based on what time of day and what day of week it is.
Attached is a PowerApps I built for work, we use it to communicate the what machine the employees are scheduled to work on for the day (names go where white blocks are shown). On the left are are and shift, along we top are machine names (also whited out).
I'd like to get the pink selection bar to highlight the day and shift it is so operators know immediately where to look.
Question: How do I get the selection bar in a table to scroll down the rows based on what day of the week, and what time of day it is.
Purpose: to highlight the row representing the current shift.
You can set the Default for your gallery to dynamically find the record that matches the current day of week and hour (or whatever types of values are in your datasource/collection).
For example, I made a simple gallery with items of ["Monday", "Tuesday", "Wednesday"] and use this formula to set the default. You could add a second field to the record expression to add a formula that finds the current hour from Now() also.