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

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Multiple Choice in vir...
Power Apps
Unanswered

Multiple Choice in virtual table

(0) ShareShare
ReportReport
Posted on by 164

Hey all, 

can anyone tell me a way or give me an example on how to do a multiple choice field in a virtual sql table? 

I have the same question (0)
  • 365-Assist Profile Picture
    2,324 Moderator on at
    Re: Multiple Choice in virtual table

    I can't see how you could do this in a Form because they Datatype is not multi choice. My suggestion is to create a Custom Page then you can use a Canvas Combo Box.

     

    --------------------------------------------------
    Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.

    Subscribe: https://www.youtube.com/channel/UCFpvUlpx84FuIPOdInGKMTw
    Twitter: https://twitter.com/assist_365

    Regards
    Darren Lutchner - 365 Assist

  • AhmedSalih Profile Picture
    6,678 Moderator on at
    Re: Multiple Choice in virtual table

    Hello, @vobius, Are you captuering the Data in the Power Platform? e.g. using Model-Driven Apps or Canvas Apps to perform GRUD data operations? If that is the case, create the Column in the Dataverse correnspondant table and this column chould be of a Choice Type. Then make sure that you check "Selecting multiple choices is allowed" 

    AhmedSalih_0-1677422205539.png

     

    Note: The data in this case will be saved with a ";" separator in SQL. 

     

     

    If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.


    I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.


    Visit my Blog: www.powerplatformplace.com


     

     

     

  • jonheb Profile Picture
    164 on at
    Re: Multiple Choice in virtual table

    This doesn't seem to work for virtual tables. 

  • AhmedSalih Profile Picture
    6,678 Moderator on at
    Re: Multiple Choice in virtual table

    @vobius, you might be right. I will test it on my environment and let you know. 

  • emcedeltate Profile Picture
    4 on at
    Re: Multiple Choice in virtual table

    I talked to microsoft support team about the issue. They said that multiple choice cannot be used in sql sourced virtual tables.

     

    "This is actually a limitation on Virtual Tables. This is only expected to work on Sharepoint.
    The Product Group team will update the documentation to have this information reflected."

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 819 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 308 Super User 2025 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 222 Super User 2025 Season 2

Last 30 days Overall leaderboard