You’re offline. This is a read only version of the page.
Announcements
19
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?
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
|
Share
Report
All responses (
Answers (
