Standard activities are appropriate for tasks, phone calls, and appointments. Some organizations also need a structured interaction record for specific business details such as visit outcome, product interest, sentiment, or a custom follow-up classification. A custom Dataverse table can capture those fields without overloading the Contact table.
1. Design the custom table
Create a table such as Contact Interaction with columns for Interaction Name, Contact lookup, Account lookup (optional), Interaction Date, Interaction Type choice, Outcome choice, Notes, and Next Action Date. Use a relationship to Contact so records can be filtered and secured by the related person.
2. Add a form to Power Apps
Add the custom table as a data source. Insert an Edit form and configure the Contact lookup card to use varSelectedContact as the related record. Use generated cards for the choice and date columns.
3. Save the interaction
SubmitForm(frmContactInteraction)
// frmContactInteraction.OnSuccess
Notify("Interaction saved.", NotificationType.Success);
Refresh('Contact Interactions')
Use the actual table name displayed in the app. If you use Patch, ensure the Contact lookup receives a Contact record and the choice fields receive their typed choice values.
4. Show interaction history
SortByColumns(
Filter(
'Contact Interactions',
Contact = varSelectedContact
),
"createdon",
SortOrder.Descending
)
The Contact lookup display name and sort identifier may differ. Verify the formula in the target environment and check delegation.
