Unanswered

Create HTLM form from dataverse Table?

(0) Share

Report

Posted on by Tal22

259

I created a Dataverse table with 5 columns. I would like to create a form containing all 5 columns. The only way I can think of doing this is coding an HTML page. Or is there a plugin or like to achieve this?

FYI, I tried using the native form tool generated from the table but I can only display two columns.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Mira Ghaly 11,413 Moderator on at

Like (2)

Report

@Tal22

You will need a model driven app to be able to achieve what you are after.

Read about model driven apps here:

https://learn.microsoft.com/en-us/power-apps/maker/model-driven-apps/model-driven-app-overview

To learn about how to create forms and views https://learn.microsoft.com/en-us/training/modules/customize-view-forms/

Was this reply helpful? Yes No
Tal22 259 on at

Like (0)

Report

Thanks Mira,

This was somewhat helpful. I am an Access user, which provides a true relational database solution with sound form and view (query) generation. I think my problem is that I imported an Excel file into the dataverse table where there is a mismatch of field mappings because dataverse is looking for fields that don't exist in an Excel file. Access does not suffer from this design flaw. Excel columns easily map into to Access tables. The dataverse documentation doesn't mention that importing Excel is not a very practicable solution, fraught with technical errors. The work around is to import an Excel file into Access and then Use Access' External Data function to export to a Dataverse solution. This works flawlessly without any mapping errors, but it adds an extra step into the process. Not very efficient.

Also glaring issue is that Dataverse is a SQL database backend, but adding data to to a table is very clunky. I don't understand why MS hasn't built DV into a full API.

Was this reply helpful? Yes No