Have .txt file (not a CSV) that contains employee data where each line is an employee and each field is delimited by a special character. This file gets regularly uploaded/reuploaded to a SharePoint library. I want to read the content and add each row/field to a Dataverse table.
What's the best way to go about doing this? I know I can get this to work in Power Automate by parsing the file content, but is there a better/cleaner way to do this? Would virtual tables or Dataflows be better/possible?

Report
All responses (
Answers (