Convert a .txt file to a SharePoint list

(0) Share

Report

Posted on by MatildeBecherel

Hello everyone,
I have a txt file. like this,

Immagine 2023-08-03 113905.png

I would like to convert it to a SharePoint list, where the columns correspond to the letters in the .txt file, with Power Automate.

Thank you if anyone can help me

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

SamLed 2,338 Moderator on at

Like (1)

Report

Hi,
Your text file can be treat as CSV file using pipe as separaror char.

Have a look to this article which shows how to consume CSV file and build JSON : https://www.tachytelic.net/2021/02/power-automate-parse-csv/?amp

Just replace coma by pipe in the split line expression.

Then you just have to use Create item action assigning correct value to related field.

You don't have to transform your extrated data to JSON, but it is more readable than array indexes and field will be available in dynamic contents.
______________________________________________________________
If I have answered your question, please Accept the post as solution.
If you like my response, please Thumbs Up.

Was this reply helpful? Yes No
MatildeBecherel 37 on at

Like (0)

Report

Thanks for the reply but this doesn't work for me because the .txt file comes to me by email and with power automate I download it directly into a folder

Was this reply helpful? Yes No
SamLed 2,338 Moderator on at

Like (0)

Report

You just have to adapt the way you get file, in article it comes from OneDrive, but you can obviously get a file from mail attachment, a sharepoint library or a folder. How to process the file doesn't change except for field separator which is "|" in your case.

[Edit] you can also deal with file content just before you save it into a folder.
______________________________________________________________
If I have answered your question, please Accept the post as solution.
If you like my response, please Thumbs Up.

Was this reply helpful? Yes No