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

Help Activities
, , ,
1

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.

2

@jibroni

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

3

Hi,

Hope the following helps you.

img20220228-1
img20220228-1599Ă—885 21 KB

Regards,

1 Like
4

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
5

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