web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How to extract certain...
Power Automate
Suggested Answer

How to extract certain values from a choice column?

(1) ShareShare
ReportReport
Posted on by 633
Hello,
 
Could you do me a favor?
I have a value here from a choice field. There are many names in the choice column. The value is:
 
Hinnson, David. [US-US]
 
I want to extract only name so that I can use a search for users(V2) so that I can get user's info. Thank you
 
Categories:
I have the same question (0)
  • Suggested answer
    Michael E. Gernaey Profile Picture
    53,974 Moderator on at
    Hi,
     
    Firstly what are you putting IN the choice column?
    Second, what Control are you putting the Choice into?
     
    How do I know what Choice to give you a name for? Are you asking me to Parse ALL the choices and return a list of names you can use?
     
    Please please please put the details in as we cannot see anything but your words and you are not clear with what you want. For us to answer we need all the details. 
     
    Because if you are asking about Looping through all the Values in a Choice, the only real way is to use the API (AKA HTTP Action) to call Dataverse directly and use a select on the output when the return value gives you all the Choice Values.
     
    You when then Loop through your Select, using Apply to Each
    And in each Loop you would use the Split expression , using the . (period) since thats what I see in your example
    By doing that, the array you get back would have 2 part [0] and [1] and [0] would be the persons name.
     
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 552

#2
Valantis Profile Picture

Valantis 388

#3
11manish Profile Picture

11manish 375

Last 30 days Overall leaderboard