Get Selected item texts from a multi select choice field | choices in power automate
In Microsoft DataVerse we can use Choices data type to allow multiple selections for a specific field for example below I have a Choices field called as Degree where you can select multiple items.
Now if you will read the Degree values it will give you the under lying values so to get the selected texts you have to use the below code. if you check the output code of a retrieve record step you can see the below two lines for every Choices field.
“cr8eb_degree@OData.Community.Display.V1.FormattedValue”: “MCA; MBA”,
“cr8eb_degree”: “365500000,365500001”,
SO to read the text you have to use below code
outputs(‘Get_a_row_by_ID’)?[‘body/cr8eb_degree@OData.Community.Display.V1.FormattedValue’]
In my example I have updated the variable step as above expression and I can see the text after testing the flow.
Now after testing this I can get all the selected items as below.
Now I can use Split function to get separate values for my logic.
Hope this helps
Don’t miss the chance to participate in the upcoming Internship Program which will be done using Microsoft Dot Net Web Development Full Stack Technology. The new batch will be starting from May 20, 2024. We will have most experienced trainers for you to successfully complete the internship with live project experience.
Why to choose Our Internship Program?
Industry-Relevant Projects
Tailored Assignments: We offer projects that align with your academic background and career aspirations.
Real-World Challenges: Tackle industry-specific problems and contribute to meaningful projects that make a difference.
Professional Mentorship
Guidance from Experts: Benefit from one-on-one mentorship from seasoned professionals in your field.
Career Development Workshops: Participate in workshops that focus on resume building, interview skills, and career planning.
Networking Opportunities
Connect with Industry Leaders: Build relationships with professionals and expand your professional network.
Peer Interaction: Collaborate with fellow interns and exchange ideas, fostering a supportive and collaborative environment.
Skill Enhancement
Hands-On Experience: Gain practical skills and learn new technologies through project-based learning.
Soft Skills Development: Enhance communication, teamwork, and problem-solving skills essential for career success.
Free Demo Class Available
