Get the “next line after” in an array with Power Automate


When parsing data from an email in Power Automate, extracting information that is on the next line after a specific string can be a bit more complicated. One approach is to turn the email into a text and split it by the new line character to create an array. Then, you can turn the array into a single string with a separator. Next, you can split the string by the data identifier and the separator to remove everything before the desired value. Finally, split the string again using only the separator and keep the first part to extract the value on the next line after the identifier. This method allows you to extract specific pieces of data in a flow using Power Automate expressions.


Article 11m

Login now to access my digest by 365.Training

Learn how my digest works
Features
  • Articles, blogs, podcasts, training, and videos
  • Quick read TL;DRs for each item
  • Advanced filtering to prioritize what you care about
  • Quick views to isolate what you are looking for right now
  • Save your favorite items
  • Share your favorites
  • Snooze items you want to revisit when you have more time