Power Platform Community Forum Thread Details

Hi,

I'm building an app that includes a checklist. I was to add whether or not the form has been submitted each day for the past 5 days using an icon. There will be multiple users so i've added in a check for whether a submission has been made by the current user for each specific date using the following code:

If(LookUp('FOH Opening Checklist','Created By'.Email=User().Email,Date = Today()-1),"Checkmark","Dismiss")
I only seem to get a false response no matter what. I've tried a few methods but can't make it work but it works for the current date which uses the following code:
If(LookUp('FOH Opening Checklist','Created By'.Email=User().Email,Date = Today()),"Checkmark","Dismiss")
I tried using DateAdd(Today(),-1) as well with the same result. Every time I use the Copilot explanation it indicates that the code is correct:
This expression checks if the current user's email matches the email of the creator in the 'FOH Opening Checklist' table for the previous day's date. If the condition is true, it displays a "Checkmark" icon; otherwise, it displays a "Dismiss" icon.
Any help would be appreciated.