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

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
6 years ago

Hi @IsabellaChakur ,

 

According to your description, it seems that you could achieve your needs through two Flows.

 

a scheduled flow to occur once a week, whose action would be to turn on automated flow.

Use Recurrence as the trigger, trigger Flow every Monday, and use Enable Flow as Admin action to open the specified Flow.

 

An automated Flow, which would send a mail to client triggered by a powerbi alert.

After the Flow is triggered and the email is sent, the Flow is closed using Disable Flow as Admin action.

 

Best Regards,