Patch all gallery items to sharepoint

[rems_powerapps]

Hey ! I would like to patch all gallery items and send this to a sharepoint list. For each items I want to creat an new line in my sharepoint list. 

What I did :

ForAll(Gallery6.AllItems; Patch('GO VF DR ACL - GDM_liste_historique'; Defaults('GO VF DR ACL - GDM_liste_historique'); {type_article : Title7.Text}; {code_barre : Subtitle4.Text}; {nom_article :Label6.Text}; {date_entrée : Label5.Text}; {'ID supplementaire' : TextInput3.Text};{ nom_agence : Label14.Text}))

'GO VF DR ACL - GDM_liste_historique' is my data source, sharepoint list. 

Thanks in advance ! 

[rems_powerapps]

Hi @yashag2255 

Thanks for your answer ! Since the beginning, I have no mistake when I wrote the formula. You can see that on this screen capture: 

When I click on my button " Suivant" and I send my differents gallery items to my sharepoint list, I have an error on the Patch : 

But for me, the syntax is good...

Thanks in advance

[yashag2255 · Accepted solution]

Hi @rems_powerapps 

This means the formula is correct but this is getting failed because of some other error. Can you check the error message in the formula and share it? you can check that by using the App Checker icon on the top menu or just hover over the incorrect expression.

Please make sure that the values passed through the gallery are in the same format as expected by the field.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[rems_powerapps · Accepted solution]

Hi, @yashag2255 

It's working !! I completely forgot to add a "Title" field to create a new line in my sharepoint list... 

Navigate(Page_operation_réussite_attribution;ScreenTransition.Fade);;ForAll(Gallery6.AllItems; Patch('GO VF DR ACL - GDM_liste_historique'; Defaults('GO VF DR ACL - GDM_liste_historique'); {Title : "false"; type_article : Title7.Text; code_barre : Subtitle4.Text; nom_article :Label6.Text; date_entrée : Label5.Text; 'ID supplementaire' : TextInput3.Text; nom_agence : Label14.Text}))

Thanks again for your quick answers ! 

---

@yashag2255 wrote:

Hi @rems_powerapps 

This means the formula is correct but this is getting failed because of some other error. Can you check the error message in the formula and share it? you can check that by using the App Checker icon on the top menu or just hover over the incorrect expression.

Please make sure that the values passed through the gallery are in the same format as expected by the field.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

---

[JT_ENGINEER]

I've been having an issues that i can't seem to correct.  I have a powerapp that pulls records in from sharepoint into a gallery in the form of an editable grid.  The Gallery has hidden inputs that perform calculations by referencing values from other pages of the app.  Thus when i make changes to the other page of the app, the data in the gallery changes because it calculates immediately.  I need that updated data to patch to the sharepoint list.  I've tried using the gallery to update a collection and then have the collection update the sharepoint list however i can't get the collection to update with the new data unless i click somewhere in the gallery.  My next attempt was to have the gallery update the sharepoint list directly however whenever i used the following formula. 

Patch('Coatings Pricing Model',ForAll(JobInfoGallery_2.AllItems,{Job_Category:CategoryDrpDwn_2.Selected.Result,Job_Description:DescriptionInpt_2.Text}));

Rather than updating the records however, this formula creates all new records, duplicating the original records.

Please help.