cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rjallel
Frequent Visitor

Collection Update from another collection and patch to the SHARE POINT LIST

I have Collection UserAnswers which contains filter records from share point list.  and I have another collection "UserUpdatedAnswered" which is created whenever user answered survey in the  gallery. I need to update the collection and the update in sharepoint List

 

UserUpdatedAnswered

 

rjallel_0-1646132944219.png

 

UserAnswers

rjallel_1-1646133048386.png

Both collection SurveyQuestion is Unique

 

Bulk upload and then update the share point List

 

Note : UserAnswers and SurverUserAnswered contain same ID columns from sharepoint.. any helps

1 ACCEPTED SOLUTION

Accepted Solutions
v-xiaochen-msft
Community Support
Community Support

Hi @rjallel ,

 

If you want to update 'UserUpdatedAnswered' collection to sharepoint list in bulk, you could try ForAll function.

ForAll(UserUpdatedAnswered As A, 
       Patch(your list,
             LookUp(your list,
             ID=A.ID
             ),{Col1:A.Col1,Col2:A.Col2...}
       )
)

 

Best Regards,

Wearsky

View solution in original post

1 REPLY 1
v-xiaochen-msft
Community Support
Community Support

Hi @rjallel ,

 

If you want to update 'UserUpdatedAnswered' collection to sharepoint list in bulk, you could try ForAll function.

ForAll(UserUpdatedAnswered As A, 
       Patch(your list,
             LookUp(your list,
             ID=A.ID
             ),{Col1:A.Col1,Col2:A.Col2...}
       )
)

 

Best Regards,

Wearsky

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Top Kudoed Authors
Users online (4,191)