Last row with input in H:H to input Expression for Switch

Hello All,
Every time I think I am doing it correctly, I get more and more errors. I used chatgpt-4 even for days to try and fix the errors. I am lost. I need to get the input from the last row in column H to dictate which workflow to execute.

Hi @Michael_Chletsos

If I understand well, you need to get the last value present in a specific column within your excel file, if so you can use the following query to return the value

dt1.AsEnumerable.Select(Function(r) r("yourColumnNameOrIndex").ToString()).ToArray().Last()

if this is not your query then please explain with example to better support

Regards!

Hi,

FindFirst/LastDataRow activity may help you.

Sample
Sample20240105-2.zip (8.6 KB)

Regards,