cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gzgenm
Level: Powered On

Create Event - attendees field: can't use a sharepoint list item type "Person or Group"

A have a list on Sharepoint

There's column "Person", type "Person or Group" (single item only) in which user is stored.


I'm trying to create a calendar event (Create Event V2) using Flow and use that column in "Required attendees" as "Person Email".

The flow isn't working and returning me an error:

 

"One or more recipients are invalid. clientRequestId: id serviceRequestId: id"

 

due to the fact that user seems to be incorrect (according to logs):

INPUTS
...

Required attendees
i:0#.f|membership|user.name@domain.ltd;


Could you please help me to fix the issue?

Thanks.

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Create Event - attendees field: can't use a sharepoint list item type "Person or Group&qu

I just ran a quick test using a person or group column that does not allow multiple selections and the Flow ran without error:

 

Event.jpg

 

If the person or group column allows for multiple selections, the Flow above will error out.  To fix, configure your Flow in a manner similar to below.  I am looping through each of the email addresses and appending them to a string variable.  Please note the semicolon I include after the email address.  I then reference the variable rather than the column when specifying required attendees.

 

Event2.jpg

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

View solution in original post

4 REPLIES 4
Super User
Super User

Re: Create Event - attendees field: can't use a sharepoint list item type "Person or Group&qu

I just ran a quick test using a person or group column that does not allow multiple selections and the Flow ran without error:

 

Event.jpg

 

If the person or group column allows for multiple selections, the Flow above will error out.  To fix, configure your Flow in a manner similar to below.  I am looping through each of the email addresses and appending them to a string variable.  Please note the semicolon I include after the email address.  I then reference the variable rather than the column when specifying required attendees.

 

Event2.jpg

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

View solution in original post

Community Support Team
Community Support Team

Re: Create Event - attendees field: can't use a sharepoint list item type "Person or Group&qu

Hi @ gzgenm,

 

 

Have you problem be solved?

 

I have made a test on my side, the solution gived by @ScottShearer is works.

Please take a try with @ScottShearer 's solution.

 

Please feel free to contact me if you need any other problems.

 

 

Regards,
Alice Zhang

gzgenm
Level: Powered On

Re: Create Event - attendees field: can't use a sharepoint list item type "Person or Group&am

Yeah, thanks. The problem has been solved.

Highlighted
klitza
Level: Powered On

Re: Create Event - attendees field: can't use a sharepoint list item type "Person or Group&am

I'm attempting to use the same thing, but it is only appending the 1st email address of the 1st perosn included in the multiple select field. Any ideas?

Helpful resources

Announcements
firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Users online (5,011)