Hi,
I have a PowerApp that is use to make appointments. The list contains some timeslots and they can be different every day.
For example:
Monday: 08:00am / 09:00am / 10:00am
Tuesday: 09:00am / 10:00am
Wednesday: 08:00am / 09:00am / 10:00am / 11:00am
The list contains values that are editable by an admin screen which users can't see.
What I would like to have is the possibility to ignore the days behind us and limit the timeslots that are ahead of us.
The latter is working well:
FirstN(SortByColumns(Filter(collChoices,Locatie = DropdownLocatie_2.Selected.Result, Value(Available) > 0),"Title",Ascending),25)
With this I can limit the dropdown to 25 timeslots (unfortunately not in days, I would prefer that by the way....)
But in the dropdown you can also see the days that already have been. So yesterday is still in the dropdown and therefor the dropdown is still limited to the exact same timeslot as it was limited to yesterday.
How can I prevent those days to be shown?
The contents of the list (column "Title" in list "Choices List") :
2020/05/18 08:00
2020/05/18 09:00
2020/05/18 10:00
2020/05/19 08:00
2020/05/19 09:00
2020/05/19 10:00
The bold ones (yesterday) I don't want to see in the dropdown on the 19th. On the 20th I don't want to see the 19th - choices. Ultimately I don't want to see the timeslots of 08:00am and 09:00am when it is already 09:05am if you know what I mean.
Any thoughts ?
