Filter last entry on dataverse?

(0) Share

Report

Posted on by Usernametwice

503

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

Categories:

Building Power Apps

I have the same question (0)

All responses (13)

Answers (1)

Sort by

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
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!

Was this reply helpful? Yes No
Ram Prakash Duraisamy 5,753 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @Usernametwice23,

Try Using below code

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

Was this reply helpful? Yes No
Usernametwice 503 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
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!

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Usernametwice23

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

Was this reply helpful? Yes No
Usernametwice 503 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No
Usernametwice 503 on at

Like (0)

Report
Copy link

Link copied!

Hi @Nogueira1306
Attrached is a screenshot of the error

Was this reply helpful? Yes No
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

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

Was this reply helpful? Yes No
Usernametwice 503 on at

Like (0)

Report
Copy link

Link copied!

Hi @Nogueira1306

Apologies, but when I use that I receive this error now attached. Im out of my depth here im afraid and unsure what I should remove.

Thanks a lot for your effort.

Was this reply helpful? Yes No