Flows/Automation Issue Attaching File, Sending Email

Q&A
,
1

Hi, I have an agent that generates a security metrics report. I’ve created a flow / automation to prompt that agent to generate that report on a monthly basis, then attach the report to an email and send it to designated emails. The agent prompt step performs well, but the automation is unable to attach the agent-generated file to the email [issue #1]. The draft email step partially performs (it generates the requested subject and body). Despite issue #1, the automation offers to send the email without the file, which I accepted, but the email never sends despite the automation showing that it has [issue #2]. I have Outlook configured as a connector. Any guidance on what may be going wrong here is much appreciated!

2

Hi @amyread

Welcome to the QuickSight community!

Issue #1:
The Chat Agent step in Amazon Quick Flows is designed primarily to generate text‑based outputs that can be referenced in subsequent workflow steps. However, passing a file generated by the agent directly as an attachment to an Application Action step (such as Outlook’s Send Email) may not be supported in the Flows pipeline. The handoff between the agent’s file output and the email connector’s attachment field currently has limitations.

Workaround: If the security metrics report can be generated as a standard dashboard export, we recommend using QuickSight’s native Scheduled Report Delivery feature, which natively supports PDF and CSV attachments on a recurring schedule (daily, weekly, monthly, or yearly).

Issue #2:
Sending emails is a supported action for the Microsoft Outlook connector. However, the behavior you’re seeing, where the Flow marks the email step as completed but the message never arrives is consistent with reports from other customers using the Outlook connector in Flows. In certain configurations, actions such as sending emails through connectors may require a manual approval or review step before they are executed, even though the Flow indicates the step has completed.

To troubleshoot, we recommend:

  • Checking for any pending action reviews in the Quick Flows interface that may be holding the email.
  • Verifying your Outlook connector authentication is using Service-to-Service OAuth (application permissions) if you intend for emails to send without interactive user approval. Delegated permission flows may require user interaction for each send action.
  • Confirming the Mail.Send permission is granted and admin-consented in your Microsoft Entra app registration.
3

Hi @amyread

It’s been a while since we last heard from you. If you have any further questions, please let us know how we can assist you.

If we don’t hear back within the next 3 business days, we’ll proceed with close/archive this topic.

Thank you!

4

Hi @amyread

Since we have not heard back from you, I’ll go ahead and close/archive this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information.

Thank you!