I’m try to create a dynamic file name, when I try to pass the following inside the write range activity “Techno Invoices"+CustomerName+”_“+InvoiceNo+”.xlsx", it throws an error that the given paths format is not supported. Where have I missed the point?
@Nkrumah_Dubazana - my point is there is some illegal character coming from a dynamic variable like etc ( , ’ @ etc etc ) …which is stopping you from creating the folder path …
Try removing a dynamic variable and hardcode the value and try…by this way you can find out which variable is culprit …
What @prasath17 is said correct some times you will get null also on that time you will get this message I also fetch this you just put the write line activity before write cell on that time you will get to know what’s Happen
I have placed the “write line” activity like you suggested, just before the “write cell” activity, but the error still persists, and no result was displayed in the output. I have attached the workflow, if you may could you kindly take your time and have a look at it, run your diagnosis, and check it out.
Thank you so much for your devoted time to my situation and for your gentle advice. I will look through at the material you shared, to further improve my learning experience.