Answered

Patching multiple records contained in a nested gallery

(0) Share

Report

Posted on by pr3mrxj

Hey everyone

I'm new to PowerApps and I'm facing an issue that I can't seem to solve. I'm building a PowerApp that contains a nested gallery of records that are derived from a SharePoint list. Here are some relevant screenshots of my application:

The following is my code contained in the OnSelect property of the Save button (Button_Sample_22):

ForAll(Gallery3_3.AllItems As aPatch,
 ForAll(Gallery6_3.AllItems As bPatch,
 Patch(
 Qualifications,
 Defaults(Qualifications),
 {
 Title: aPatch.Title2_6.Text,
 Subcategory: bPatch.Subtitle5_6.Text,
 Skills: bPatch.Subtitle5_7.Text,
 Score: bPatch.Dropdown_Sample_4.SelectedText.Value
 }
 )
 )
);

Expected behavior: Patches all the records inside the gallery into the connected SharePoint list (Qualifications).

Current behavior: Does nothing.

Here is a screenshot from the PowerApps monitor for the application:

According to the logs, the ForAll loop is being executed, but does not return a valid result, i.e. does not reflect the changes inside the application to the SharePoint list. Any idea on how to fix this?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Chris-D 1,246 on at

Like (1)

Report
Copy link

Link copied!
Hi @pr3mrxj, I answered this question for someone else a couple of weeks ago. I can't fault your approach and I have tested the same but for some reason I can't pull values out of a nested gallery's AllItems. Everything seems blank.

I've not had time to investigate/try and fix this yet but my approach that worked was to create a list of changes and patch that instead.

Code on the OnChange event of control for a text input:
// See if we already have a change record for this item If( IsBlank( LookUp( GalleryChanges, ID = ThisItem.ID)), // If we don't, create a record Collect( GalleryChanges, Penguins@{ ID: ThisItem.ID, Notes: Self.Text }), // If a record exists, update it with this change Patch( GalleryChanges, LookUp( GalleryChanges, ID = ThisItem.ID), { Notes: Self.Text } ); )

Then to update the changes:
Patch( DataSource, ShowColumns( GalleryChanges, "ID", "Notes"));

Was this reply helpful? Yes No
pr3mrxj 6 on at

Like (0)

Report
Copy link

Link copied!

Hi @Chris-D

Thanks for your response, much appreciated. Can I apply the same code to the OnChange event of a dropdown control perhaps? Sorry if my question seems a bit redundant, but I just need to make sure of everything before trying out an approach.

Was this reply helpful? Yes No
Chris-D 1,246 on at

Like (1)

Report
Copy link

Link copied!

Yes the same code should work for any control. Using the code you originally posted, you'd need to use Self.SelectedText.Value in your Dropdown_Sample_4 dropdown.

Was this reply helpful? Yes No