Advice Please - strip data from CSV and place into email body

[StevenHarrison]

Hi All - we have an email that contains a csv extract of maintenance jobs logged by our tenants on a daily basis, can you give me any advice on how I would:

1. Get the data out of the csv file
2. then place it into the body of an email
3. to then be emailed to our Customer service team

Sometimes these csv files may not contain any data, as no jobs have been logged on our housing system, but the Customer Services Team need to see at a glance if any have, hence the requirement to have the data in the body of the email, also in a table format and possibly if there are no jobs logged, perhaps a message to say that.

The data currently gets emailed from an SQL reporting services subscription that queries the housing system.

Thank you in advance for any thoughts/advice.

[AWorley · Accepted solution]

Hi! I do not believe that you are able to parse out attachments as they must be downloaded before they are decrypted. Exporting the "Get Attachments" spits out encrypted values or random strings. 

You may be able to save the document from the attachment then parse the data; here is a built in template given by Microsoft to copy attachments. 

Save my email attachments to a SharePoint document library | Microsoft Power Automate

[StevenHarrison]

Thanks @AWorley