Hello all,
I am trying to achieve grabbing this bit out of an email, my approach is to capture all the text not including the "Info : " and put them into an array and then i can loop over it to grab what i want. The email comes in, in 2 cases:
first case:
Some text here and what i want to grab right under
Info : AAA BBB CCCC DDDDD EEEEEE
Info : FFFF GGGGG HHHHH IIIIIIII JJJ
Info : KK LLL
second case:
Some text here and what i want to grab right under with a new line
Info : AAA BBB CCCC DDDDD EEEEEE
Info : FFFF GGGGG HHHHH IIIIIIII JJJ
Info : KK LLL
Thank you
Solved! Go to Solution.
Hi @mmattar,
Case 1 could use "Info : " to convert the string into an array, then use skip() function to remove the "some text here...":
skip(split(outputs('Compose'),'Info : '),1)
Could you please explain more about "Some text here and what i want to grab right under with a new line"?
What's the mean of new line?
Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @mmattar,
Case 1 could use "Info : " to convert the string into an array, then use skip() function to remove the "some text here...":
skip(split(outputs('Compose'),'Info : '),1)
Could you please explain more about "Some text here and what i want to grab right under with a new line"?
What's the mean of new line?
Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hey thanks for the reply, what i mean by this is,
"Some text here and what i want to grab right under with a new line"?
What's the mean of new line?
its just some random text to show that there is text above what i want to grab, sometimes right under it and sometimes with a newline in between."Some text here and what i want to grab right under with a new line"?
Initially i am trying to grab all the info data, and find the "HHHHH", but this could be placed in a different spot not always the same spot in the email. But it is in the "Info : "
Hi @mmattar,
If so, you could following these steps:
Firstly, initialize a new line variable as a separator to convert the text into an array.
Secondly, use the filter query action to extract these rows contains "Info : ".
You could have a try:
Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
71 | |
23 | |
17 | |
17 | |
13 |
User | Count |
---|---|
125 | |
34 | |
34 | |
28 | |
25 |