If statement for not empty cell Excel

(0) Share

Report

Posted on by yellow43

Hi Community,

Probably this problem is easy, but I can't figure out how to resolve it. Can you help me?

I have would like to optimize my flow as follows:

if a specific cell (excel) is not empty, apply some actions;
otherwise, continue flow

Thank you in advance!

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Deenuji_Loganathan_ 6,250 Moderator on at

Like (0)

Report
Copy link

Link copied!

@yellow43
Please follow the below proposed solution for the same. In the if condition I've mentioned the specific cell to validate.
Code:
Excel.LaunchExcel.LaunchAndOpenUnderExistingProcess Path: $'''C:\\Users\\Documents\\Holidays.xlsx''' Visible: True ReadOnly: False Instance=> ExcelInstance
Excel.ReadFromExcel.ReadAllCells Instance: ExcelInstance ReadAsText: False FirstLineIsHeader: True RangeValue=> ExcelData
IF IsEmpty(ExcelData[5][0]) THEN
Display.ShowMessageDialog.ShowMessage Title: $'''tet''' Message: $'''Apply some action''' Icon: Display.Icon.None Buttons: Display.Buttons.OK DefaultButton: Display.DefaultButton.Button1 IsTopMost: False ButtonPressed=> ButtonPressed
ELSE
Display.ShowMessageDialog.ShowMessage Title: $'''tet''' Message: $'''Continue other actions''' Icon: Display.Icon.None Buttons: Display.Buttons.OK DefaultButton: Display.DefaultButton.Button1 IsTopMost: False ButtonPressed=> ButtonPressed
END

-----------------------------------------------------------------------------------------------------------------------------
If I've resolved your query, please consider accepting it as the solution and giving it a thumbs up to help others find answers faster.

Was this reply helpful? Yes No
yellow43 22 on at

Like (0)

Report
Copy link

Link copied!

Thank You!
But if you want to iteract every row in a specific column?

Was this reply helpful? Yes No
Deenuji_Loganathan_ 6,250 Moderator on at

Like (0)

Report
Copy link

Link copied!

@yellow43
Included for each to iterate all the rows:

Code:

Excel.LaunchExcel.LaunchAndOpenUnderExistingProcess Path: $'''C:\\Users\\Documents\\Holidays.xlsx''' Visible: True ReadOnly: False Instance=> ExcelInstance
Excel.ReadFromExcel.ReadAllCells Instance: ExcelInstance ReadAsText: False FirstLineIsHeader: True RangeValue=> ExcelData
LOOP FOREACH CurrentItem IN ExcelData
IF IsEmpty(CurrentItem[0]) THEN
Display.ShowMessageDialog.ShowMessage Title: $'''tet''' Message: $'''Apply some action''' Icon: Display.Icon.None Buttons: Display.Buttons.OK DefaultButton: Display.DefaultButton.Button1 IsTopMost: False ButtonPressed=> ButtonPressed
ELSE
Display.ShowMessageDialog.ShowMessage Title: $'''tet''' Message: $'''Continue other actions''' Icon: Display.Icon.None Buttons: Display.Buttons.OK DefaultButton: Display.DefaultButton.Button1 IsTopMost: False ButtonPressed=> ButtonPressed
END
END

--------------------------------------------------------------------------------------------------------------
If I've resolved your query, please consider accepting it as the solution and giving it a thumbs up to help others find answers faster.

Was this reply helpful? Yes No