If you're working with ServiceNow Catalog Items you should watch this next. All about ServiceNow Variables.: ua-cam.com/video/nk9A6tBQvSA/v-deo.html Want more ServiceNow deep dives? Here's my ServiceNow Toolbox playlist: ua-cam.com/play/PLkQDoKoP0MAP0gwpL2OEMZJzmm7t872th.html
Very very very nice! I was looking for a solution for a while now... You solved it! I don't know why ServiceNow did not implement this if they want us to move from Flow Editor to Flow Designer... I would be interested in cracking another issue. How to create a Flow Designer flow which can be used form a Catalog Items as a Process Engine and use variables from the RITM in the flow
Yes. Trigger is the same (inbound email) and use the same email parser to get the name:value pairs. From there you can do WHATEVER YOU WANT in the flow. The custom Flow Action just gives you a way to extract "fields" from the email.
Seesm like there was an update to the action and it calls for a Default value, a Name and a Value? Why Value? I'm trying to pull the value from the email2. And as a Function/Utility why is there the option to add multiple key value pairs for a singel varible you are trying to set?
Sure. What other topics do you think I should cover? And the more this content is shared, the more content I'm going to make. If you could take my LinkedIn account and the #ServiceNow hashtag, that would help a TON
Thanks Robert for this -- very helpful, although I am still running into an issue with resolving the name-value pairs. The HTML in the received email contains an HTML table with two columns, name on the left and value on the right. The parser is unable to pull data from it. Have you heard of this issue?
I don't believe the parser is built to do that. It interprets name value pairs as being strings on separate lines.. Name1:Value1 Name2:Value2 Its not parsing through HTML.
Thanks for this guide Robert! it was extremely easy to follow. Just a heads up that the "Parse Email Flow Action v2.2" seems to not work with Tokyo (and assuming San Diego as well). The name/value pairs show up in the "Email Variables" in the Parse Email Body Text global action but they do not populate in the Submit Catalog Item Request action.
Hey Peter, I just retested and it works fine on my Tokyo instance, though I might not be using Parse Email Flow Action v2.2. Maybe I'm using a prior version?
Thanks for confirming, Robert! I did use Parse Email Flow Action v2.2 on flows that were created in Rome, which still worked in Tokyo. But i believe when i created net-new flows in Tokyo (on v2.2) they were not passing the name:value variables. The fix that we did was to create separate output variables for each variable we were trying to pass. It's a bit tedious because we now need to create a separate parse email action per inbound e-mail flow. But i thought you might want to know. I might have to see if the previous version of the action works on Tokyo. Cheers, Pete
Hello Robert, I am facing issue to populate the reference field and Date/Time field through Email variable (Name/Value). Any help would be appreciated!
You haven't described the problem. I suspect its this. The DateTime is probably being picky about format. The Reference field is looking for a sys_id, which the email isn't sending, so you may have to do a lookup based on the name that hte email sends you in order to find the sys_id.
You can't parse for a data type because emails don't have data types. You can only parse for a value. Hopefully the field you wish to contain that value allows it.
Is it possible to bring the Choice fields through the 'Parse email Action' in the flow designer? .As when we go to add the data pill it shows that 'Name:Value Pair is not allowed here'. Can you help me out with it Thanks!
I'm not really deep on Risk & Compliance. GENERALLY though, get as much practice as you can ON THE PLATFORM. Reading is only ever going to get you so far. I'd also suggest calling it SN for short, or NOW. "Snow" is an asset management platform that often competes with ServiceNow.
If you're working with ServiceNow Catalog Items you should watch this next. All about ServiceNow Variables.: ua-cam.com/video/nk9A6tBQvSA/v-deo.html
Want more ServiceNow deep dives? Here's my ServiceNow Toolbox playlist: ua-cam.com/play/PLkQDoKoP0MAP0gwpL2OEMZJzmm7t872th.html
Very very very nice!
I was looking for a solution for a while now... You solved it!
I don't know why ServiceNow did not implement this if they want us to move from Flow Editor to Flow Designer...
I would be interested in cracking another issue.
How to create a Flow Designer flow which can be used form a Catalog Items as a Process Engine and use variables from the RITM in the flow
Try this: ua-cam.com/video/sRtnUkV0UR4/v-deo.html
Perfect Content, thank you..! Robert
Small question here can we do the same for creating incident record through the inbound mail
My pleasure. LinkedIn shares really spread the word!
Yes. Trigger is the same (inbound email) and use the same email parser to get the name:value pairs.
From there you can do WHATEVER YOU WANT in the flow. The custom Flow Action just gives you a way to extract "fields" from the email.
Seesm like there was an update to the action and it calls for a Default value, a Name and a Value? Why Value? I'm trying to pull the value from the email2. And as a Function/Utility why is there the option to add multiple key value pairs for a singel varible you are trying to set?
Upload more videos on catalog Robert😊
Sure. What other topics do you think I should cover?
And the more this content is shared, the more content I'm going to make. If you could take my LinkedIn account and the #ServiceNow hashtag, that would help a TON
Thanks Robert for this -- very helpful, although I am still running into an issue with resolving the name-value pairs. The HTML in the received email contains an HTML table with two columns, name on the left and value on the right. The parser is unable to pull data from it. Have you heard of this issue?
I don't believe the parser is built to do that.
It interprets name value pairs as being strings on separate lines..
Name1:Value1
Name2:Value2
Its not parsing through HTML.
getting an error when trying to parse the email - Script: Cannot convert null to an object. any idea what i might be doing wrong
Thanks for this guide Robert! it was extremely easy to follow.
Just a heads up that the "Parse Email Flow Action v2.2" seems to not work with Tokyo (and assuming San Diego as well). The name/value pairs show up in the "Email Variables" in the Parse Email Body Text global action but they do not populate in the Submit Catalog Item Request action.
Hey Peter, I just retested and it works fine on my Tokyo instance, though I might not be using Parse Email Flow Action v2.2. Maybe I'm using a prior version?
Thanks for confirming, Robert! I did use Parse Email Flow Action v2.2 on flows that were created in Rome, which still worked in Tokyo. But i believe when i created net-new flows in Tokyo (on v2.2) they were not passing the name:value variables.
The fix that we did was to create separate output variables for each variable we were trying to pass. It's a bit tedious because we now need to create a separate parse email action per inbound e-mail flow. But i thought you might want to know.
I might have to see if the previous version of the action works on Tokyo.
Cheers,
Pete
@@PeterQuill-oi8lu - sent a screenshot of this convo to the author of the custom action. He's going to take a look at it.
@@robertthedukefedoruk5607 - I've scoured the web for a solution to this issue. Any updates? I'm working with v2.2 on Utah.
any examples of how you got this to work ?? pls
Hello Robert, I am facing issue to populate the reference field and Date/Time field through Email variable (Name/Value). Any help would be appreciated!
You haven't described the problem. I suspect its this. The DateTime is probably being picky about format. The Reference field is looking for a sys_id, which the email isn't sending, so you may have to do a lookup based on the name that hte email sends you in order to find the sys_id.
How to parse the email body for choice field for inbound flows
You can't parse for a data type because emails don't have data types. You can only parse for a value. Hopefully the field you wish to contain that value allows it.
Is there way to change regex to create value (for name:value pairs) of email which is stored after : within characters?
Input data that I have in body_text field is in this format
From: FirstName FirstName
Is it possible to bring the Choice fields through the 'Parse email Action' in the flow designer? .As when we go to add the data pill it shows that 'Name:Value Pair is not allowed here'. Can you help me out with it
Thanks!
Choice fields really are just strings at some level, so as long as the email contains the VALUE and no the LABEL of the choice you should be ok.
Robert I am preparing for CIS-RC certification (new to Snow) any content or advice for me on passing it.
I'm not really deep on Risk & Compliance. GENERALLY though, get as much practice as you can ON THE PLATFORM. Reading is only ever going to get you so far. I'd also suggest calling it SN for short, or NOW. "Snow" is an asset management platform that often competes with ServiceNow.