Answered

Associating an Appointment Row on a Centralized Customer Service Calendar to a Row in a Dataverse Table

(0) Share

Report

Posted on by Chris1969

Our PowerApp needs to create appointments on a central, application-specific calendar so that staff knows when to follow up on various tasks. For example, a hypothetical appointment might be scheduled for 10-Oct-2021 for "Follow up on Contract ABC." "Contract ABC" corresponds to a row in our Contracts table.

My question is: How can I make the row in the common data model's Appointment table point back to the row in our custom table, Contracts? We need one row to point to another so that if the Contract row is deleted, any Appointment rows related to it can be cascade deleted.

I have checked online resources Appointment Entity Reference and Calendar entities but not had any luck.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

ChrisPiasecki 6,422 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @Chris1969,

Acitivities such as Appointment can be related to any table that is enabled for activities (this is in the Table Settings > Collaboration > Enabled for Activities). You can then tie it back to your Contract row using the Regarding column. When setting this column in an Appointment form, it opens a Lookup view, which you'll see a list of activity enabled Tables that you can select from.

You can then set the relationship behaviour between Contract and Appointment as desired (I believe by default it already will be set to Cascade All for Delete, but you'll want to verify that).

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

Was this reply helpful? Yes No
Chris1969 83 on at

Like (0)

Report
Copy link

Link copied!

This is perfect, thank you very much (I am still getting used to the concept of seeing Appointments as a form of Activity.....); sorry for my oversight.

Was this reply helpful? Yes No