Multiple Choice in virtual table

(0) Share

Report

Posted on by jonheb

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?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (5)

Answers (0)

365-Assist 2,324 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No

AhmedSalih

6,678 Moderator on at

Like (1)

Report

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"

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

Was this reply helpful? Yes No

jonheb 164 on at

Like (0)

Report

Re: Multiple Choice in virtual table

This doesn't seem to work for virtual tables.

Was this reply helpful? Yes No
AhmedSalih 6,678 Moderator on at

Like (0)

Report

Re: Multiple Choice in virtual table

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

Was this reply helpful? Yes No
emcedeltate 4 on at

Like (0)

Report

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."

Was this reply helpful? Yes No