Text file to Dataverse

(0) Share

Report

Posted on by kts_dev

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?

Categories:

Microsoft Dataverse

All responses (1)

Answers (1)

Verified answer

AhmedSalih

6,678 Super User 2025 Season 1 on at

Like (0)

Report

Re: Text file to Dataverse

Hello, @kts_dev , you use DataFlows for your use case:

Check out this tutorial for how to accomplish this: https://msolenacrm.blog/2021/01/04/dataflows-for-power-apps-transform-fixed-width-text-files/

If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com