Hi @Anonymous ,
I will go another way on this - the LookUp should have been a Filter (danger of free-typing), but I will also add some different logic in the lower part.
With(
{
wScanned:
Filter(
TimeClockTest,
Item=BarcodeScanner3.Value
)
},
If(
CountRows(
Filter(
wScanned,
IsToday('Date/Time') &&
'Created By'.Email=User().Email
)
) = 0,
Navigate(Screen1),
Navigate(Screen2)
)
)
Can you please leave the bottom filter on wScanned - the whole idea is to get a Delegable filter and the top With() statement pre-filters and allows this. I have added your logic on the User - if this is not needed, remove it.
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.