Upload files to FTP based on mapping sheet

I got a mapping sheet where invoice is written
299179
846142
525401
124709
563188
163594
727446
556845
301034
497634
30356
710143
638564
861102

and folder where pdf invoice is there, but the issue is pdf name is bit tricky.
299179_smith_27-12-2021.pdf.
846142_farhan_17-10-2021.pdf

task is I have to create a folder by invoice number and upload the invoice pdf.

I can get the pdf path but comparing it with the invoice number is quite hard for me.
can you please help me, how to do it.

@Dmitri00007
Please use try to split by _ then take the first array of your invoice number then compare with the your mapping sheet if match with your mapping sheet then update to the FTP.
FTP configuration please refer this doc: With FTP Session
Upload files in FTP: Upload Files

Thanks

We can acheive this using if activity

> pdf_file_name.Contains.Invoice_var

@Dmitri00007

InvoiceNumber=299179

If
InvoiceNumber.equals(mappingsheet_input)
Then upload invoice data to the FTP location.
Else throw the exception.

If
299179_smith_27-12-2021.pdf.containes(“299179”)
Then get the file path

I’ll be so thankful if you demonstrate it and share the Xaml file.
please

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.