Email notification without Alerts

[Anonymous]

Hi, 

I have projects that go from stage 1 to stage 2 to stage 3. I have a report where users can attach comments to the project IDs to add context to any difficulties during each stage. The comments are submitted using a Power Apps integration and the comments are then inserted to the project ID tabel, so that comments from stage 1 can be shown on a card visual for stage 2. 

Sometimes the users forget to submit these comments and I would like to set up notifications to remind them when a project ID moves from one stage to the next without a comment.

Is it possible to create a notification service in Power BI or Power Automate that notifies a user if a project ID goes from one stage to the next with a blank comment value? 

Any help is much appreciated! 

[GilbertQ · Accepted solution]

HI @Anonymous 

What you could do is to create a measure which counts the number of comments for the Project ID in each stage. Then if the count is zero fire off an alert that there are no comments?