How to filter excel file in if-statement

[supermanPunch (Arpan)]

@lope_0238

I would now like to build a function that first checks whether today’s date combined with the status “Order executed” is already in the file.

Hi @lope_0238 ,

Could you check with the below Expression :

DT.AsEnumerable.Any(Function(x)CDate(x("date").ToString) = Now andAlso x("status").ToString.Equals("Order executed"))

Here, DT is the datatable which contains your sheet data.

The above Expression could be directly used in an If Activity as you are just checking for existence of values.

Let us know if you are receiving any errors.