cancel
Showing results for 
Search instead for 
Did you mean: 

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

Introduction
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
 
Video
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
Search(Record,HomeSearch.Text,"FullName")
 
Capture1.JPG 
Submit button in the Add Screen 
Set(NewRecordIDValue,(Max(Record,ID))+1);
Patch(Record,Defaults(Record),{ID:NewRecordIDValue,FullName:FullNameComboBox.Selected.FullName,Grade:AddGradeDropdown.Selected.Value,Note:AddNoteTxt.Text,Date:Now()});
Reset(FullNameComboBox);Reset(AddNoteTxt);Navigate(HomeScreen,ScreenTransition.Cover)
 
Capture2.JPG

Submit button in the Edit screen
Patch(Comments,Defaults(Comments),{ID:Text(Max(Comments,ID))+1,RecordID:HomeGallery.Selected.ID,Comment:CommentsTxt.Text,Score:CommentScoreRating.Value,Date:Now()});
Reset(CommentScoreRating);Reset(CommentsTxt);
Navigate(HomeScreen,ScreenTransition.Cover)
 
Capture3.JPG
 
Conclusion
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.
Comments

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?

Meet Our Blog Authors
  • PowerApps Community Mentor 2018, Practicing surgeon and former Professor of Surgery, University of Illinois, Chicago.
  • I am the Owner/Principal Architect at Don't Pa..Panic Consulting. I've been working in the information technology industry for over 30 years, and have played key roles in several enterprise SharePoint architectural design review, Intranet deployment, application development, and migration projects. I've been a Microsoft Most Valuable Professional (MVP) 12 consecutive years and am also a Microsoft Certified SharePoint Masters (MCSM) since 2013.
  • My name is Timothy Shaw and I create digital solutions using the Power Platform, Office 365, and Azure SQL and handle the IT for a small company in the energy sector. When not building the future :), I enjoy playing guitar, good (or really bad!) sci-fi, Xbox therapy, and hanging with my wife and son. Twitter: @ShortForTim