Dynamics Community Forum Thread Details

Subgrid quick data entry

I am creating a lunch app for a school. I have a menu table with a list of the menu's per date. Then I have a lunch student table with lookups to both the menu table and the contact table. In the Lunch form I added a student subgrid to enter the student info in, but it is a bit tedious to add data this way. Is there a better way to do this? Or is there a way I can create an external form (not pages) so parents can enter info directly into a form that would populate these tables?

Hi,

Your request to create an external form to add student information is supported.

Here is the solution from our team.

Step1, create a canvas application and add a Form.

Step 2, link the data source and select the fields you want to add data to

Step 3, add a button for submitting the data and set the submission logic

The above steps are just a general step, the details of each step, such as when to show and hide the data fields, which data fields to add, and the logic after submitting the data, need to be designed according to your business needs

In addition, you can refer to the following two official Microsoft documents to learn more about the design and use of canvas applications
Add and configure controls in canvas apps - Power Apps | Microsoft Learn
Show, edit, or add a record in a canvas app - Power Apps | Microsoft Learn

I hope my answer is helpful to you! If you have any other questions, please feel free to contact me.

Best Regards,
Rudy Zhang

Quick Links

Leaderboard