You’re offline. This is a read only version of the page.
35
Hi,
I cant find any comment mentioning "How to load Read txt file to Database in Power Automate Desktop". I know comments are there in Power Automate, however i need PAD only
Regards,
Abhishek
Hi @abhishja ,
To read a text file in Power Automate Desktop, refer to the File action here
You can then save the output to a list and loop through each row.
Depending on your requirement, you can then execute an Insert statement within each loop to write multiple rows or at the end to store it as a single row.
Be careful of special characters in your text file which may break you SQL statements. You will need to ensure characters such as ' are escaped.
Share
Report
All responses (
Answers (
