What's wrong with this formula?

[private_matter (Karl)]

Hello. I built a registration and login form in UiPath apps, and I need to take and check the data provided by the user against an entity database. However, after clicking on the Login button, nothing happens though the email and password both match the ones in the database. Not sure what’s wrong in the formula. Please check the screenshot below. I have binded both fields with the app variables called Email Address and Password.

[Arvind_Kumar1 (Arvind Kumar)]

Hello @private_matter ,

This does not return true or false. you need to return Id of records and then match if length is greater than 0 then match else fail.

Thanks,
Arvind

[postwick (Paul Ostwick)]

You don’t type the = in the box on the right.

Also, the expression on the left doesn’t return true or false.

[private_matter (Karl)]

Hello @Arvind_Kumar1

But why do I need to search by ID? Why can’t I simply search by the email of the user since its only going to be one for each user? And can you supply an example of how this can be written by ID so I can try to see if that’ll work?

Regards,
Karl

[Arvind_Kumar1 (Arvind Kumar)]

Hello @private_matter ,

Please implement as below.

length(LookUp(Datasource,[Password,”=“,Value],[email,”=“,value]).Id) > 0

Thanks,
Arvind

[private_matter (Karl)]

Yes that worked. Fantastic! Thanks.