Search code examples
excelsharepointpowerappspower-automate

Excel Power automate when any changes or additions

I really cant find how to automate this using power

  1. I have an excel file which contains a lot of rows
  2. The table has columns at row 1 filtered
  3. There are two columns C and D - i am interested if they are either "X" OR "Y"
  4. I need to get a notification if there are any modifications on the rows for the above criteria alone. All others should be ignored and no notification
  5. I also should get a notification if there is a new row with criteria mentioned in point 3.
Solution

  • Excel and PowerAutomate are not what you are looking for. This either requires a proper database, or something like a VBA macro to run your logics on every action.