Unanswered

How do i patch data from this gallery to a list?

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I would like to Take data that is selected from this list(The dat aselected is shown in the box on the left) and patch it to a list. The gallery is connected to office365 users. I would liek to select the users and then patch it into a list where i can use that data for something else. using the following patch code dosent work

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

CU22040918-0 195 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous

What’s data type of Participants field in Sharepoint?

Nelson

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

The type of data there is "person or group"

Was this reply helpful? Yes No
CU22040918-0 195 on at

Like
a
(0)

Report
Copy link

Link copied!

To patch person column of SharePoint, you have to patch a record which contains "Claims", "Department", "DisplayName", "Email", "JobTitle", "Picture" columns.

Try this

ForAll(
collection,
Patch(
SPList,
Defaults(SPList),
{
….,
Participants: {
Claims:"i:0#.f|membership|" & <Email>,
Department:"",
DisplayName: "",
Email: "",
JobTitle:"",
Picture:""
}}
)
)

replace <Email> by the real field with email in collection

Nelson

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

is there a way of just doing it by adding their user in the list? as in i want to use this to create an event(in the list) and then i want to send a mail containing some information

Was this reply helpful? Yes No
CU22040918-0 195 on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry, not quite get your point. Could you elaborate your needs with more details?

Nelson

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

ofc! Im tryign to automize the event invitation process for a department at my job. what im trying to do here is to invite people at out organization to events. the solution i tought of was to make a powerapp where you can select eventname, date, participants, presenter. When you click on send invites the information is then patched to a sharepoint list. In the sharepoint list i want to make a flow that sends out invites and also put it in their calnder)(the calender part i can do myself). The only thing that is stopping me is to add the participants and presenter to the list. I just cant seem to make it work. I can add the participants in the list itself, but patching it in form powerapp seems to not happen

Was this reply helpful? Yes No