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
Solved! Go to Solution.
Hello @Alkindi1222 ,
I have posted my answer for this in detail on General Power Automate Discussion forum .
Please have a look .
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 - 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.
Hello @Alkindi1222 ,
I have posted my answer for this in detail on General Power Automate Discussion forum .
Please have a look .
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 !!!
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
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 !!!
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Did you know that you could restore a deleted flow? Check out this helpful article.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
31 | |
30 | |
24 | |
24 | |
21 |
User | Count |
---|---|
64 | |
57 | |
43 | |
37 | |
29 |