
So i am making a overtime tracked because i work for a place where if you take off it has to be covered.
i made a form they can fill out then when they submit it it goes to a list which then gets show by a gallery on the app.
Gallery automatically puts them in the order they were created instead of by the date.
This is what i have so far and it does not work.
Sort(Filter('Vacation Log Main', Status.Value = "UnClaimed",Text('Date',"mm/dd/yyyy")=
Text(Today(),"mm/dd/yyyy")),'Date',Ascending)
Any help would be appreciated, you will see the Status.value="UnClaimed" , That is because i wanted to separate the galleries' so once someone claims the overtime it goes to a different one.
I suggest:
Sort(Filter('Vacation Log Main', Status.Value = "UnClaimed"),'Date',Ascending)
Is the date a Date type or text. Also what is your datasource, sharepoint?
------------
If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.