I'm a complete newbie at PowerApps and I'm coming from a Microsoft Access world. I'm hoping to reengineer an existing Access app using PowerApps and I'm stuck on what should be a very simple task. Any help would be greatly appreciated!
I have have a "master" table (call it Account) and a secondary table (call it Meter) that are connected in a one-to-many relationship. The Account table has a text column called AcctNbr that connects to a lookup type text column called MeterAcctNbr in the Meter table. I believe I've followed the documentation correctly, as the tables seem to have the correct relationship. When I enter a new meter I'm presented with a dropdown list of the existing account numbers in the Account table, as expected, but the value that's being stored in MeterAcctNbr appears to be blank/null/nothing. When I save the new meter and go back to view the table, the MeterAcctNbr column displays (no name) instead of the value I would expect. All other columns in the Meter record display correctly and when I click on (no name), the Account form opens with the correct record displayed.
What am I missing here? FYI, I'm attempting to build a model-driven app using Dataverse.
