Power Platform Community Forum Thread Details

Helloo community, receive and a happy new year, my bests wishes to all.

I´m preetty new working with PA, now i´m meaking a flow for extract some data from an email, once the email is converted to text, has this estructure:

Casa N°:01-01Nombre y Apellido:Luis Alberto Heredia
QuinteroTeléfono:0424-5556476N° de referencia:1234567890Fecha del
pago:07/01/2025Banco emisor:mercantilMonto pagado:3000Mes que está pagando:enero

The highlighted words are the ones I need to extract. I´m using the same funtions structure for extract each word, but, when the flow go for the 5th step, gives errors. Whit the avobe words, the funtion work fine.

This is the funtion structure:

substring(outputs('Html_to_text')?['body'],add(indexOf(outputs('Html_to_text')?['body'],'N° de referencia:'),17),sub(indexOf(outputs('Html_to_text')?['body'],'Fecha del pago:'),add(indexOf(outputs('Html_to_text')?['body'],'N° de referencia:'),17)))

With this, extracts the "refencia" number, this one may have 9, 10 or 11 digits.

Attach the print screen of the error.

Thanks for your help. I appreciate it very much