Hi!
I'm building a Power App to handle leave requests for my company. My app uses a Microsoft List as a database (I know it's not the best approach) where all the requests are stored there. The columns in the list are: Employee (Office365 profile), Start (Date), End (Date), RequestType (choice) and Status (choice). I have a gallery that fetches information from the list, filters only the entries from the current user that has days in the current year and displays it. Most of the information displayed in each gallery card are directly fetched from the entry in the Microsoft List. However, one label counts the number of weekdays between the start date and the end date that fall within the current year. I have tested with several combinations and everything has worked as expected, but I anyways get the error "The first argument to Sequence must be between 0 and 50.000" when refreshing the Microsoft List. I have been commenting out fields and pieces of code to figure out where the error is coming from but so far I haven't succeeded. Here is a screenshot of the app for completeness:
The error happens exclusively when pressing on the "My leave requests" which refreshes the Microsoft List.
Here is the code for the Items property of the gallery:
If(
IsBlank(SelectedRequestFilter),
Filter(
'Holiday tracker', //SortByColumns('Holiday tracker', "DateRequested", SortOrder.Descending),
StartsWith(
Employee.DisplayName,
User().FullName
),
End >= Date(Year(Today()), 1, 1)
),
/*Filter(
Filter(
'Holiday tracker',
Status.Value = SelectedRequestFilter
),
StartsWith(
Employee.DisplayName,
User().FullName
),
End >= Date(Year(Today()), 1, 1)
)*/
Filter(
'Holiday tracker',
Status.Value = SelectedRequestFilter,
StartsWith(
Employee.DisplayName,
User().FullName
),
End >= Date(Year(Today()), 1, 1)
)
)
The SelectedRequestFilter comes from the three buttons above the gallery and is empty if no filter is selected.
Thanks in advance!
