web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Looping through Get Fi...

Power Automate

Answered

Looping through Get File Content

(0) Share

Report

Report

Posted on by PranavPh

12

Hi,

I'm reading a text file through Get File content. Is it possible to read each line and search for the keyword ERROR. ?

I want to build a loop where it reads line by line and if it finds the keyword ERROR then will proceed further in IF condition.

I tried using apply each but I'm going wrong somewhere!

Eg. This sample file has 3 rows with ERROR keyword so the loop will enter the IF case 3 times where I can do other actions.

@ekarim2020 @Expiscornovus

Regards,

Pranav

Categories:

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (2)

Sort by

Chriddle 8,685 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

You can use function split() to split the file content at line breaks.
https://learn.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#split

Line break is decodeUriComponent('%0A')

Was this reply helpful? Yes No
PranavPh 12 on at

Like (0)

Report
Copy link

Link copied!

Hey, should I use the Split in Apply to each loop? I'm very new to power platform so can you show an example?

Regards,
Pranav

Was this reply helpful? Yes No
Verified answer

Chriddle 8,685 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Yes, use this expression as the input of your Apply to each:
split(output_of_your_file_content_action, decodeUriComponent('%0A'))

Was this reply helpful? Yes No
Verified answer

Ellis Karim 12,044 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Just as an additional note, in some Windows text files each line could end with two characters: a Carriage Return (CR) and Line Feed (LF) characters:

You can use apps such as NotePad++ to view these characters.

So the file could also be split at the CRLF characters:

split(body('Get_file_content'),decodeUriComponent('%0D%0A'))

Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site

Was this reply helpful? Yes No

Join the conversation