How to Read Column in Excel Please help

[punnipah]

Hi,

i want to Read Columns in Excel and Read Date Only Please help

-no empty values
-Select Date only
This my Flow and Excelfile

[Gokul001 (Gokul Balaji)]

Hi @punnipah

Inside the For each activity.

Use if activity

Not String.IsNullOrEmpty(currentitem)

Then - use log message activity it will print the date

Regards
Gokul

[sreejith.ss]

Inside the loop use if condition and in the condition give currentrow(0).tostring.length>0
if length >0 then do your needful process

Regards

Sreejith S S

[punnipah]

Not working

[Gokul001 (Gokul Balaji)]

Hi @punnipah

Try with is expression in the if activity

System.Text.RegularExpressions.Regex.IsMatch(currentitem,"\b\d{2}\W\d{2}\W\d{4}\b")

Regards
Gokul

[punnipah]

Thank you very much ^^

[punnipah]

@Gokul001

Not String.IsNullOrEmpty(currentitem)

So sorry i try it again not working