Skip to main content

Notifications

Power Apps - Power Apps Experimental Features
Unanswered

Patch a Collection to Sharepoint columns

(1) ShareShare
ReportReport
Posted on by 252
Hi All,
 
I gave a gallery where I can select different options for a task, using a check box.  I store the select options in a collection.  
 
My back end table is share point, which has a column for each of the different options.  What I would like to do it patch/update the selected options for a given record in share point.
 
Thanks in Advance
 
  • Suggested answer
    FLMike Profile Picture
    FLMike 30,156 on at
    Patch a Collection to Sharepoint columns
    Hi,
     
    Is the gallery a list of your records? You didn't say but lets assume it is
     
    Why are you storing them in a collection? When does the person hit Save?
    Does your collection store every row that is in the Gallery ??
     
    Since you said a Collection I am going to assume they hit a button and I am going to assume that you have multiple rows in the collection
     
    ForAll(MyCollection,
         Patch(myDataSource, LookUp(myDataSource, SomeColumnInSharePoint = ThisRecord.ColumnInCollection),
             {
                 FieldInDataSource: ThisRecord.ColumnInCollection,
                 Field2inDataSource: ThisRecord.Column2InCollection and so on
             }
        );
    );
     
     
     
     

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,445

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,741

Leaderboard

Featured topics