cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
machammarj
Frequent Visitor

Problem adding participants into Event List (Sharepoint)

Hi!

 

I can  create an item in sharepoint event list without any problem using Send HTTP to Sharepoint action.

 

Now, I would like to add Participants to it (event list shows member´s items) and it is now working:

 

machammarj_0-1624524371320.png

I can retrieve the user from sharepoint that needs to be added:

machammarj_1-1624524500934.png

 

"Id"39,
    "IsHiddenInUI"false,
    "LoginName""i:0#.f|membership|bruno@company.com",
    "Title""Bruno",
    "PrincipalType"1,
    "Email""bruno@company.com",
    "Expiration""",
   
When I run the following command it returns:
 
 
<d:ParticipantsPickerId m:type="Collection(Edm.Int32)"><d:element>39</d:element></d:ParticipantsPickerId><d:ParticipantsPickerStringId m:type="Collection(Edm.String)"><d:element>39</d:element></d:ParticipantsPickerStringId>
 
Which I think I have to insert the user´s ID 39 for that user.
 
Problems:
 
1) Retrieving only the User´s ID (39) into a variable, extract from JSON
2) Insert that variale into sharepoint calendar the item participantspickerid:
 

machammarj_2-1624524621245.png

 

Best Regards,

Marcos

 

1 ACCEPTED SOLUTION

Accepted Solutions
Expiscornovus
Dual Super User
Dual Super User

Hi @machammarj,

 

Just to double check. Does that participants column allow multiple values? Based on the name of the column I assume it does.

 

You can use the loginname (with the claim) of your first HTTP request and use that to update the Participants field value via the validateUpdateListItem method (after you have created the item first)

 

@tom_riha has recently written a good blogpost about this:

https://tomriha.com/how-to-easily-update-sharepoint-people-picker-column-in-power-automate/

 

Below is an example of that approach.
Replace Participants0 by the internal name of your Participants field in the event list

 

 

{
    "formValues":[
	{
	    "FieldName": "Participants0",
	    "FieldValue": "[{'Key':'@{outputs('Enviar_uma_solicitação_HTTP_ao_SharePoint_2')?['body']['d']['LoginName']}'}]"
	}
    ]
}

 

 

useloginname.png

 

 

View solution in original post

1 REPLY 1
Expiscornovus
Dual Super User
Dual Super User

Hi @machammarj,

 

Just to double check. Does that participants column allow multiple values? Based on the name of the column I assume it does.

 

You can use the loginname (with the claim) of your first HTTP request and use that to update the Participants field value via the validateUpdateListItem method (after you have created the item first)

 

@tom_riha has recently written a good blogpost about this:

https://tomriha.com/how-to-easily-update-sharepoint-people-picker-column-in-power-automate/

 

Below is an example of that approach.
Replace Participants0 by the internal name of your Participants field in the event list

 

 

{
    "formValues":[
	{
	    "FieldName": "Participants0",
	    "FieldValue": "[{'Key':'@{outputs('Enviar_uma_solicitação_HTTP_ao_SharePoint_2')?['body']['d']['LoginName']}'}]"
	}
    ]
}

 

 

useloginname.png

 

 

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Top Kudoed Authors
Users online (2,044)