Skip to main content

Notifications

Power Apps - Power Apps Pro Dev & ISV
Unanswered

How to patch mail entries from collection into a SharePoint List

Posted on 21 Nov 2024 19:59:54 by 2
Hi everyone,

i need your help. I would like to save all email addresses from the "colSelectedPerson" collection into a SharePoint "Permissions" list.
The structure of the collection is as follows:
 
Name mail
Adam Rzychon Adam.Rzychon@adamspp.de
Mike Tryderson Mike.Tryderson@adamspp.de

The email addresses from the collection should go into an SP column, which is defined as a person column with multiple selection.
So far I've tried this code:
 
SubmitForm('03_01_04-06_frm_Form'); // Formular absenden
Set(varLastSavedRecord, '03_01_04-06_frm_Form'.LastSubmit.ID); 

ForAll(
    colSelectedPerson, 
    Patch(
        Permissions, 
        LookUp(Permissions, ID = varLastSavedRecord), 
        {Person:  ThisRecord.mail}
    )
);

Set(varBreadcrumbValue, 2); 
ResetForm('03_01_04-06_frm_Form') 

This code is throwing an error. I feel like it is expecting a table.


 
 

Is there a way to save the email addresses from the collection into the SP list?

Thank you! 
  • ronaldwalcott Profile Picture
    ronaldwalcott 704 on 21 Nov 2024 at 23:35:43
    How to patch mail entries from collection into a SharePoint List
    I had seen this post which could possibly help PATCH A SharePoint Person Column In Power Apps - Matthew Devaney

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

October 2024 Newsletter…

October 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #4 How to Conntact Support…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,061

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,795

Leaderboard