I've been working on small Power App that uses Dataverse for Teams as the backend. For a few maintenance tasks I figured an MS Access front end might be easier, given that doing a data grid in a Canvas App is not nearly as straightforward as it seems (or really should be...why is this a 15 step process with a million little missteps, when Access could do it in 1995 in one step?).
I was able to get the Dataverse tables linked in no problem, and it even populated the relationships and combo boxes based on lookup columns correctly. Editing seems to work great too. Adding rows however seems to be fraught with problems. I keep getting "Required field 'XXX' does not contain a value errors. Please set a value and try again". This happens in 2 scenarios:
- Adding a row to a table where the primary key column in Dataverse is an Auto-Number, so you would expect to leave it blank and then getting filled in after the INSERT.
- Adding a row on a table with a look up column in Dataverse that is a Combo Box in Access. The combo-box appears to be correct, throws this error. Note this is a required column in Dataverse
All of these relationships seems to unction correctly in the Power Apps table editor and in the Power Apps form.
Thanks,
Eric
