ForAll Patch Collection to SharePoint List Keep looping first record from Collection - Issue

[Muzammil]

Hi I'm trying to Patch Collection created through Collect to SharePoint list but it keeps saving the only first record from Collection, code as follows;

ForAll(FishCatchCollection, Patch('Daily Fish Catch Detail', Defaults('Daily Fish Catch Detail'), {'Vessel Name': TextInput_VesselName.Text, 'Vessel Type': DD_VesselType.Selected, Guest: DD_Guest.Selected, 'Captain Name': TextInput_Captain.Text, Hail: Value(TextInput_Hail.Text), Unload: Value(TextInput_Unload.Text), 'In / Out': DD_InOut.Selected, Reason: DD_Reason.Selected, Comment: TextInput_Comment.Text}))

I attached PowerApps Screen and SharePoint list entry, as you can see PowerApps Collection have different records, on the other hand, SharePoint list only saving the first record and loop it as many times as the collection records are.

Please advise

[RandyHayes · Accepted solution]

@Muzammil 

I am assuming that all of the referenced controls (like TextInput_VesselName) are part of your Gallery.  

If that is the case, then referencing them in the way you are in your patch is going to only give you the first instance (record 1 in your case).

You need to reference the Controls as part of the Gallery:

ForAll(
   YouGalleryName.AllItems, 
      Patch('Daily Fish Catch Detail', 
         Defaults('Daily Fish Catch Detail'), 
         {'Vessel Name': TextInput_VesselName.Text, 
          'Vessel Type': DD_VesselType.Selected, 
          Guest: DD_Guest.Selected, 
          'Captain Name': TextInput_Captain.Text, 
          Hail: Value(TextInput_Hail.Text), 
          Unload: Value(TextInput_Unload.Text), 
          'In / Out': DD_InOut.Selected, Reason: 
          DD_Reason.Selected, 
          Comment: TextInput_Comment.Text}))

This will go through each item in your Gallery and patch it to the SharePoint list.

I hope this is helpful for you.

[Muzammil]

Love it @RandyHayes, thank you!

Just tried it, work like a magic 🙂

Yes, all referenced controls (like TextInput_VesselName) are part of Gallery - true.