cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

PowerApp Creating a subForm in a form

Hi PowerApps Community,

 

I wanted to ask for help regarding the creation of a Form that contains another "Subform" embeded in the same form. I created the basic form which collects the following information: Last Name, First name, Client, Number, Telephone Number, address 1, City, state, Zipcore and Client Notes. (See image attached).

 

However, I need to be able to create a matrix/table where I can add finding to the specific cliente. (see image attached) a cliente can have up to 25 findings and these findings are usually a selection of various dropdowns. 

The idea is that everytime I select the "Add" button I will be able to add a new findings, with a "new subform" this will the user to select the categories from the various dropdown and have a free text area to input notes if needed. 

 

 

FORM1_Test.png

Now my question is, I have all my data stored in a SharePoint List but how can I create this "subform" within the current sharepoint list for each one of the clientes. Any suggestions Idea

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: PowerApp Creating a subForm in a form

You could create another list in SharePoint for your findings and associate it to the main form through the client number or some other unique key. Then when you click Add Findings would cold navigate the user to another screen that has a form for the Findings information. The Findings table would be a gallery or DataTable filter the unique key.



--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

View solution in original post

4 REPLIES 4
Highlighted
Super User
Super User

Re: PowerApp Creating a subForm in a form

You could create another list in SharePoint for your findings and associate it to the main form through the client number or some other unique key. Then when you click Add Findings would cold navigate the user to another screen that has a form for the Findings information. The Findings table would be a gallery or DataTable filter the unique key.



--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

View solution in original post

Highlighted
Community Support
Community Support

Re: PowerApp Creating a subForm in a form

Hi @DanMuriel ,

 

My understanding is that the data source of your main form is SharePoint list, but what is the data source of your subforms? You can navigate to a new screen with a new Form control when selecting the Add button, and the new Form could bind to the new data sources. Or if you want to immediately submit a new record to the 2nd data source with controls in current Form, you could use a Patch function in the OnSelect property of the Add button. 

 

The formula is something like:

Patch(DataSource2,Defaults(DataSource2),{Column1:TextInput1.Text,Column2:Dropdown1.Selected.Value})

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Frequent Visitor

Re: PowerApp Creating a subForm in a form

Thanks Jeff,

 

So for this recomendation I would create a new SP list to collect the "Findings", do yo have any recomendations to create a formula to have a unique generator for the client ID that is consecutive. for example ClientID-##### in where # is a consecutive number for each of the forms submitted.

Highlighted
Frequent Visitor

Re: PowerApp Creating a subForm in a form

@v-monli-msft @Jeff_Thorpe 

 

What I am trying to create is something very similiar to this powerapp that i previously saw. 

 

In which the main form has the clients information and at the bottom there is a gallery of the subform which includes the entries that can be edited or deleted by the user for that specific client. (FORM 2 located in sharepoint list 2) 

Capture.PNG

 

By clicking the "add" button a new form questios will be open that will allows the user to input the data that is required for this form.

 

My question refers how do i add a gallery view that only allows the user to view the requeired information and add additional findings, in which he is currently working on.   

 

The subform will be saved to the 2nd sharepoint list, but transfer this data into the current form.

 Finding.PNG

 

And then the new entry will be added to the current form see image below 

 

 

Information Submitted.PNG

 

 

 

 

Any suggestions??? 

 

 

Helpful resources

Announcements
secondImage

New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,267)