Answered

Help- save data to 2 sharepoint lists for multiple controls

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi Community,

I have created a screen form in powerapps where I have added multiple controls. After passing parameter -ID from first screen, I retrieve ID in the second screen. This works fine. Now I have to save the other submitted data against this ID in multiple lists. I have repeater control in gallery with fields as below- multiline, date and combobox (single select)containing list of users.

This is repeated with a plus icon and stored in collection. This has to be updated in list A.

Along with this I have single select and multiselect Check boxes that I need to save to list B. Do i need to use patch to add records in both lists?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi, I have managed to update the ListA with values. However, list B is not getting updated with lookup. This needs to be updated with Lookup to list A. what could be wrong here? Also is it possible to bind these values back to controls when the items are updated.

Set( AllActionsPlanString, Concat( galActionPlan.AllItems, Concatenate( txtTargetVal.Text, "; ", txtWhatTodo.Text, "; ", dtWhenReady.SelectedDate, "; ", comboResponsible.Selected.DisplayName, "; ", " | " ) ) ); If( IsBlank(lookupActionRecord), Patch( 'ListB', Defaults('ListB'), { Title: ProjectID, RepeatedSection: AllActionsPlanString, SLARiskAssessments:{ '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", Id:ProjectID, Value:ProjectID } } ), !IsBlank(lookupActionRecord), Patch( 'ListB', First(Filter('ListB', Title = Text(ProjectID))), { RepeatedSection: AllActionsPlanString } ) );

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Dear Community, I am now patching (creating new record) in List. It correctly creates all items except when people picker is added which when added updates only the last record instead of all records in the gallery.
ForAll(galActionPlan.AllItems, Patch ( 'ListB', Defaults('ListB'), { Title: ProjectID, //RepeatedSection: AllActionsPlanString, LookUp:{ '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", Id:varID, Value:varID }, Target:ThisRecord.txtTargetVal.Text, ToDo:ThisRecord.txtWhatTodo.Text, Ready:ThisRecord.dtWhenReady.SelectedDate /*RiskResponsible: { Claims: "i:0#.f|membership|" & LookUp( Office365Users.SearchUserV2().value, DisplayName=comboResponsible.Selected.DisplayName).UserPrincipalName, Department:"", DisplayName: "", Email: "", JobTitle:"", Picture:"" }*/ } ) );

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi, this is achived with datatable and form control instead of gallery. Thanks

Was this reply helpful? Yes No