How we know if the user pin is matched or not in below screenshot, please help me out thanks in advance

Help Activities
, ,
1

excel match
excel match1820×690 13.4 KB

2

Hi @panguluri_saritha

Can we know elaboration of the requirement?

As per my understanding you need to display tentant name as per the Inputting the Pin If I am right your steps would be below and follows below.

Read the Excel using Workbook activities

Use For each row in readDt

Use Input Dialog box

Enter the Pin

if condition Currentrow(“Pin”).toString.Equals(OutInputDialog)

Then Message box Current row(“TenantName”).toString

Regards

3

the user inputs:
eg: tenant name rty
pin some no
output i want: if pin match then print matched
else display not matched

4

here the user given pin is coming from uipath apps

5

Hi!

You can:

  • read the excel file to store values in a datatable
  • receive the user input
  • use lookup datatable activity to search the pin for the given tenant
  • validate the given pin with the pin you just looked up

Happy automating

6

Perfect
So once user enters the value in apps it will be sent to UiPath workflow in background as a argument
Let’s take it as in_pinvalue of type string

Now inside that workflow

  1. Use a excel application scope and pass the file path as input and read the data using read range activity and get the output as dt

  2. Now use a assign activity like this

bool_exists = dt.AsEnumerable().Where(Function(a) a.Field(of String)(“pin”).ToString.Contains(in_pinvalue.ToString)).CopyToDatatable().Rows.Count>0

If the number of matching rows is greater than 0 then it will give a Boolean value as true
Which you can get back to UiPath apps and show the message accordingly

Cheers @panguluri_saritha

8

Does that variable or argument has .ToString at its end
@panguluri_saritha