Showing results for 
Search instead for 
Did you mean: 

Save multiple Comments using IDs and one-to-many relationships

This blog describes how you can save multiple comments to an single data entry using one-to-many relationships. The blogs walks through how you use IDs from the tables to build the relationships. The demo includes a sample app used by a school teacher to save comments and scores of students, however, the same app can be used for other similar scenarios. Majority of the content is covered in the video, however, expressions and important links are provided here.
Key items covered
 • Saving multiple comments in a separate table/list
 • Building relationships between tables using IDs
The video deep-dives into how the solution works. The video focuses on the key items mentioned above. In addition you can download the attachment which has a copy of the app plus the Excel spreadsheet. The spreadsheet needs to be saved in your Business OneDrive.

Important Expressions / Formulas
Here are some formulas shown in the video.
Filtering the Home gallery using the search
Submit button in the Add Screen 

Submit button in the Edit screen
Using the one-to-many relationship you no longer have to worry about how many comments you'll add since they are added as rows and no longer columns. As mentioned in the video this can be done with Excel spreadsheet in OneDrive, SQL tables and SharePoint Lists. In SQL and SharePoint, the ID columns are automatically incremented which makes things easier.

Hi Daniel,


Great video, thanks a lot.

This gives me a starting steering, however, my scenario is slightly different. when creating a primary record i.e. inspection, I should be able to log multiple defects before I submit the main form?

In the database (D365 CRM) I have one to many relationship between Inspection and defects entity. The expectation is, The inspection entity should be submitted with the one or more defects as child record in the CRM on the completion of the inspection form? Any help please?