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.
Meet Our Blog Authors
  • PowerApps Community Mentor 2018, Practicing surgeon and former Professor of Surgery, University of Illinois, Chicago.
  • Jill of All Trades (Power Apps, SharePoint, PowerShell, Exchange, Power Automate and odds & ends of assorted other things)
  • 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.
  • I'm Tim Leung - a PowerApps builder. In addition to PowerApps, my main interests include building software with SQL Server and Microsoft .NET. I'm the author of 'Beginning PowerApps' - the first published book on PowerApps. You can buy this from Amazon and other leading bookstores.
  • Systems developer
  • 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