Level 3 Assignment 2 - ReportFilePath is showing incorrect path

[Leela_Javvaji]

I am stuck with ReportfilePath which is navigating i.e. getting saved under incorrect path

ReportFilePath is given as path.Combine(Environment.CurrentDirectory,in_ReportsDownloadPath,“Report-” +in_TaxID+“-”+ in_Year.ToString + “-” + Month+“.csv”)

While Debugging observed that ReportFilePath value is becoming null and slashes are added in in_ReportsDownloadPath

Can someone help with Yearly Report Download workflow where I have missed

[AshwinS2 (Ashwin S)]

Hi @Leela_Javvaji

Check this

Generate Yearly Report For Vendor (cant find file path)

hello everyone, in the second assignment (performer) when the program download the report i get this error [Capture6] i fond that the file is saved in a deffrent name [Capture7] but when i run the program everything seems perfect, the program download the file with the right name and click save [Capture5] but when i go to the folder the file name is deffrent [Capture4] help me solve this please (is it ok to upload my work so you can see the program for your self ?)

Thanks
Ashwin S

[Leela_Javvaji]

Hi @AshwinS2

My issue is Path.Combine is not working when I checked individually. When I am using path.combine of environment.currentdirectory with other value then ReportFilePath actually not combining the value of current directory. Its getting saved in some other directory

[AshwinS2 (Ashwin S)]

Hi @Leela_Javvaji
Check this

Path.Combine error : 'path' is ambiguous

I restart but the same issue , I made a new Worflow file and in this Path it works. Thanks !

Thanks
Ashwin S

[Leela_Javvaji]

As said in the above, I restarted my workflow but still its same. And also to have trail version, I have written small steps to check path.combine working but its not. PFB

And I have system.IO namespace as well as stated in the above solution

[Leela_Javvaji]

Attaching my create yearly report workflow also. Please help to understand where I have missedSystem1_CreateYearlyReport.xaml (37.0 KB) Main.xaml (59.6 KB) Process.xaml (24.0 KB)

[Leela_Javvaji]

Can someone help me on this issue

[Abdulkader_Sandouka1 (Abdulkader Sandouka)]

hi @Leela_Javvaji
In type into activity enable Simulate Type
hope this will work
cheers

[Leela_Javvaji]

hi @Abdulkader_Sandouka1

I have tried with both the ways by checking and unchecking Simulate type but it didnt work

[Manish540 (Manish Shettigar)]

Use this below code and check,
path.Combine(Environment.CurrentDirectory,in_ReportsDownloadPath,“Yearly-Report”+in_Year+“-”+in_TaxID+“.xlsx”).

[Manish540 (Manish Shettigar)]

Send me your path which is you assigned to this variable,
“in_ReportsDownloadPath”?..
If any back slash is present at the end of the “in_ReportsDownloadPath”, remove that.

[Leela_Javvaji]

Slashes are added in in_ReportsDownloadPath. Not sure why its being added everytime and also path.combine is not combing the path of current direct directory with in_ReportsDownloadPath

[Manish540 (Manish Shettigar)]

Put single back slash every where in in_ReportsDownloadPath and try.

[Leela_Javvaji]

in_ReportsdownloadPath value is fetching from config file only as per my understanding.Please correct if I am wrong

and also why its not routing to current directory.

[Manish540 (Manish Shettigar)]

Remove end back slash and check if you get any error.

[Leela_Javvaji]

Hi @Manish540

Thank you very much. It worked now and its pasted correct value.
1 more small help . Merge Datatable is showing now Object reference not set to instance of an object

Source Datatable has value

[Manish540 (Manish Shettigar)]

How you created the “dt_YearlyReport” datatable in the workflow???..
Whether you created the “dt_YearlyReport” in the assign as,
“dt_YearlyReport = new Datatable”

[Leela_Javvaji]

Thanks alot @Manish540

It worked

[Manish540 (Manish Shettigar)]

Your Welcome
Happy Automation