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.

CodePudding user response：

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.