Retrieve existing item SharePoint

[shabila97]

I create an app where user fill in their passport number and connect it to SharePoint Online.

There is a button named RetrieveID to check either the passport number submitted is already existed previously or a new one (in SharePoint List)

My question is, how can I identify whether the passport number is already existed or a new one?

[R3dKap · Accepted solution]

Hi @shabila97,

Let's say that your datasource is named MyDataSource (a SharePoint list) and that you have a column in it named PassportNo.

Let's say you have a text field called txtPassportNo and a button called RetreiveID.

If you want to know if the passport number entered in the field txtPassportNo already exists in the SharePoint list when you click on the RetreiveID button, then you simply need to put the following formula in the OnSelect event of your button:

OnSelect = Set(boolPassportAlreadyExists,Not(IsBlank(LookUp(MyDataSource,PassportNo=txtPassportNo.Text))))

That way, the variable boolPassportAlreadyExists will be true if your passport already exists in your list.

Is this what you were looking for ?

Emmanuel

[shabila97]

Hi Emmanuel,

This works fine for me. Thank you very much!!