For Each Row: Object reference not set to an instance of an object. error

Anyone help me to resolve this error?

Hi
May be your datatable must be declare as New DataTable() ?

Hi,
Thanks for reply me Main.xaml (794.0 KB)

For your references

did not find where newdata3 takes value
Try in Variable in Default to specify “New System.Data.DataTable” on newdata3

Hi Aleksey,
I changed default in data table but I get this error

0e88def1bb7ca2e518c217001c8b2000 001a1fe632a64b8ab276d55c39a398f6 1d1606bff101b3d8f4d245fb0559a750 1e30bf84a96a4da1d53a93b9765d0a27 1eb6c7093ddc52b0793cb5f1225ea54d 2bd62b72f860d02e67774f4b90a9162d 2de4f9950abc42e74087abb0f630fdbf 2eed48dd7e857b6d86be324cfbf1612d 3d36fa63ee87f51915aa09a7ae3cc203 4b4345fdae392dd51d833d1654253089 4f8ae5fbb702160100ce3fae223feacd 5ee47e02995b6b70d5905da1089e5197 6e0a35eb0bc4122d07869cb7327b412e 6e2f96f879ea6df3d94c0e0121cf2726 6f224a7cda809dae99dedef5cf6d4958 7e8872b2558a35b1962f721d83d5d54d 8b504475e8f554266e2fefe01d73f15c 8c9063b47d1973a2441297c52f672a34 8c70648aa226eeb4d22d30cc92a32fc7 8cd1ebbe9fb1f653d7e64da2dc955bf4 9d6f15ccf5e03b7f2ca15b074e62df32 13e640fd36e813d4e30c5b2a8e07c76b 16d54ff0cfc8abf8b8bbdbc2e32c7f8b 20f9fba161d1835ac7455286e08dfb26 20fb7d4c789b2e95e9865e4c8a15d9c2 36e859e0b8778610f7c8e92b436b3fef 36f11b497356cfc435a3bd06682b5aa4 57d87b6e31e6d0c9ad9a88b191e288bc 58d617bf51395c618471694cdf17f7fa 58e4e5e0372b13066f00af4c33b7331d 61cb8ada31f0a5e2245a6d0516905500 61dd847837627bd66a38237f4ff2a88f 75af7e5b83c3fe6b0e338a218af01135 75fe3142fe7f70bcb56c5bb7dc84ba9f 85c26b4258c388ca47f8da71c92c0afe 90fade5ff55a2fb69eb82f3320c6d79d 96e5283f7d37914d6d73c3bf25087f6e 96ffed0177c3c02abf825c2530a3a58b 112f714bde65ef733b274d4f937f0cce 215b1cb46e8699a45143e0969d501266 217e6a914ee075b2ef40d6953f6da538 424fa9e067f1c627010e0e81df2fcea0 470d2df90c980e0ba1ea6f5b8927e0ad 520f58cc587b8e8b2b912b17a3083111 525d727c19a3ac2b2f9f70b7418b09de 528d66dda4c3b706aa07eecac128705c 568e1e15450ae96edc3832766feed9ac 0570f16d6b1ce2d70a0a5f5605b089db 682c7ed126f96786a5312cedc3c3f62e 699fac9d8cac9519284cf87acc75993a 719f40e30af0a4f78d55acd7003f137c 892d50e4fedd0c1570e8fa891bfd1d9c 914e38c75e29dd81f0a6e4be0772a9a8 937a5a28057381b59f82d969a15ccb12 1273e237b270cff745eba182e0e4907b 1919c9dbd9e2782ae3e4e06a41bf4fcc 2035a6fea0dd8ad29632bf5c705821c7 2178e88f10c6ff29e2fb8c1328c9385f 2465b96719ffce91d46ed7d40c5ed308 4171fb5b8f1d30e7454051bf4a231a08 8451d86d9caede3fcf9ca599a8f4dc72 26976ae727b745b5af15a5aa85ee61de 58115e5ccfed8606e7c10e9144d9506b 98032ccfc8f482894d866eb3f551b09d 115314f00813b3f73b522fcda56a1af2 0598289b542fc15058418b317eeac34e 934653d4406258aef18c4b6466a28c5b 990100eaf74fcd40dd697b78090135be 4501057abbd86004cfdcb3950c3055e4 05413777fb4b57dc60f1e5af7d737fb5 6461400a27a68db91f87ba4c73cb9125 95949891dbdc8b9544bf144001e2f84a 8614173824a8dd644eca7dd6358d7e7d a2d2bfd7057ad5153772d6a6c8d25237 a3b5c9127655691fc78785db774ab097 a6e852f0ce90f2b41d4e2a510f3a507e a737f0e8e82d7c899a4602a1aa3b6553 a913aab4c5d960cbde3d8bab5cf920da aa1a86753319951315a09d830a05fbf9 ad368c74d344d3f79d05e7e97cd312bd af0da3e1004b5a1a56b31d112cb0d70f b4b5049b5166c8c17361839bc3704c29 b6f5fdc94bdf6be0c94dfdf9f4c89b6e b15c0be331ad74fe53779ab70295f874 b67cfb781aa7ccf0ad3622035737ecbb b398f0c18a6005b795a8f6b789384f15 bdad4ec78253e17b9aea54e395c6a8aa c24c5e9089ed8e3e0473dee270e9e263 cc650a4fd8ef6775f19a7b852410228c cf153e3eb62a2fa4c032fb50c5c58892 d3aba8e35898725469af1d529c893cff d8abf14a1723c32aa70606f7e89c371f d374c4d051ad88d46c56f65090ca7f13 db6f551267d1570ddb5407cf69169e1d dd70604c3f25b2a6705c2cf9ef17583c ddd2cfb6e11d05880c8c64fc7787b24d e4f4e65c1ecaff059fcfd9295773c769 e6e26fa155d62e6d29ae65645babaac3 e9bf36b0e8bb3e0a860617e9744f6d08 e83f23d3ea5c84d83ea3f0ae5d9ab3f7 e5581fa25521276061df256062057da9 e9729c1d52cd1a9c504d135e4dedd1c8 e94175b25d265b8696f71b059e40c9ca ea906b4df1363e20f5d605c6986237bd eb48a4e1bcdb3f3732cb9308ee04b4d1 eeacff02bd0f727619cb093d65956324 f9e36108f4cba0849d13a0e09a665339 f4685cb9bac9f0c4fd0b5f3fbd7e0735 f8824e0bc610732b0e15867a25453e41 fb961293c37ec90180bb7a5c2879735d fda7bbc4522157fdcacf440397e11c4a

Hi
What is written here? What error ?

Hi Aleksey,
Please find my workflowFlowchart.xaml (154.8 KB)
And Excel Sheet
SAPLEVEL3.xlsx (10.7 KB)

And where is the error?

Please check my updated one Flowchart.xaml (248.4 KB)

I already change it that data table name. but I can’t get null value from the excel sheet

Please check my if condition right or wrong?

I get this error

I do not see where the variable ACTION takes value in last Flowchart.xaml
ACTION is null

please check it variable name is ActionColumn GenericValue

And this variables ?

Use WriteLine for debug values of your variables

1 Like

okay @Aleksey_M it’s very helpful for me.
but I want answer in excel sheet column M and N.