Update/Edit and Add records to a powerapp table that is coming from a dataflow/synapse table

So I created a dataflow that pulls from our server/Main Account table to create a powerapp table. The powerapp table holds general information such as name, account ID, city, state zip. There is only 1 record per account.

The goal is for users to pick an account and log an 'activity' with the account. I added custom columns to the powerapp table such as date, notes, and a choice column where they can log details of the activity. I was able to select the account and populate the columns just fine. I was also able to edit and add more to the columns

The trick is being able to log a NEW activity with the same account. New Activities can happen next week, month, year etc. How would I go about this?

How would I link the original account table to the new powerapp table? How can I edit an old entry and/or submit a new entry for that new account. I believe I have to have 2 tables (original acocunt table + powerapptable)

Categories:

General Questions