Dynamics 365 CommunityForums Power Platform integration forum extracting an #ID from...

Power Platform integration forum

Suggested answer

extracting an #ID from email subject

(0) Share

Report

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 Img

All responses (2)

Answers Img

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

Helpful resources

Quick Links

Leaderboard

Andre Arnaud de Cal... 283,377 Super User

Martin Dráb 223,308 Super User

nmaenpaa 101,140

Featured topics

Product updates

Dynamics 365 release plans