I think my question was not very clear, my appologies. Let me rephrase:
In my app users can select with dropdownboxes a from date and a to date to request leave time. Once they click on the for approval button, the dates from until to are parsed into a collection. Subsequently the app should check in a linked excel file if for this user there are already one or multiple dates with approved status in the file.
Herunder some code of how I have tried to solve the issue:
verlof is the excel table, DateRange is the collection, the dates have been split up in day/month/year to avoid intercontinental date issues
If(!IsBlank(ForAll(Filter(verlof,Initials = DropdownAanvrager.Selected.Initials,Status <> "Rejected"),
ForAll(DateRange,Value(Day(Date)) = Value(Day) && Value(Month(Date)) = Value(Month) && Value(Year(Date)) = Value(Year)))),
"yes","no")
Resulting yes/no will be replaced by further coding to direct the app.
