Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
6 years ago
Solved

Building a flow with two flows in sequence

Hello,    I have a PowerBI Dashboard with daily alerts, as it is refreshed daily. I wanted the alerts to trigger a mail to clients, but once a week, not daily. So, I wanted to build two flows in se...
  • laura_gb's avatar
    laura_gb
    6 years ago

    If I understand correctly you only want a Power BI alert to be active oneday a week, Monday for example if the alert is triggered you want an email to be sent but if it is any other day of the week you don't want any actions to happen?

     

    If that is the case you can add the logic of only acting on a particular day in the flow triggered by the Power BI alert. First calculate which day of the week it is using the expression dayOfWeek(utcNow()). In my example I used Initialize Variable to save it in a Variable called weekday.

     

    Then I added a condition based on weekday value, 0 = Monday so my example only sends the email if it is a Monday. Rest of the week it does nothing.

     

    powerbiflowanswer.jpg

     

    Does that help? If so please mark this as the answer to help future Flow writers

     

    Regards

     

    Laura GB

laura_gb's avatar
laura_gb
Advocate I
6 years ago

If I understand correctly you only want a Power BI alert to be active oneday a week, Monday for example if the alert is triggered you want an email to be sent but if it is any other day of the week you don't want any actions to happen?

 

If that is the case you can add the logic of only acting on a particular day in the flow triggered by the Power BI alert. First calculate which day of the week it is using the expression dayOfWeek(utcNow()). In my example I used Initialize Variable to save it in a Variable called weekday.

 

Then I added a condition based on weekday value, 0 = Monday so my example only sends the email if it is a Monday. Rest of the week it does nothing.

 

powerbiflowanswer.jpg

 

Does that help? If so please mark this as the answer to help future Flow writers

 

Regards

 

Laura GB