Hi @gauravsolanke ,
I have created a sample flow. Please find the attached solution.
I have created the flow mainly for Setting up the status in the excel and to send email if all Application status are UP.
I am not actually check the application status.
Code:
Excel.LaunchExcel.LaunchAndOpenUnderExistingProcess Path: $'''C:\\Users\\OneDrive\\Desktop\\Power Automate Desktop\\Practice\\Input.xlsx''' Visible: True ReadOnly: False Instance=> ExcelInstance
Excel.ReadFromExcel.ReadAllCells Instance: ExcelInstance ReadAsText: False FirstLineIsHeader: True RangeValue=> ExcelData
SET RowValue TO 2
SET LastError TO $'''No Error'''
ERROR => LastError
IF LastError <> $'''No Error''' THEN
Excel.WriteToExcel.WriteCell Instance: ExcelInstance Value: $'''UP''' Column: $'''C''' Row: RowValue + 1
Variables.IncreaseVariable Value: RowValue IncrementValue: 1
SET LastError TO $'''No Error'''
ELSE
Excel.WriteToExcel.WriteCell Instance: ExcelInstance Value: $'''Down''' Column: $'''C''' Row: RowValue + 1
Variables.IncreaseVariable Value: RowValue IncrementValue: 1
SET LastError TO $'''No Error'''
END
Excel.ReadFromExcel.ReadAllCells Instance: ExcelInstance ReadAsText: False FirstLineIsHeader: True RangeValue=> ExcelData
SET Count TO 0
LOOP FOREACH CurrentItem IN ExcelData
IF CurrentItem['Health Check Status'] = $'''UP''' THEN
Variables.IncreaseVariable Value: Count IncrementValue: 1
ELSE
EXIT LOOP
END
END
Excel.CloseExcel.CloseAndSave Instance: ExcelInstance
IF ExcelData.RowsCount = Count THEN
Outlook.Launch Instance=> OutlookInstance
Outlook.SendEmailThroughOutlook.SendEmail Instance: OutlookInstance Account: $'''vishnureddy@gmail.com''' SendTo: $'''reddyvinay@gmail.com''' Subject: $'''Bot Summary''' Body: $'''Hi All,
Please Find the Bot Summary for the Day.
Regards,
BOT''' IsBodyHtml: False IsDraft: False Attachments: $'''C:\\Users\\OneDrive \\Desktop\\Power Automate Desktop\\Practice\\Input.xlsx'''
END
(Note:- if you got your solution you can mark as solution and gives kudos)
Thanks & Regards
Vishnu Reddy
