Announcements
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 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/UCFpvUlpx84FuIPOdInGKMTwTwitter: https://twitter.com/assist_365
RegardsDarren Lutchner - 365 Assist
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"
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
This doesn't seem to work for virtual tables.
@vobius, you might be right. I will test it on my environment and let you know.
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 525 Most Valuable Professional
Haque 273
Kalathiya 232 Super User 2026 Season 1
