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 Pro Dev & ISV

I have the same question (0)

All responses (3)

Answers (1)

Sort by

ronaldwalcott 3,906 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

I had seen this post which could possibly help PATCH A SharePoint Person Column In Power Apps - Matthew Devaney

Was this reply helpful? Yes No
Verified answer

WarrenBelz 156,100 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
Adam_9595 16 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you @WarrenBelz!

Was this reply helpful? Yes No