Hi,
I am creating a power app that has information on a user who is on call each day of the year. I have populated the data into a Gallery List.
My Table is called OPSData and I have an Excel Sheet in OneDrive
Unique, - Number (numbers 1- 365)
Month, - Text (e.g June)
Date, -Text (dd/mm/yyy)
NumberDate, Number (date in the month 1-31)
Day, Text (Monday- Sunday)
Primary - Text (user name
In my Gallery List I have :
Todays Date
----------------------------------------------------------------
NumberDate Unique Primary
Day
Month
-----------------------------------------------------------------
What I am trying to do is to get the Gallery List to show the correct row based on Todays Date. The way I am doing this is, I have two dates hidden Start Date and Todays Date. The Start Date is set to the start of the year and Todays date is whatever the date today is. I am then counting the days between those two dates using:
Value(DateDiff(StartDate.SelectedDate, TodaysDate.SelectedDate,Days))
I then get a value (e.g. 153)
What I am trying to then is feed that value into the Default for the Gallery List to get the default row shown on load to be 153. On the GalleryList Default I am using:
LookUp(OPSData, Unique = DayCount.Text)
However when I run the app the GalleryList does not jump to that row.
Any help would be appreciated.
