Microsoft Dynamics 365 | Integration, Dataverse...

extracting an #ID from email subject

(1) Share

Report

Posted on by MB-08051606-0

Hi,

I have a flow that I would like to use to update a list item. The ID of the item is contained within the email subject in this form: /#REF1234 Whatever subject follows/ where 1234 is the id. I am looking for the proper function to isolate the ID following #REF from the string this could be any number of digits following #REF. I am unsure one function alone can achieve this, I tried searching a bit and array might seem to be one way to go but i wasn't exactly sure where to start.

thanks

All responses (2)

Answers (0)

Dengliang Li Microsoft Employee on at

Like (0)

Report

extracting an #ID from email subject

Hi,

Has the issue been solved?
Have there been any updates? Please feel free to ask me if you have any questions!
If it has been resolved, can you mark the response as an answer?
Suggested answer

Dengliang Li Microsoft Employee on at

Like (0)

Report

extracting an #ID from email subject

Hi,

Is the format of your subject field values fixed?
For example: #REF1234 space Whatever subject follows

The #REF always comes first, followed immediately by the ID, then a space followed by the text.

If so, then you can use the following expression.

slice(outputs('Get_a_row_by_ID')?['body/subject'], 4, indexOf(outputs('Get_a_row_by_ID')?['body/subject'], ' '))

If my answer was helpful, please click Like, and if it solved your problem, please mark it as verified to help other community members find more.
If you have further questions, please feel free to contact me .

Best Regards,
Dengliang Li