Filter Entity based on multiple condition

Help Apps
,
1

Hi,

I want to filter data between multiple approvers based on their names in Entity records and the Approval status in uipath Apps. Kindly suggest the solution.

2

where is your data ?

3

@Shivam_Chaturvedi Can you please explain a bit breif

4

If this is Data service please do as below.

=Lookup(“EntityName”,[FieldName=Field Value]).Id

you can look at below URL.

Please mark this as solution if works.

5

HI @Shivam_Chaturvedi

Change the entity to datatable and use filter datatable activity

Regards
Sudharsan

6

Hi,

I am using the uipath apps and not the uipath studio

7

Hi,

Thanks for replying but the solution provided by you is not providing the required results.

My basic idea is to filter entity records as follows:

If Condition 1- “Approver 1”= first name and “Approval status” = No or Condition 2 - “Approver 2” = first name and “Approval Status” = Approved by level 1 . If any one condition is true then show data as output.

If there is solution to above please suggest.

8

Hello @Shivam_Chaturvedi ,

Here is a use case. Please use filter approach to filter the data from entity. Please follow below approach.

  1. Go to Page
  2. Open Table data source setting.
    Add filter as : Function Filter(EntityName,[Condition],[Condition]
    image
    image1346Ă—543 50 KB

I have added this filter for 3 table and its working please see below image.

image
image1917Ă—973 113 KB

I have attached a POC for This, you can create an entity with AprovalPOC name with same field and import app and see it.

Solution_Filter.zip (67.1 KB)

Please let me know if you have any further query or mark this as solution.

1 Like
9

this doesn’t work for me

10

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