Unanswered

Patching a nested gallery

(0) Share

Report

Posted on by pen253

Hello,

I'm in need of help to patch data into a SharePoint list from a nested gallery. My screen structure involves a dropdown menu that the user selects an option from (within the Parent gallery), and for each option there are multiple records that need to be answered (within the Child gallery).

I've tried writing a nested ForAll within the formula to patch the data when the user saves the answers. However, this is not working and I'm not sure how to fix it.

(Something to note is that I've added a hidden label (Label_TopProp) within the Child gallery that references the Parent gallery dropdown menu value, to try and store that selected option with one patch statement.)

Any help would be appreciated. Cheers!

Categories:

Building Power Apps

I have the same question (0)

All responses (20)

Answers (0)

Sort by

Ramole Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@pen253
To use ForAll() see below.

ForAll(Gallery_Child.AllItems, Patch( Answers_S4_C1_Processing, { Title: User().FullName & "-" & Now() } ) )

Also have look this post Patch a record into Share point with a nested Gallery

Was this reply helpful? Yes No
WarrenBelz 155,487 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @pen253 ,

Firstly please post all code as Text - makes it far easier to correct - try this

ForAll( Galllery_Parent.AllItems, ForAll( Gallery_Child.AllItems As aPatch, Patch( Answers_S4_C1Processing, Defaults(Answers_S4_C1Processing), { Title: User().FullName & "-" & Now(), UserID: gblUser.ID, Top_Prop: aPatch.LabelTopProp.Text, . . . . . } ) ) )

and replace ThisRecord with aPatch on the rest.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
pen253 25 on at

Like (0)

Report
Copy link

Link copied!
Hi @WarrenBelz,

Thanks for your help! The updated code is below. The button can now be selected without any errors and navigate to the next screen - but the data isn't being stored in the SharePoint list. Any idea why this could be the case?

ForAll( Gallery_Parent.AllItems, ForAll( Gallery_Child.AllItems As aPatch, Patch( Answers_S4_C1_Processing, Defaults(Answers_S4_C1_Processing), { Title: User().FullName & "-" & Now(), UserID: gblUser.ID, QuestionID: aPatch.ID, Top_Prop: aPatch.Label_TopProp.Text, Condition: aPatch.Label_Conditions.Text, Value_min: aPatch.TextInput_Min, Value_max: aPatch.TextInput_Max, Relationship: aPatch.Dropdown_Relationship.SelectedText.Value } ) ) ); Navigate(Quality_Calculation_C2, Fade);
Cheers!

Was this reply helpful? Yes No
WarrenBelz 155,487 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @pen253 ,

Interesting - I must admit I have never tried to do exactly what you are doing, but it should work - maybe run a monitor session and see if the ForAll is being actioned

Was this reply helpful? Yes No
pen253 25 on at

Like (0)

Report
Copy link

Link copied!

It appears to have run successfully, but still no data within the SharePoint list. I have been able to save data for other screens, so it isn't a fundamental connection issue between Power Apps and SharePoint.

Cheers

Was this reply helpful? Yes No
WarrenBelz 155,487 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

HI @pen253 ,

For a bit of debugging, try patching only the child gallery using the code I supplied from a button inside the main gallery and see if that works on just that parent record.

Was this reply helpful? Yes No
pen253 25 on at

Like (0)

Report
Copy link

Link copied!
As you said, I used the following code for a button located within the Parent gallery. The error log is attached.

ForAll( Gallery_Child.AllItems As aPatch, Patch( Answers_S4_C1_Processing, Defaults(Answers_S4_C1_Processing), { Title: User().FullName & "-" & Now(), UserID: gblUser.ID, QuestionID: aPatch.ID, Top_Prop: aPatch.Label_TopProp.Text, Condition: aPatch.Label_Conditions.Text, Value_min: aPatch.TextInput_Min, Value_max: aPatch.TextInput_Max, Relationship: aPatch.Dropdown_Relationship.SelectedText.Value } ) ); Navigate(Quality_Calculation_C2, Fade);
Cheers

Was this reply helpful? Yes No
WarrenBelz 155,487 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @pen253 ,

I have built a model to test this (as I mentioned I had not done it before) - I actually got this working as a button in the parent gallery

Patch( Answers_S4_C1_Processing, ForAll( Gallery_Child.AllItems As aPatch, { Title: User().FullName & "-" & Now(), UserID: gblUser.ID, QuestionID: aPatch.ID, Top_Prop: aPatch.Label_TopProp.Text, Condition: aPatch.Label_Conditions.Text, Value_min: aPatch.TextInput_Min, Value_max: aPatch.TextInput_Max, Relationship: aPatch.Dropdown_Relationship.SelectedText.Value } ) )

however, the fundamental problem is that the child gallery itself is not actually recognised in the second ForAll. The actual "child" is the grouped table column data that forms the gallery Items (not the gallery itself), so you have to refer to the fields in that table, not the controls in the child gallery (I successfully patched using these), so somehow you are going to need to write to that table before patching.

Was this reply helpful? Yes No
pen253 25 on at

Like (0)

Report
Copy link

Link copied!

Hi @WarrenBelz,

Thank you very much for your help with this so far! It's interesting that your button within the parent gallery is working, because when I copy in your code I still get the error "Network error when using Patch function: The requested operation is invalid".

On your other point, I'm not familiar with grouped table column data. Do you have any suggestions about how to write to that table before patching? Alternatively, is there any other way to set up the screen to simplify the patch?

Cheers!

Was this reply helpful? Yes No
WarrenBelz 155,487 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @pen253 ,

As I mentioned, I used the actual Table column name (not the child gallery) in the Patch. I assume you are using GroupBy in the Parent Gallery and then the Child Gallery Items would be ThisItem.YourGroupedFieldName. If all this is true, you actually need to write back to the "parent" list on each item at the time you change the Child Gallery, so the whole subject of this thread is redundant as the data will already be there.

Was this reply helpful? Yes No