Read txt file and modify it via Power Automate

(0) Share

Report

Posted on by autoperfect93

Dear Power Automate Community,

I have a manual task which I perform every day at work and want to automate it via Power Automate.

Every day I generate a new .txt file via excel macro which includes FX deals inside. The excel macro is generating the .txt file and pasting it in a specified network folder. After that I open the file and amend 1 line and then save it.

Can Power Automate scan this folder and trigger a flow when a new .txt file is created by the macro and then modify that 1 line automatically every time?

I need general directions - can Power Automate read the file directly from the shared network folder. If not we can setup a PowerShell script to monitor the folder and send an email whenever new .txt file is created. This email will then be my trigger for the flow.

Any help will be highly appreciated!

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Michael E. Gernaey 53,960 Moderator on at

Like (1)

Report
Copy link

Link copied!

@autoperfect93

Hi, in general terms yes you can

1. Create an Automated flow, for anytime a file is created but the actions support SharePoint and OneDrive only. Not a network location as you are doing now. If you can instead save them to a OneDrive or SharePoint library then no issue.

2. Use Get File Content, to read the text
3. Use a Compose (or other method) to update the Text.
4. Then use Update File (for SharePoint or OneDrive)

If you like my answer, I would really appreciate if you please Mark it as Resolved, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
Hsiang 25 on at

Like (0)

Report
Copy link

Link copied!

you can check out the post here

How to manually make log.txt in Power Automate to trace log in a flow

Was this reply helpful? Yes No