Power Platform Community Forum Thread Details

Ive got a flow thats been running. but more recently found that there is some data that changes and messes up the line count. in a highlight, sometimes users put comments and instead of grabbing the line that contains data it grabs a blank line.

So what im attempting to do is use a condition value to determine if the line is blank then grab a different line.

So instead of say -4 position from the end, grab -7 from the end.

But the problem i have is the step after the condition i need to grab the data from either the True or the False output.

Because if the line is blank i need to use -7 but if its not blank i need the output from -4.

I wanted to integrate it above higher, but unfortunately there is a lot of cleanup activity that id have to duplicate just to move this "if" statement above.

sorry for the small / zoomed out image. but the FindClin could be a potential to have it, but i need the steps below filtering out spaces, joining it all together etc. because technically both lines are Blank. but at the end of the cleanup one is really blank and one is not. and if the one that is really blank then i switch lines and repeat this clean up process all over.

the false side will just pass the output from the step since its right, the true needs to re-perform the steps on a new line and clean them up.