Hello to everyone,
| Column name 1 | Column name 2 | Column name 3 |
| T1 | 1/07/2024 | alexxxxxxxxx1@gmail.com |
| T2 | N/A | alexxxxxxxxx2@gmail.com |
| T3 | N/A | alexxxxxxxxx3@gmail.com |
I have the above excel file and I am trying to open it on PA desktop and if the column name 2 is N/A to send an email to the users on column name 3 with their tasks (Column name 3).
My issue is with the syntax of if statement below:
Excel.LaunchExcel.LaunchAndOpenUnderExistingProcess Path: $fx'C:\\Users\\axxxxxxxx\\Documents\\Book1.xlsx' Visible: True ReadOnly: False Instance=> ExcelInstance
Excel.ReadFromExcel.ReadAllCells Instance: $fx'=ExcelInstance' ReadAsText: False FirstLineIsHeader: True RangeValue=> ExcelData
LOOP FOREACH CurrentItem IN $fx'=ExcelData'
IF $fx'=CurrentItem["Column name 2"] is equal to "N/A"' THEN
END
END
Can anyone help me with the if statement syntax?
