Filter last entry on dataverse?

[Usernametwice23]

Hello

Each time a user logs in, a text record 'Yes' is created in a column next to the users ID code. So, logged in = Yes.

I am trying to filter a column in Dataverse. If the user's last entry was a 'yes' entry then the button should be disabled. 

  If(IsEmpty(Last(Filter('Stagings', 'Logged In'= TextInput1.Text, 'Employee Code'=inPutEmployeeID))),
   DisplayMode.Edit, 
   DisplayMode.Disabled)

 Right now the button is always disabled and im not sure why using the above formula (textinput1.text is displaying 'yes').  So it's filtering based on the user's code and whether or not the latest entry for that user was a 'yes' but not working. 

I;ve also tried : 

  If(IsEmpty(Last(Filter('Stagings', 'Logged In'= Text('Yes'), 'Employee Code'=inPutEmployeeID))),
   DisplayMode.Edit, 
   DisplayMode.Disabled)

But that says theres invalid arguments with Text('Yes')

Also:

  If(IsEmpty(Last(Filter('Stagings', 'Logged In'= Text('Stagings'.'Logged In'.'Yes')), 'Employee Code'=inPutEmployeeID))),
   DisplayMode.Edit, 
   DisplayMode.Disabled)

But no luck. 

Any help is much appreciated with this. Thank you 

[Nogueira1306]

  If(IsEmpty(Last(Filter('Stagings', 'Logged In'= "Yes", 'Employee Code'=inPutEmployeeID))),
   DisplayMode.Edit, 
   DisplayMode.Disabled)

Try that please

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

[rampprakash]

Hi @Usernametwice23,

Try Using below code

If(IsEmpty(Last(Filter('Stagings', And('Logged In'= "Yes", 'Employee Code'=inPutEmployeeID)))),
   DisplayMode.Edit, 
   DisplayMode.Disabled)

[Usernametwice23]

Hi @Nogueira1306 

Thank you for the comment. Its much appreciated. 

Okay so now the button is permanently disabled if I use that one. Even if their last entry doesnt have 'yes' next to it. Is there a way to make it available again if the users last record doesnt have yes? I thought the 'last' function would do this but i guess i was wrong. 

Thanks for your help

[Nogueira1306]

  If(IsEmpty(First(Sort(Filter('Stagings', 'Logged In'= "Yes", 'Employee Code'=inPutEmployeeID); Created; Descending))),
   DisplayMode.Edit, 
   DisplayMode.Disabled)

Please try that one. Check if syntax is correct

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

[Drrickryp]

@Usernametwice23 

IsEmpty() refers to a table but you are trying to examine a single record with Last(). IsBlank() would be more appropriate. 

[Usernametwice23]

Thanks @Nogueira1306

Thats really helpful and I would not have thought of that. 

I'm getting the expected operator message, +,* or &, Im guessing the syntax needs something here but i'm unsure what. I'm sure it's something simple but I cant see it.

I saw your message said check syntax but to me it looks correct. Sorry if this is a silly question.

Appreciate the help very much. 

[Nogueira1306]

Show me the error

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

[Usernametwice23]

Hi @Nogueira1306 

Attrached is a screenshot of the error 

[Nogueira1306]

  If(IsEmpty(First(Sort(Filter('Stagings', 'Logged In'= "Yes", 'Employee Code'=inPutEmployeeID), Created, Descending))),
   DisplayMode.Edit, 
   DisplayMode.Disabled)