Answered

parse .txt files contents and populate to list automatically

(0) Share

Report

Posted on by Veblitz

2,249

We already created automated cloud flow to migrate data from on-premise data gateway (shared network source folder which contains .txt files) to destination office365 document library.

As a next step, We need to parse .txt file contents and populate this list automatically. or can we parse in above power automate which we use for copying files to document library, am not sure how to parse txt files into SharePoint list.please consider below sample and pls help

.text file (sample values below format)

"Software/SAP Ram/hardware cab ",1234,"ssa (111/ss)",0

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

v-bofeng-msft on at

Like (1)

Report

Hi @Veblitz ,

I've made a test for your reference:

1\I assume there is a .txt file.

2\My SP list

3\My Flow

4\Result

Best Regards,

Bof

Was this reply helpful? Yes No
Veblitz 2,249 on at

Like (0)

Report

Fantastic,much appreciated.

Here is scenario, in my document library(office365), everyday files are getting copied in txt formats,below 5 types of txt files are getting copied in daily basis
Suppliers.txt
Stores.txt
Customers.txt
Locations.txt
Process.txt

So in this way how to populate and parse the text files data to list as they are different data from different txt files and in the same Document library these 5 files getting copied and we used another Power Automate for onpremise shared folder to copy files to this document library. So my question is how to automatically parse txt files for these 5 txt files and populate into 5 different lists in this context.

Kindly advice.

Was this reply helpful? Yes No
Veblitz 2,249 on at

Like (0)

Report

Kindly shed some light for making this to work dynamically for txt files when different files were copied on daily basis. As mentioned above 5 txt files will get copied in documents library and we need to parse in list for similar files daily basis . I hope there will be 5 different list in this case but we need to get from same documents library on daily basis

Was this reply helpful? Yes No
Veblitz 2,249 on at

Like (0)

Report

I greatly appreciate if any help and inputs

Was this reply helpful? Yes No