Hello everyone, Im totally new here, so sorry if wrongly asked question, or wrong place to ask.
But im kinda stuck, for quite a while, and I cant really figure out what is the problem.
The instructor in the video is using some older version of Studio, so that already caused some issues even in the previous lessons, but I was able to solve them. BUT Im following each step EXACTLY like him, but I get errors.
Right now Im on the step where I add If statement, and then create the email draft.
I had everything working before I added IF statement. The invoices got downloaded, checked for discount eligiblity, wrote the discount in the invoice and it was saved, except that one invoice where there was no discount and it caused invalid VALUE in the excel sheet.
Thats why we are adding the IF statement, I understand, but since I did that, everything is broken, even getting the discount values, it seems like its doing it too fast, and it only gets one, and it applies all the same value to all the invoices.
So this is the first problem I am facing.
before I was also getting Write Cell: Object reference not set to an instance of an object, sometimes on THEN statement, sometimes on ELSE. but I did not change anything, just ran it in DEBUG mode, and now it worked, but with the above mentioned issue, that it only writes one value to all invoices, be it 0, or 125, but one value is applied to all.
And the last problem is is with the SEND EMAIL activity, it doesnt have access to the invoices folder? Why would that be? Any ideas please?
Would someone be willing to have a look at my Process? I Would be very grateful, thank you!