MicrosoftThis was a good write-up and explains some of the pain points I am having. Rules are so generic and I need the ability to know when things change for a specific View where new items appears in that view or items are no longer assigned to that view. The PowerAutomate to do so is extremely complex. Also, it does not allow for the weekly summary because it needs to be triggered on "When an item is changed or modified." I have 30 flows that send weekly summaries based on the view changes. Not sure how to get around this now.
I here you on this! As I was reading your message, a thought came to mind. Are any of those views based on the value in a particular column? If the view is filtered on only 1 column then could you create a rule that notifies you when an item with a certain value in a certain column is added? This could be an interesting test.
This was an interesting thought and I was trying to think if this could work. Part of the issue is that my list currently has 20 views for which there are about 40 alerts. Each view has 2 people assigned to get the alerts when items are either added to their view or removed from their view. For example, I have a view called "My Team" and the view filters based on a column called "My Team". When a new item is added through a MS Form and PowerAutomate flow, if the value is Yes that sends and alert. If an item is modified and that value is changed to No, that also sends an alert. In this scenario, I would need to have an alert for create and then an alert for the change, is that right? And there would be no weekly summary, so the alerts would be automatic. But, I would be over the 15 rule limit, too, so that is a problem. If you think this could, please let me know and I will test. :)
