UiPath Lookup in VB Apps

Help Apps
,
1

Does anyone know how to lookup in VB Apps. I previously did everything and now it seems to have vanished away due the deprecation.

Anyway, I want to check if current user email address is in the Entity “X” and his role is “Y” return true, otherwise return false.

The image shows a rule configuration interface for the "load" event of GeneralManager, displaying an IF/Else condition setup and an expression editor window with an open field for input. (Captioned by AI)
The image shows a rule configuration interface for the "load" event of GeneralManager, displaying an IF/Else condition setup and an expression editor window with an open field for input. (Captioned by AI)1053×703 37.6 KB

2

@Sarmad_Nadeem,

Try this expression.

Entity.X.Any(Function(e) e.Email = UserContext.User.CurrentUser.Email AndAlso e.Role = "Y")
3

It is stating Any is not a member of the entity:

This image shows an error message within an Expression editor, indicating that the term 'Any' is not recognized as a member of 'EndOfServiceUsers'. (Captioned by AI)
This image shows an error message within an Expression editor, indicating that the term 'Any' is not recognized as a member of 'EndOfServiceUsers'. (Captioned by AI)477×526 12.1 KB

4

Hello, Were you able to resolve this issue? I am facing a similar issue

5

Yes. This issue was solved. I will try to explain it although I am not good at explaining lol.

You add List and Entity in App Variables.
Set Value
Entity Variable = Use query builder to build your query on list variable
(It will give you one record → one entity)

Then you can show message Entity Variable.FieldName

image
image211×128 2.59 KB

The image shows a flowchart with steps to set a variable 'Users,' check if the user's role is 'BusinessUserManager,' and open a 'NoAccess' page if the condition is not met. (Captioned by AI)
The image shows a flowchart with steps to set a variable 'Users,' check if the user's role is 'BusinessUserManager,' and open a 'NoAccess' page if the condition is not met. (Captioned by AI)443×807 24.1 KB

6

This is working perfectly. Thank you for the help.

7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.