sharepointpower-automatemailing-list

MS Flow Populate a SharePoint List from TXT File


I have a txt file, in OneDrive, with email addresses each on a newline with a header on the 1st line. txt file

I want to populate a 1 column SharePoint list with the email addresses.

Here is my list and flow so far: sharepoint list

flow so far

Which actions do I need to add?


Solution

  • My test flow for your reference:

    enter image description here enter image description here enter image description here Notes:This will insert an extra '\r' into the column, which can't be seen on the page, but it will be in the actual storage.

    enter image description here

    enter image description here