Power Automate Filter Array Out of Bounds Error

[drsabrosa]

HTML Table from Email into SharePoint List​

@Paulie M  I followed all your instructions but I'm stuck on the last one. Can you help with this error?

The template language expression 'split(item(), '^')[3]' cannot be evaluated because array index '3' is outside bounds (0, 2) of array. Please see https://aka.ms/logicexpressions for usage details.'.

I did notice that there is an extra line (a link) after the last row in the table. How do I remove that last line that I don't need? Thanks again.

[VictorIvanidze]

Could you show your flow?

[drsabrosa]

.

[drsabrosa]

@VictorIvanidze 

Hi, here is my flow. It is triggered when a new email arrives. I am following the instructions from this you tube video. https://www.youtube.com/watch?v=IwRKWaTnl3U&t=451s I'm stuck on the very last part.

[VictorIvanidze]

Please show the output of "Filter array" action

[drsabrosa]

Here is the filter array output. I blocked out confidential information.

[VictorIvanidze]

Expand the last action "Select..."

[drsabrosa]

[VictorIvanidze · Accepted solution]

13 split() functions to get 13 variables? Really? Just one split is quite enough.

I think you have to rewrite your flow.  Sorry I have to leave so I cannot help you today any more. Maybe somebody else will do.

[drsabrosa · Accepted solution]

@VictorIvanidze Thank you for your time. I'll figure out another way. Have a good day.