Add column to existing virtual table

(4) Share

Report

Posted on by SlavaS1

111

Hi,

I have a virtual table exported from external source (SQL). I have changed table on SQL and need to add appropriate columns to the Dataverse table, but I see that option "New column" is disabled on Power Portal.

Am I right understand that currently feature adding columns to existing virtual tables is not available?

Categories:

Design & build

I have the same question (0)

All responses (3)

Answers (0)

NimbiMac 16 on at

Like (1)

Report

Hi, did you manage to get a solution for this? I have come across the same restriction and really don't want to have to recreate my table relationships and forms again in order to add the new columns...

Was this reply helpful? Yes No
kdubious 8 on at

Like (0)

Report

Bump

Was this reply helpful? Yes No
Community member 4 on at

Like (0)

Report

It took me quite some time to figure this out. Its possible - but just trough the old legacy UI.
Open the Table --> Fields --> Add Field
Its important to put the correct value into the External Name Field (e.g. correct Column Name of the External Data Source --> SQL )

I cannot understand why microsoft does not allow this from the new UI.....

Regards Dario

Was this reply helpful? Yes No