Hi Aanand Madhav,
In addition to S.Sengupta response, am mentioning few workaround
If you're sending large CSV file attachments (20–30MB) via Azure Logic Apps on an hourly basis, you may face attachment size limitations depending on the email connector you use. The Office 365 Outlook Connector has a 3MB per file and 10MB per email limit, making it unsuitable for large attachments. The SendGrid Connector allows up to 30MB per email (on paid plans), while an SMTP Connector depends on the configured mail server (e.g., Exchange Online supports up to 35MB attachments). Since your files are within the 20–30MB range, SendGrid is a viable option.
To use SendGrid, you first need to create a SendGrid account in Azure Portal. Search for "SendGrid," create an Email API account, and choose a paid plan (as free-tier has limitations). After verifying your Sender Identity, generate an API Key under "Settings > API Keys." Then, configure SendGrid in Logic Apps by adding the "Send an email (V4) - SendGrid" action, authenticating with your API Key, and filling in the required email details such as recipient, subject, body, and attachment reference.
If your CSV files exceed 30MB, you should consider splitting them into smaller files using an Azure Function or a Logic Apps "Split CSV" action. This ensures the files remain within SendGrid’s limit. However, a better approach is to upload the files to Azure Blob Storage and send a download link instead of an attachment. To implement this, first upload the CSV file to an Azure Storage Account and generate a Shared Access Signature (SAS) URL using the "Create SAS token" action in Logic Apps. Then, modify your email body to include the SAS URL as a clickable download link instead of an attachment.
if your attachment size is ≤30MB, SendGrid is the best option. For files larger than 30MB, storing them in Azure Blob Storage and sharing a link is more reliable, avoiding email provider limitations.
https://learn.microsoft.com/en-us/connectors/sendgrid/
If you have any further assistant, do let me know.