List values in Flow Designer are showing as sys_ids instead of Values

[Russ Heard3]

Hi,

First time creating a Flow in Flow Designer, want to send an email to interested parties about Failed Changes.

One of the Change columns I want to show on the email is the 'Region Affected' which is a Choice List of one to six regions.

The Regions are being returned as a list of sys_ids, rather than a list of text values.
Does this mean Choice Lists cannot be shown, or am I doing some thing wrong (as I suspect)?

Choice List 

Change record

Email Body generated 

Thanks!
Russ                       

[Allen Andreas]

Hi @Russ Heard 

It would be wise to actually give us a bit more information as to your flow...such as a screenshot of what you have so far?

We have all sorts of other things, but the part that you would need help with and don't know...so...please work on providing that?

I've given an explanation above about the sys_ids showing versus a display value, that should have been helpful information to you so you at least understand that part of it...and that has nothing to do with flow designer and is standard SN knowledge/information.

We'll look for more information from you as far as how you have things setup for the email.

Please mark reply as Helpful/Correct, if applicable. Thanks!

[Russ Heard3]

Hi @Allen A 
thanks very much for persisting with me 🙂 

So Chg Mgmt want to be alerted to Failed Changes.

I have a very simple Flow, to send an email when a Change is saved with an updated close_code (which is not 'successful' or 'canceled').

Almost all the data on the email I can get from the trigger record, except for the List of Regions Affected, which is returned as a list of sys_id's.

Understand I will need a script to parse these sys_id's to get the displayValue for each one; what I'm not sure of is what Flow Action do I need to run this script and how it will generate the output into a data pill so I can add it in to the email body.

Hope that explains it a little better? 

[OlaN · Accepted solution]

In this case a simple way to go would be to first do a look up of all region records that is on the trigger record, then loop through all records, and store their display names in a Flow variable.
Once done, use the data in the Flow variable as input in your email action.

I've made a simple example for you to examine and alter it so that it fits your needs.

[Troya1]

Not getting a "Count" variable.

[DKSINGH]

Hi,

I have requirement, where I need to post a message on teams when condition is met. I am able to post all the fields with required value successfully, but I am facing issues while posting one field which is of "List Type" and referencing to "core_company".

As that field is list type, it contains multiple values and when I am implementing as mentioned in above it posts multiple messages for each value. I need all the values in single post comma separated. Could you please help. Below is the screenshot of my Flow

------------------------------------------

Outcome