web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Extract ticket number ...

Power Automate

Answered

Extract ticket number from email subject and update it

(0) Share

Report

Report

Posted on by nicklim

391

Hey everyone, I am trying extract the ticket number from the email subject by using compose without any luck.

Example of the email subject: INC# 110 - Test abc cba

Anything before and after INC# is dynamic, it can be different with each email.

All I want is to extract the ticket number, and use filter query to match the ID in SharePoint list, and then update the item.

Flow:

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

nicklim 391 on at

Like (0)

Report
Copy link

Link copied!
Hey everyone, sorry please disregard.

Using this in compose worked.
split(split(triggerBody()?['Subject'], 'INC# ')[1], ' - ')[0]

Was this reply helpful? Yes No
SanmeshG 1,947 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @nicklim ,

One way of getting the ticket number , if you have a hyphen(-) would be to use the split function on that to split the string based on hyphen(-) and take the first value from the resulting array.

Expressions for split and trim and accessing array elements.
split(triggerBody()['text'],'-') trim(outputs('Compose')[0])

If this solves your problem , please give this answer a thumbs up and accept this as a solution.

Thanks,

Was this reply helpful? Yes No

Join the conversation