User Profile
MarM79
Copper Contributor
Joined Jul 21, 2022
User Widgets
Recent Discussions
Duplicated invoices in Sharepoint library
Hello everyone, I have tried to build an automation in a Sharepoint library to identify when a supplier is using an invoice number that they have used before. I have created a calculated column that concatenates the name+invoice number to be able to identify the duplicates, however, I cannot find how I can then make the library or Power Automate notify me when a duplicate is spotted as calculated fields seem to be tricky to query. Can I create a Power automate flow that can do that? Thank you for any advice you could give me. Thanks183Views0likes0CommentsRe: Sharepoint library metadata adding a calculated field based on another lookup field
Hello Bharath, Thank you for your feedback on this. I think it would be just ok to know when a duplicate one is create so that we can action as soon as it is uploaded. Would you be able to help with the Power Automate I should be using for that? I have also tried that route, but I have not been able to build that either :D.2.2KViews0likes0CommentsSharepoint library metadata adding a calculated field based on another lookup field
Hello all, I have been trying to do this forever since is giving me a lot of issues, but I am not able to figure out how to implement. I am storing in sharepoint all the invoices and managing the data for reporting through metadata. I have a lot of validations but I would like to create one field that validate if an invoice is a duplicate. The only to see that is if invoices are duplicated, the invoice number [Invoice Number] AND the supplier ID [Supplier Number]are the same. I wanted to create a field where I concatenate [Invoice Number]+[Supplier Number] so I can then find the duplicates. Unfortunately the Supplier ID is a lookup field so I am not able to create a calculated field. I have tried to create an additional column and try to get the data with JSON schema: { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "div", "txtContent": "=[$Supplier Number.lookupId] + '-' + [$Invoice Number]" } Bit it doesn't work 😞 What did I do wrong? Thanks! MargSolved2.6KViews0likes4Comments
Recent Blog Articles
No content to show