Choice field in virtual table?

(0) Share

Report

Posted on by jonheb

164

Hey all,

is it possible to make choice dropdown fields in a virtual table with SQL on prem as the datasource?

When creating the virtual table I only get the option of text field.

Maybe I didn't see it anywhere or there is a hack out there to create choice fields in a virtual table and save them to SQL?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (6)

Answers (0)

ChrisPiasecki 6,422 Most Valuable Professional on at

Like (1)

Report

Hi @vobius,

Choice fields in Dataverse have a numeric value and a label for the display text which does not have an equivalent single column value in SQL to map to. If in SQL your choice fields are stored as a separate table with a Guid primary key, and then you have a foreign key on your main SQL table referencing that choice table, you could then use a Lookup column in the virtual table.

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

Was this reply helpful? Yes No
jonheb 164 on at

Like (0)

Report

I just tested it but it doesn't seem to work.. Did it like described here powerapps-docs/setup-virtual-table-relationships.md at main · MicrosoftDocs/powerapps-docs · GitHub

I have 2 sql tables where I defined a foreign key relationship. Both primary keys are GUID uniqueidentifier fields. When I create the relationship in dataverse a.) existing records aren't displayed in the lookup field and b.) I can't save new records because of a "ISV Code error"..

Was this reply helpful? Yes No
jonheb 164 on at

Like (0)

Report

Got the first thing to work. Had to delete the foreign key field in the "main table", create the relationship and put in the same column name and now it works.

BUT: I want to have multi choice select so that I can have multiple answers at once - is there any option for this? Ay idea?

Was this reply helpful? Yes No
Headache 2 on at

Like (0)

Report

Precisely what I was looking for as well - did you ever find a solution?

Was this reply helpful? Yes No
jonheb 164 on at

Like (0)

Report

Unfortunately not and therefore we don't use virtual tables nor the application I was looking to build with it.

Was this reply helpful? Yes No
emcedeltate 4 on at

Like (0)

Report

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