Building a flow with two flows in sequence

[Syndicate_Admin]

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 sequence: a scheduled flow to occur once a week, whose action would be to turn on another flow, an automated one, which would send a mail to client triggered by a powerbi alert. At the end of the day, I would create another Scheduled flow to turn off the Automated flow. Can you help me to find these options?

Thank you in advance

[Syndicate_Admin]

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,

[laura_gb · Accepted solution]

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.

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

Regards

Laura GB

[Syndicate_Admin]

Hi @LauraGB ,

It seems that Monday should be represented by 1.

https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#d...

Best Regards,