cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Alkindi1222
Helper II
Helper II

Find duplicates value in multiple fields - Sharepoint

Hi,

 

I need to find duplicate values in multiple fields, when item is created.

Alkindi1222_0-1606115699709.png

Basically, need to check if the Invoice#1, 2, 3, 4 or 5 value is matching Vendor name value. If values of any invoice number matches in existing data with same vendor name then send email. How can i create multiple filters?

 

Thanks,

Omer Saeed Dayani

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-siky-msft
Community Support
Community Support

Hi @Alkindi1222 ,

 

Do you mean you want to validate if a Value exists in other columns, right?

If so, please try this:

1. Get all items from sharepoint list

2. Extract a single-column Array using Select operation for each column

3. Use Contains() function to check if the value exists in that single column and use Or function to combine all criteria in Condition Step.

For instance:

Snipaste_2020-11-25_14-01-08.png

Hope this helps.

Sik

 

 

View solution in original post

2 REPLIES 2
v-siky-msft
Community Support
Community Support

Hi @Alkindi1222 ,

 

Do you mean you want to validate if a Value exists in other columns, right?

If so, please try this:

1. Get all items from sharepoint list

2. Extract a single-column Array using Select operation for each column

3. Use Contains() function to check if the value exists in that single column and use Or function to combine all criteria in Condition Step.

For instance:

Snipaste_2020-11-25_14-01-08.png

Hope this helps.

Sik

 

 

Dear @v-siky-msft ,

Thanks for reply,

Alkindi1222_0-1608705807187.png

 

 

I have total five invoices field and one field for vendor name. For instance:

  • If vendor name 'ABC' and invoice#1 '055211
  • Now another item with same vendor 'ABC' and field is invoice#2 '055211', same applies to invoice#3,4 and 5 with Vendor name. So what we need is that the invoice number value '055211' in five fields should not be equal with vendor name 'ABC'.

Hope I was able to explain.

 

Thanks,

 

Omer Saeed Dayani

 

 

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Top Kudoed Authors
Users online (2,294)