cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Administrator
Administrator

PBI X Email alerts x Flow

Hi everyone,

 

 

I'm trying to create alerts to send to my manager the tasks that are running late. So, basically, I need to send him a email alert with all the tasks that are due one day before they actually end.

 

So, for instance, if there are 3 tasks below 100% and they are due tomorrow (10/17), PBI will send him an email with these 3 tasks. But since I have over 200 tasks, I did not want to use KPI cards to generate thoses alerts, I mean I don't want to create 200 cards for this, and also because, each year the tasks are prolly gonna be different.

Therefore, can anyone give me a suggestion on how I should proceed to get a more automated and better solution?

 

 

Thank you!

2 ACCEPTED SOLUTIONS

Accepted Solutions
Seth_C_Bauer
Level: Power Up

Re: PBI X Email alerts x Flow

@IsadoraAlmeida6 I would do it this way.

1) Create a Report page that dynamically determines which tasks are running late.

2) Create a Card to count the number of tasks

3) Pin the Card to a dashboard

3) Create an alert that will trigger if >1

4) Boss logs in, clicks on the tile and sees the list which will vary/change/etc.

 

This also gives you the flexibility to add additional information on the report, modify things etc, without reseting the alert, etc.

View solution in original post

Seth_C_Bauer
Level: Power Up

Re: PBI X Email alerts x Flow

@IsadoraAlmeida6 You might be able to use Microsoft Flow here... I believe you could accomplish what you want via that method.

View solution in original post

4 REPLIES 4
Seth_C_Bauer
Level: Power Up

Re: PBI X Email alerts x Flow

@IsadoraAlmeida6 I would do it this way.

1) Create a Report page that dynamically determines which tasks are running late.

2) Create a Card to count the number of tasks

3) Pin the Card to a dashboard

3) Create an alert that will trigger if >1

4) Boss logs in, clicks on the tile and sees the list which will vary/change/etc.

 

This also gives you the flexibility to add additional information on the report, modify things etc, without reseting the alert, etc.

View solution in original post

Administrator
Administrator

Re: PBI X Email alerts x Flow

Hi @Seth_C_Bauer, thanks for you answer.

I already created a calculated column to check if a task is running late, but the manager wants to get an email with thoses tasks, and not log in into PBI to see which tasks are late Smiley Sad

Seth_C_Bauer
Level: Power Up

Re: PBI X Email alerts x Flow

@IsadoraAlmeida6 You might be able to use Microsoft Flow here... I believe you could accomplish what you want via that method.

View solution in original post

Administrator
Administrator

Re: PBI X Email alerts x Flow

It is possible, Mr @Seth_C_Bauer. But, unfortunately, not for my scneario, because the company would have to invest on Flow Premiun, since the database we use doesn't have a free connector on Flow. Anyways, I think I've created the best solution I could find under PBI current limitations, now I just have to present and explain those limitations regarding automation in PBI. 

Helpful resources

Announcements
firstImage

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors
Users online (5,473)