Power Platform Community Forum Thread Details

Good day

I have an app that has multiple collections on 4 different screens as well as items that are outside of the collections (the VCP Monitoring screen below). The collections are linked to galleries so that one can dynamically add items to each of the galleries.

This is the first page (without a collection)

This is the Patch function to save the "non-collection" data to the SQL database:

Patch(VCPMonitor, Defaults(VCPMonitor),
{
Capturer: CapturerTxt.Text,
CaptureDate: CaptureDate.SelectedDate,
BPName: BPNameSelectedTxt.Text,
BPNo: BPNoSelectedTxt.Text,
Frequency: FrequencyDD.SelectedText.Value,
VCPActive: NewVCPActiveRadio.Selected.Value,
BPSupport: NewBPSupportRadio.Selected.Value,
VCPAdoptDate: NewVCPAdoptDate.SelectedDate,
VCPCompleteDate: NewVCPCompleteDate.SelectedDate,
LatestVCPUpdateDate: NewLatestVCPDate.SelectedDate,
VCPUpdatePlatform: NewVCPUpdatePlatfDD.SelectedText.Value,
VCPRevision: NewVCPRevDD.Selected.Value,
RevisionDate1: NewRev1Date.SelectedDate,
RevisionDate2: NewRevDate2.SelectedDate
}
)

Then I have four different screens that contain a selection (2 examples below of two of the screens)

This is the Patch function to save the collection to the database:

ForAll(

col_NewOverallPerformance,

Patch(VCPMonitor,

{

ObjDate1: NewObjDate1_1.SelectedDate,

OverallPerform1: NewOverallPerf1DD_1.SelectedText.Value,

OverallComments1: NewOverallComments1Txt_1.Text,

OverallPerformObjective: NewOverallObjectiveTxt.Text

}

)

Can you please assist me with an example of a Patch function to save the multiple collections and the gallery data which is not in a collection, simultaneously to the database?

Thank you

Categories:

Building Power Apps