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

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

Dengliang Li Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Dengliang Li Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No