Flow Designer - Create Incident - Set LOCATION based on abbreviation in email subject

Jon Epstein
Giga Guru
  • I'm working on Flow in Workflow Studio.
  • Trigger is inbound email
  • The subject line of each email starts with a 3 letter abbreviation that represents a field office locations.  The same 3 letter abbreviations are on the cmn_location table as the field "u_loc_abbreviation".
  • I want the Flow to Create Incident Record and set the Location field to the cmn_location.name associated with the "u_loc_abbreviation" that gets scraped from the email Subject.

How do I do this efficiently?

Thanks,
Jon

7 REPLIES 7

@Jon Epstein 

the format should be consistent for your script to work

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Ankur Bawiskar
Tera Patron
Tera Patron

@Jon Epstein 

you can use script shared by @Bhavya11 

Do let us know the feedback

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Sorry - but why would I credit you for Bhavya11's work?  Is this a tactic people use to gain "popularity points" on the community site?