Split email subject to get id

Like (0) Share

Report

Posted on 9 Jun 2020 22:30:38 by Community Power Pla...

Hi, everyone!

I made a flow where people send an email with a document. Flow saves it in a Sharepoint library and then updates an excel database with the link of the document. In order to do this, I use the id of the solicitude (whick is in the subject of the email) as key of the rows.

The flow basically takes the subject of the email (Solicitud de ingreso a cartilla médica - id:##) , saves it into a variable, then it splits the subject so as to obtain only the id using the following formula :

substring(outputs('Redactar_3'),indexOf(outputs('Redactar_3'),'.'),sub(length(outputs('Redactar_3')),indexOf(outputs('Redactar_3'),'id:')))

My flow fails with the following message

This is the flow

I don't understand this error, could you help me?

I have the same question (0)

Summarized by AI

AI generated content may be incorrect

Did you find this summary helpful?

All responses (2)

Answers (1)

Community Power Pla... on 09 Jun 2020 at 23:51:14

Like (1)

Report

Re: Split email subject to get id

Thank you for the quick reply!

Was this reply helpful? Yes No
Verified answer

abm abm 32,506 Most Valuable Professional on 09 Jun 2020 at 22:38:54

Like (1)

Report

Re: Split email subject to get id

Hi @Anonymous

If you looking to get the id use the expression

Expression I used is as follows:

last(split(outputs('Compose_2'),':'))

Thanks

Was this reply helpful? Yes No