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

Unanswered

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)

Chriddle 8,436 Super User 2025 Season 2 on at

Like (0)

Report

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

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,436 Super User 2025 Season 2 on at

Like (0)

Report
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 11,681 Super User 2025 Season 2 on at

Like (0)

Report
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