Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

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
 
  • Suggested answer
    FLMike Profile Picture
    FLMike 30,829 on at
    How to extract certain values from a choice column?
    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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,495

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,822

Leaderboard