Document Understanding - Creating Excel file and Referencing the same in the end of workflow

[srinivas_pradeep]

Hi Team,

Hope you are doing well. I need help please.

I am trying to build the workflow for invoice extraction using -Document understanding.

The issue is

1. I am creating an excel file - Which extracts all the information from the invoice.
   The excel file is in the format - Sai_export - 20220714-093133 (with date time in the end)
   This is in the beginning of the workflow. The syntax is
   Path.Combine("\UiPath\Invoice_Recon\Email\Processing\File_Extract_Temp",String.Concat(“Sai_export - “,DateTime.Now.ToString(“yyyyMMdd-HHmmss”),”.xlsx”))

2. In the later part of the workflow i need to use the same file. But when i am referencing the same file with Path.Combine("\UiPath\Invoice_Recon\Email\Processing\File_Extract_Temp",String.Concat(“Sai_export - “,DateTime.Now.ToString(“yyyyMMdd-HHmmss”),”.xlsx”))

Error - The path

Can you please let me know how can i reference the same file in the workflow?

Thanks for the help,

Regards,
Sri

[Cameron_McMahon1 (Cam)]

Hello @srinivas_pradeep,

I believe the problem is that you’re still using the DateTime.Now.ToString(“yyyyMMdd-HHmmss”) - The time to the second has been written into the Filepath and can’t be referenced using the same syntax later on as the time will be different.

Consider writing the Path to a String variable before using it and passing this variable around to ensure you can constantly referenced it.

Best,

[ushu (Usha kiranmai)]

Hello @srinivas_pradeep

Please store this value in a variable

Variable of type string FilePath = Path.Combine("\UiPath\Invoice_Recon\Email\Processing\File_Extract_Temp",String.Concat(“Sai_export - “,DateTime.Now.ToString(“yyyyMMdd-HHmmss”),”.xlsx”))

In the later part of the workflow pass this variable

[srinivas_pradeep]

Hi @Cameron_McMahon1 ,
Thank you so much for the reply and help. Can you please help me with the syntax or example how can i do that please?

Sri

[srinivas_pradeep]

Hi @ushu ,

Thank you so much Do you mean something like this?

[ushu (Usha kiranmai)]

@srinivas_pradeep please remove Inv_extarct =

[Cameron_McMahon1 (Cam)]

Hi @srinivas_pradeep,

Before creating the excel file at the beginning of the code;

str_MyExcelPath = Path.Combine(“\UiPath\Invoice_Recon\Email\Processing\File_Extract_Temp”,String.Concat(“Sai_export - “,DateTime.Now.ToString(“yyyyMMdd-HHmmss”),”.xlsx”))

Then use this variable to open or interact with the excel at any point throughout your automation and it should then work!

Best,

[ushu (Usha kiranmai)]

@srinivas_pradeep Take assign activity

OuputFilePath (should be Before equals to) = Path.Combine("\UiPath\Invoice_Recon\Email\Processing\File_Extract_Temp",String.Concat(“Sai_export - “,DateTime.Now.ToString(“yyyyMMdd-HHmmss”),”.xlsx”))

[srinivas_pradeep]

Thank you @ushu . So this is the later part of the workflow where ia m referencing the same file. so instead of Path.combine is should give OutputFilePath?
Please let me know thanks

[ushu (Usha kiranmai)]

@srinivas_pradeep Correct. Instead of that complete path. Provide only that variable

[srinivas_pradeep]

Thank you @ushu So should i remove the assign activity in my first workflow sorry i am not getting it

[srinivas_pradeep]

it says the outputFilePath is not defined.

[ushu (Usha kiranmai)]

Please don’t remove it @srinivas_pradeep

The first part is for store the entire path in a variable. So that this variable have your file path and that can be used when you want to access that file instead of giving the entire path

[ushu (Usha kiranmai)]

Please make sure you define the variable @srinivas_pradeep

Try this, click on the first assign activity, navigate to the variables panel, and search for OutputFilePath variable. Click on the scope and change the scope to your workflow name

[srinivas_pradeep]

Thank you . It’s giving me only two options. which one to choose? the default was Sequence earlier.

[ushu (Usha kiranmai)]

Please choose BuildOutputFile @srinivas_pradeep

[ushu (Usha kiranmai)]

Let us know if you face any issues @srinivas_pradeep

[srinivas_pradeep]

@ushu thank you.
Ran into different problem now can you please help
now its not giving me any other option apart from sequence.

and then when i run the second part of workflow its giving me

[srinivas_pradeep]

if i use build output table as a option it gives following error

[ushu (Usha kiranmai)]

Can we quickly connect on this @srinivas_pradeep