Read range and add data row errors

Help
, , ,
21

Can you post your workflow and let me know what you’re trying to filter? I think either the column specified is the wrong one or the text being filtered for is slightly different than what exists in the datatable.

23

Change the column number to 14. A datatable starts at index 0, so the column number is 1 less than what you might expect. It looks like the workflow will work with this small change.

24

This is the result i’m gettingSampl.xlsx (8.8 KB)

25

What are you typing into the input dialog that appears? Make sure it is not surrounded by quotes when you type it in.

26

i type the cell info to be searched for

27

Right, but I just want to verify the exact value you’re looking for. Trying to find where the process is failing.

28

I’m searching using IPPIS Number

29

I meant the value you enter when prompted. Are you entering PF0227283 for example?

30

yes i am

31

I tested the workflow you sent me before (with the column set to 14), and the workflow succeeded when I changed the sheet name from “Sheet1” to “Ba Wahala”. Can you send me the current workflow you’re using that’s giving you empty data? Also, can you provide a screenshot of the input dialog as you’re entering data? Highlight the data you’re entering as seen in the screenshot I’ve provided (checking for whitespace around the data).

image

32

iTS now working Thanks a lot

33

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.