Power Platform Community Forum Thread Details

Hi,

I have a columns namely polnum,intgkey,ntcyr,paymentmode,Insurednum,Additionalcategory in indvl database where for one polnum,intgkey,ntcyr,paymentmode values we have many Insurednum and Additionalcategory values according to it in database. So in powerapps first screen, I have inputs for polnum,intgkey,ntcyr,paymentmode. So when I click on button it has to take these values for which the user gave input and should navigate to next screen where it has repeating table gallery in that particular second screen and filter and display all the Insurednum and Additionalcategory in repeating table gallery which are related to particular entered polnum,intgkey,ntcyr,paymentmode from screen. But here in second screen I already have collection named "AddCollection" for repeating table where by default it has 10 input values in repeating table for Insurednum and Additionalcategory with formula: items: AddCollection and there is a add button where it adds new record with formula:
Collect(AddCollection,{No:Text(Last(AddCollection).No+1), polnum:"",intgkey:"",ntcy:"",paymentmode:"",Insurrednum:"",Additionalcategory :""}. so whenever button is clicked on first screen , it will take values from input and search data in indvl database and display all the Insurednum and Additionalcategory and at same time user can edit those values and also add the new records in the same repeating table gallery which is in second screen. So, along with displaying details from database, it should also be able to add new records.(By default it will be 10 new records onstart of the screen) as shown in below image:

The below is first screen button:

This is second screen add icon where it adds new blank records:

For this Addicon, I inserted formula with:

Collect(AddCollection,

{No:Text(Last(AddCollection).No+1),

polnum:"",

intgkey:"",

ntcy:"",

paymentmode:"",

Insurrednum:"",

Additionalcategory :""

}

and in OnStart property since by default it has to be 10 records/tables in repeating gallery, so the formula I wrote is:

Collect(AddCollection,{No:1, polnum:"",intgkey:"",ntcy:"",paymentmode:"",Insurrednum:"",Additionalcategory :""},{No:2, polnum:"",intgkey:"",ntcy:"",paymentmode:"",Insurrednum:"",Additionalcategory :""},........ so on upto 10, {No:10, polnum:"",intgkey:"",ntcy:"",paymentmode:"",Insurrednum:"",Additionalcategory :""}

So how to pass data from the on click of button to next screen and display details from database.

Thanks in Advance

Categories:

Building Power Apps