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 Apps / Mutliple Choices row i...
Power Apps
Answered

Mutliple Choices row in dataverse in PowerApps canvas

(0) ShareShare
ReportReport
Posted on by 32

I have a choices column in dataverse like this : 

 

JasonHoffoLeic_0-1667039451169.png

and the column is A choices column. 

 

I want to be able to get this in a powerapps drop down - so its like vertical data in a row kinda a thing. 

I want to be able to query a row and get the multiple choice out and display it in a drop down. 

I am open to making the column anything to make this happen (it doesnt need to be a choices type) - i have tried to create the row like this ["d1","d2","d3"] that a drop down item parameter expects. 

 

Later on I will need to find the row in a query and then find the choices column and show that in a 'powerapps' downdown. 

 

Anyone done this kinda thing before - i dont like asking on here becasue i like to figure it out myself but i am getting a bit mad with it now 🙂

Categories:
I have the same question (0)
  • Verified answer
    JasonHoffoLeic Profile Picture
    32 on at

    I have done this by creating a row in dataverse like this  

    1,2,3,4

     

    Creating a var to the row in dataverse. 

    UpdateContext({ row : LookUp(UWDepartments,UWDepartment = "Whatever",SampleCol)})

     

    And then set a collection with a forall and iterate through the comma seperated words and set it as a table and then assign that table as the Item property on the dropdown. 

     

    Clear(TestString);
    ForAll(
    Split(
    row,
    ","
    ),
    Collect(
    TestString,
    {
    Text: Result,
    Val: CountRows(TestString) + 1
    }
    )
    );

     

    Hope this helps someone. 

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 366 Most Valuable Professional

#2
11manish Profile Picture

11manish 184

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 99 Super User 2026 Season 1

Last 30 days Overall leaderboard