Power Automate is impacting my IF functions by inserting new rows. Each IF function reads a separate row( I.e Tab 1 Cell M7 is read by a IF function on Tab 2 Cell M7). When power automate imports new Microsoft forum data entries, it inserts a row rather than “writing over.” This then throws off all corresponding IF functions in Tab 2. How can I fix this?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Power Automate Creating new rows affecting IF functions that read individual rows. Is there a way to fix this? Offset + If?
- Thread starter Wgunzen
- Start date
-
- Tags
- offset power automate
