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
Super User
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
Super User
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

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (3,565)