Hello everyone,
I have a txt file. like this,
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
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.
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
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.
WarrenBelz
146,771
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,091
Most Valuable Professional