Write Text File: Value cannot be null. Parameter name: source

Help Studio
1

String.Join(Environment.NewLine, dt.AsEnumerable().select(function() ((“SAP Code”).toString)).ToList)

image
image955×321 88 KB

2

for a flatten string we would do like below:

String.Join(Environment.NewLine, dt.AsEnumerable().select(function(x) x("SAP Code").toString).ToList)
3

image
image924×245 96.4 KB

image
image700×217 53.9 KB

i did it this way but i’m still getting the e

4

had verified the code against a sample datatable and was working

grafik
grafik691×195 3.41 KB

can you please check following

  • set a breakpoint on the write text file
  • debug and get paused
  • write within the immediate panel following statements:
dt

so we can check the datatable

then type in:

String.Join(Environment.NewLine, dt.AsEnumerable().select(function(x) x("SAP Code").toString).ToList)
5

It’s not finding any data so the file it tries to write is empty, which causes the error.

6

Hi @pauloengenharia5 ,

Could you check if dt contains any values in the Locals/Immediate Panel?
Either you have read the table into another variable, or the workbook doesn’t contain any data.

Kind Regards,
Ashwin A.K

7

Hello @pauloengenharia5

Hope “dt” is your datatable variable?

You need to check whether the datatable is having some value and it has the header “SAP Code”.

Thanks

8

Hi @pauloengenharia5

Check that your parameter are assigned correctly. (Don’t pass the Null value)

Can you provide us an sample input?

Regards
Gokul

9

this is my workflow

Test.xaml (24.5 KB)

10

Your expression is returning no data, so the Write Text File activity faults with error “value cannot be null”

11

Share the sample input not the XAML file. @pauloengenharia5

12

image
image885×346 80.6 KB

image
image777×345 56.7 KB

image
image928×362 73.8 KB

13

As it clearly says, your expression is null. It doesn’t return any data. Write Text File can’t write an empty file.