You’re offline. This is a read only version of the page.
14
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.
Jay is a GREAT resource and saved me hours of thrashing about!
HI all,
Today we did a 1-hour call and went over all the options he had and looked at his system he is going to use SharePoint and Canvis app development and move from access.
Hi @RArcher ,
In fact, the dropdown displays the value of the Primary column in the account table by default.
So, if the value is blank in the primary name column, the dropdown will show (no name).
Best Regards,
Wearsky
#1
WarrenBelz
146,635
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,997
Most Valuable Professional
Share
Report
All responses (
Answers (
