Power Platform Community Forum Thread Details

Hi Techiez,

I need help creating a flow that transfers CSV data from email attachments to a SQL database whenever an email is received on a weekly basis.

thanks-Deepan.

Categories:

Hi,

Trigger: When a new email with attachments arrives in Outlook.
Get Attachments: Use the "Get attachments" action to retrieve all attachments from the email.
Loop through attachments: Use a "Apply to each" action to iterate through each attachment.
Get attachment content: Use the "Get attachment content" action to get the content of the current attachment.
Convert to Base64 (if needed): Use the "Convert to Base64" action to encode the binary content of the attachment.
Connect to SQL: Use the "Open SQL connection" action to connect to your SQL Server database.
Construct SQL query: Create an INSERT statement to add the attachment data to your SQL table:

Code

    INSERT INTO YourTableName (AttachmentName, AttachmentData) VALUES ('[AttachmentName]', '[AttachmentData]');

1. Execute SQL statement:

Use the "Execute SQL statement" action to run the INSERT statement. Replace [AttachmentName] with the name of the attachment and [AttachmentData] with the base64 encoded data.
2. Close SQL connection:

Use the "Close SQL connection" action to close the connection to your database.

Data Types:

Ensure that the data types in your SQL table are compatible with the attachment data you are inserting (e.g., VARBINARY for binary data, NVARCHAR for text-based data, etc.).

If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.
Regards,
Riyaz