Share
Report
Hello everyone!
I have an application connected to two lists in SharePoint:
The first one stores the calendar, containing 365 rows.
The second one is a table with employees' data per day, showing how many hours each employee worked.
When an employee accesses the application, they can see how many hours they worked each day. The main gallery here is the calendar. And the hours are linked using a lookup function:
LookUp('Timesheets_Pivot Times',ThisItem.date = Date &&User().FullName = Employee, Hours)
For the past four months, everything was working fine, but today, everyone stopped seeing their hours. However, in the table with hours, there are 1700 rows. If I log into the application and specify the number of hours, the value will be pulled, but the results for previous periods are not. I spent the whole day trying to fix it, and in the end, I replaced the formula with the following:
LookUp(
'Timesheets_Pivot Times',
Concatenate(User(), "_", Text(ThisItem.date, "dd/mm/yyyy")) = Title,
Hours
)
That is, I disabled the lookup by two fields and replaced it with a search by key.
Can anyone help and suggest why this is happening?
All responses (
Answers (
354
