i have SharePoint folders having invoices, i need to get invoice number from each invoice and search in another application for invoice country value .
Then i need to move this invoice to particular country folder in SharePoint/one drive. please provide best automated in power automate solution.
simple SharePoint i have invoice folder recursively scan each invoice, get invoice number and search country code in another application .based on country code i should move/copy this invoice to that country folder.
need to capture the in excel invoice number copied country code.