- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-17-2021 12:18 PM
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
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-18-2021 04:45 AM
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-26-2024 12:50 PM
Hi @DKSINGH
It would probably be better for you to post your own question as the discussion here is about 3 years old now.
Outside of that, you wouldn't loop through using For Each for the list field, as that means you will pass a message...for each...value selected in this field.
Instead, you'd want to pass just the value of the list field, which would be a comma-separated list of sys_id or retrieve their display name.
Please consider marking my reply as Helpful and/or Accept Solution, if applicable. Thanks!

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-20-2021 06:05 AM
Hi,
Thanks for providing all that.
As mentioned, you'd have to loop through the table which contains those sys_ids to then get their display value. The other option would be to use script for the body, but then you'd have to script the entire thing. Just wanting to provide that piece for maybe the future?
Using the above example would net you a body in email that share the display names (same would work for your other field, you'd just swap out 'watch_list' with the name of your field.
Please mark reply as Helpful/Correct, if applicable. Thanks!
Please consider marking my reply as Helpful and/or Accept Solution, if applicable. Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-20-2021 06:16 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-12-2022 07:09 PM
Hi Russ,
Just reviewing your output on the email, for your Regions = can you tell me how you were able to get the spaces to appear for the output? "EMEA UK&I "
I was successful to get the results I needed, from this post, but my results, unfortunately, are grouped together so the output looks like one log word. Is there a way to space or add commas to separate?
Much appreciate your assistance
Joel
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-16-2022 03:51 PM
Hello,
Have you found a solution for this?