web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Send a Collection to a...
Power Apps
Unanswered

Send a Collection to a SharePoint List

(0) ShareShare
ReportReport
Posted on by 29

Hello, I am needing help sending a collection of items to a SharePoint list. 

 

I am pulling in the data from SharePoint List 1. Then I am having the associate select from the list what they would like and their selections go into a collection. I am then wanting to take the items in the collection, plus a number input attached to each line of the collection and create a new line item for each entry in a Sharepoint List

 

So far this is what I've come up with but it's not working. 

 

ForAll(
'Gall1'.AllItems,
Patch(
SharepointList,
Defaults(SharePointList),
(Venue:ThisRecord.Item.Venue,'Date':ThisRecord.Item.Date,'Sport':ThisRecord.Item.Sport,'Tickets':Sumtix.text)

Categories:
I have the same question (0)
  • RandyHayes Profile Picture
    76,297 Super User 2024 Season 1 on at

    @Techy1234 

    Your ForAll is backward! You are trying to use it like a ForLoop in some development language - which PowerApps is not.  It is a function that returns a table of records based on your iteration table and record schema.

    It is more efficient to use the function as intended and will provide better performance - especially when trying to Patch!

     

    Patch(SharepointList,
     ForAll('Gall1'.AllItems, 
     {Venue: Venue,
     'Date': Date,
     'Sport': Sport,
     'Tickets': Sumtix.text
     }
     )
    )

     The above will create records in your list with the value from the Gallery.

     

    I hope this is helpful for you.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 711 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 319 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard