You’re offline. This is a read only version of the page.
2
Hello everyone,
I'm currently designing a website for data entry, and we're using an on-premise database to store our data. We've connected the database tables to Power Pages as virtual tables.
My goal is to set up a drop-down box for data entry. For instance, when entering an employee's name, I'd like to be able to type a few letters (e.g., "Mon") and then select the desired option from a drop-down list (e.g., "Monica Smith"). These options are stored in another table, which we've also uploaded into Power Pages as a virtual table.
I've attempted to implement this feature by adding a lookup column, but I received feedback from Microsoft support stating that virtual tables do not support such functionality. I've also tried setting up relationships for the table and adding a column into the virtual table. However, either the virtual table cannot be previewed or the records cannot be saved. I understand this issue stems from the fact that our on-premise database does not have such a column.
I would greatly appreciate any suggestions or insights on how to achieve this functionality. Thank you!
Hi @Teammate1 ,
I found the following related thread: Can you create lookup columns on Virtual Tables in... - Power Platform Community (microsoft.com)
Looks like there has been some difficulty with this. From reading the thread it looks like the best suggestion is to use a work around like using a standard table to build lookup columns to your virtual tables, and then use these lookup columns on your power pages site.
Share
Report
All responses (
Answers (
