Filter Entity based on multiple condition

[Shivam_Chaturvedi]

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.

[Arvind_Kumar1 (Arvind Kumar)]

where is your data ?

[ushu (Usha kiranmai)]

@Shivam_Chaturvedi Can you please explain a bit breif

[Arvind_Kumar1 (Arvind Kumar)]

If this is Data service please do as below.

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

you can look at below URL.

Function: Lookup

Please mark this as solution if works.

[Sudharsan_Ka]

HI @Shivam_Chaturvedi

Change the entity to datatable and use filter datatable activity

Regards
Sudharsan

[Shivam_Chaturvedi]

Hi,

I am using the uipath apps and not the uipath studio

[Shivam_Chaturvedi]

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.

[Arvind_Kumar1 (Arvind Kumar)]

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]
   
   

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

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.

[Shivam_Chaturvedi]

this doesn’t work for me