SharePoint Online-Check if the field value is same in the existing data and send email

[Alkindi1222]

Hello,

I need help to create the flow for SharePoint online list, when created check if the field "Invoice Number" value is same in the existing data. If found same trigger email to ex person.

Thanks for you support,

Omer Dayani

[PrasadAthalye]

@Alkindi1222 - If you are looking for Unique Key behavior, you can set this on SharePoint List Column itself... Refer below..

Like and Mark this as a solution if it resolves your issue.

[Diksha · Accepted solution]

Hello @Alkindi1222 ,

I have posted my answer for this in detail on General Power Automate Discussion forum . 

Please have a look . 

Link - https://powerusers.microsoft.com/t5/General-Power-Automate/SharePoint-Online-Check-if-the-field-valu... 

If this answered your question, please mark this question as answered and if you liked my response, please consider giving it a thumbs up .

Thank You !!!

[Alkindi1222]

Hi @Diksha ,

Could you please help me to create a query on multiple fields, earlier we created the filter for only two fields.

now, we need to create query which checks the invoice#1,2,3,4 or 5 any of them value is same with the field vendor name. Basically to check any duplicates with invoice#1,2,3,4,5=Vendor name.

Thanks,

Omer Saeed

[Diksha]

Hello @Alkindi1222 ,

If I understand it correctly , you want to check if Vendor Name matches and if any of the above given Invoice Numbers(1 to 5) columns matches . 

You can try below query - 

VendorName eq '@{triggerOutputs()?['body/VendorName']}' and ((Invoice#1 eq '@{triggerOutputs()?['body/Invoice#1']}') or (Invoice#2 eq '@{triggerOutputs()?['body/Invoice#2']}') or (Invoice#3 eq '@{triggerOutputs()?['body/Invoice#3']}') or (Invoice#4 eq '@{triggerOutputs()?['body/Invoice#4']}') or(Invoice#5 eq '@{triggerOutputs()?['body/Invoice#5']}')) and ID ne '@{triggerOutputs()?['body/ID']}'

If this answered your question, please mark this question as answered and if you liked my response, please consider giving it a thumbs up .

Thank You !!!

[Alkindi1222]

Hi @Diksha 

I tried but sadly couldn`t success.