![]() ![]() Now I want to iterate through the attachments in the email. To help with this I need to create 3 variables Contact Name, Forename and Surname.ĥ. Later on in the Flow I want to do some string manipulation on the contact name so that it is formatted nicely in the SharePoint list. This way the Flow won’t be firing for all emails coming in!Ĥ. Make sure ‘Has Attachment’ and ‘Include Attachments’ are set to ‘Yes’ and the ‘Subject Filter’ is set to ‘CSV’. In this example, I am responding to emails arriving in my Inbox, but it could just as well respond to a specific folder or mailbox. Give the Flow a meaningful name and select ‘When a new email arrives (V3)’ as the trigger action. Launch Power Automate – and create a new ‘ Automated flow–from blank‘Ģ. OK, now we know what the CSV looks like and we have somewhere to store the data, let’s get onto the good bit and build the Flow!ġ. I’ve created a SharePoint list to store the output, at the moment it contains only fields mapped to those in the CSV file but it could be augmented with further fields to track client contact forming the start of a basic CRM solution. Rather unhelpfully they have provided generic column names in their extract, fortunately, the Encodian action can handle this scenario! The CSV data provided by our Marketing Agency is basic, it contains 5 columns contact name, company name, email address, telephone number and job title. To accomplish this I will use standard Microsoft Power Automate actions and the Encodian Parse CSV action to read the CSV and add the items to the SharePoint list. I want to parse the data and populate a SharePoint list where our internal Marketing team can easily consume, manipulate and action it. In this fictional scenario, our company purchases marketing data from a 3rd party agency who distribute it to us via email. In this blog post, I want to showcase a “no-code” solution for parsing CSV data before populating a SharePoint list using Microsoft Power Automate. Lots of software products often have the ability to extract data in a CSV format for consumption by other solutions, this provides a low-cost integration point between systems. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |