IF Activity - If any cells in column with value FALSE then show Message Box

I want to add an IF activity into my StudioX flow which will show user a Message Box if the value of any cells in Column E are FALSE. The spreadsheet changes every time. Sometimes all cell values are TRUE, other times there are numerous FALSE. The column containing the values is always column E. How can I do this? Please let me know if you need more information.


Try below steps

  1. Read Range - Output - DT (datatable).

  2. For Each Row - Iterarte Over DT

  3. If(row(“Column E”).ToString = “False”)
    Then - Message Box with message


Hope the following helps you.


1 Like

Thanks @Yoichi, that is exactly what I was looking for. You just made this newbie’s day!

Also, congrats on your 2022 MVP award, that’s awesome!

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.