Answered

How to patch mail entries from collection into a SharePoint List

(0) Share

Report

Posted on by Adam_9595

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!

Categories:

Power Apps component framework

All responses (3)

Answers (1)

Adam_9595 16 on at

Like (0)

Report

How to patch mail entries from collection into a SharePoint List

Thank you @WarrenBelz!
Verified answer

WarrenBelz 148,638 Most Valuable Professional on at

Like (1)

Report
How to patch mail entries from collection into a SharePoint List

Hi Adam_9595

Try this format - it would also be better to submit the Form then have the rest of the code OnSuccess of the Form. If you do that, you can use Self.LastSubmit.ID in the code below.
SubmitForm('03_01_04-06_frm_Form'); Patch( Permissions, { ID: '03_01_04-06_frm_Form'.LastSubmit.ID, Person: ForAll( colSelectedPerson As _Data, { Claims: "i:0#.f|membership|" & Lower(_Data.mail), Department: "", DisplayName: _Data.Name, Email: _Data.mail, JobTitle: "", Picture: "" } ) } ); Set(varBreadcrumbValue, 2); ResetForm('03_01_04-06_frm_Form')

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee
ronaldwalcott 3,820 on at

Like (0)

Report

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