Hello everyone,
I'm new to Power Apps and currently exploring its functionalities.
I'm attempting to display and filter a transaction table based on user login details.
Here's is my understanding of the process:
- A user can register from the sign-in page, which creates a record in the contact table in Dataverse.
- Then, I can establish a relationship from the contact table to the transaction table to filter display based on columns based on their login detail.
However, I've noticed that the default Primary Key of the Contact Table uses a combination of first name and last name. This poses an issue as it's possible for two people to have the same first and last name.
For example, I've registered three records below.
Both 'Testing11111@hotmail.com' and 'Testing222222@hotmail.com' have different emails but share the same first and last name.
In a one-to-many relationship, the default uses the Primary Key of the contact table to the many side of the transaction table. However, with two identical names, it's impossible to distinguish them in the transaction table (as shown below).
It would be better if I could use the email address as the primary key of the contact table. However, I've read a few posts saying that it's impossible to change the primary key of a table. Does anyone have an idea how to achieve this? Help would be appreciated.
