This is my first flow and it's been a journey building it out but I'm stumped on how I can get my flow to read my HTML to Text output as split rows so it identifies one value that I need to set a condition on.
My end goal is to build a flow where: When an automated email is received in my Outlook and includes a data table in email body along with an attachment, and identifies that cell X in data table is less than 100%, an email with the attachment and custom email body will be created and sent out to recipients.
I'm stuck on the part where my HTML to Text has split the data table out into individual rows now, but how to get the next action to label each row with a number so the flow recognizes which % number I'm trying to set a condition to? I believe it's called an array but I'm unsure. The below picture is what the HTML to Text output gave me but I am struggling on this piece of my flow. For more context, I really only need the flow to read rows 66 to 73, since row 69 is part of the "Rollup" section of my data table
When creating a split, it creates an array but mashes all the values under one field so I can't directly pull the line 80% is in
