Identifying Duplicate Entries

[Yuoseff]

Hi Everyone!

I'm pretty new to PowerApps and I wonder if my query has in all ways been addressed by you lot. Basically, I am working on an Invoicing Tracker/Form and I needed something to help identify if a particular item has already been invoiced for (see image). 

If this has been discussed and addressed, I'd appreciate if you could direct me to the said discussion for reference. Thank you.

[v-sheyu-msft · Accepted solution]

hi @Yuoseff,

Do you want to display the notice in the “candidate  name” box when you type the same requisition ID ,business name & invoicing month?

I made  a test .

I create a share point list named invoice.

Set the visible property of the textinput2 to :

If(IsBlank(LookUp(invoice,businessname=ComboBox1.Selected.businessname && invoicingmonth=ComboBox2.Selected.invoicingmonth && requisitionID=TextInput1.Text)),true,false)

When you entry business name ,invoicing month and requisition id ,it will check if the same record in the data source.  if the data source has the same record ,the textinput2 control will be invisible.

regards,

eason

[Yuoseff]

Thank you. I'm going to give this a try and see if it works.