Problem adding participants into Event List (Sharepoint)

[machammarj]

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:

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

"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:

https://my.sharepoint.com/sites/intra/_api/web/lists/GetByTitle('Calendar')/Items

<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:

Best Regards,

Marcos

[Expiscornovus · Accepted solution]

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']}'}]"
	}
    ]
}