Power Platform Community Forum Thread Details

Hello everyone,

I’m encountering an issue in my Power Apps application when I try to execute both a Set() function and a ForAll() loop in the same OnSelect action of a button.

Context:

Page 1: The user selects a DropDown1 and a DropDown2, then fills in numbers for each TextInput in a Gallery1. Upon clicking a “Confirm” button, the data is added to a Dataverse table using ForAll() and Patch().
Page 3: I want to display the data from the Gallery1 on Page 1 to allow the user to edit the entered Numbers. I’m trying to use the Set() function in OnSelect to store the gallery data in a global variable.

However, when I combine both functions (Set() to store the data and ForAll() to save the data to the Dataverse), I get errors.

Here’s the code I’m trying to execute:

PowerApps

Set(LastGalleryData; Gallery1.AllItems)

&

ForAll(Gallery1.AllItems; Patch(ETP_CAP_AAF; Defaults(ETP_CAP_AAF);{Site: Dropdown_BU.Selected.Value; Atelier: Dropdown_Atelier.Selected.Value; CAP: CAP.Text; Date: DatePicker.SelectedDate; 'Nombre d''ETP': Value(TextInput.Text); 'Date de création de la ligne': Now(); 'Date de modification': Now()}))

What I’ve tried:

If I run the Set() code alone, it works perfectly.
If I run the ForAll() code alone, it also works.
The problem seems to only arise when I try to combine both actions in the same OnSelect.

Is there a specific way to execute both Set() and ForAll() in the same event? Or is there an alternative method for storing the gallery data while simultaneously patching it into the Dataverse?

Thanks in advance for your help!

Categories:

Power Apps Pro Dev & ISV

Hi CU01100710-1,

Can you please try ";" and ";;" instead of "&" between the Set and ForAll statements? Looks like it requires different syntax based on Locale.

Also, can you try saving the Gallery items in a collection instead? -

ClearCollect(LastGalleryData; Gallery1.AllItems)
;;
ForAll(Gallery1.AllItems; Patch(ETP_CAP_AAF; Defaults(ETP_CAP_AAF);{Site: Dropdown_BU.Selected.Value; Atelier: Dropdown_Atelier.Selected.Value; CAP: CAP.Text; Date: DatePicker.SelectedDate; 'Nombre d''ETP': Value(TextInput.Text);
'Date de création de la ligne': Now(); 'Date de modification': Now()}))

Hope this helps.

Kind regards,

Nandit

If this answers your query, please mark this response as the answer.
If its helpful, please leave a like. Thanks!