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

Create (only one) calendar entry from a sharepoint list

Hello everyone,

 

I have a SPO List with a "Employees" field (with is a person field with multiple selections). When someone creates or modifies an element in the list, a Flow creates a Calendar event (outlook connector, create an event V2). This works fine so far.

But: I would like to have the employees selected in the SPO person list field as required attendees in the event. When I use the field "required attendees" and click on "dynamic content -> when an item is... -> eyployees Email"

then Flow builds automaticaly a foreach container around my "create an event V2". That means, that for every person in the employees field a new calender entry is made. I have no Idea how to change that or how to build the flow otherwise. Have some of you?

 

Thanks for your help!

 

greets,

Mars

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Create (only one) calendar entry from a sharepoint list

Hi @Mars_faces,

 

You could use variables to store all person's emails and then configure the variables in the "attendees" field.

  1. First Initialize a variable of type String.
  2. Use Apply_to_each to traverse the information of the person contained in the column, add the email to the string variable, and end with a semicolon.
  3. Finally, the variables are configured in the "attendees" field.

Image reference:

7.PNG

Run history:

8.PNG

Please take a try.

 

Best Regards,

Barry

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: Create (only one) calendar entry from a sharepoint list

Hi @Mars_faces,

 

You could use variables to store all person's emails and then configure the variables in the "attendees" field.

  1. First Initialize a variable of type String.
  2. Use Apply_to_each to traverse the information of the person contained in the column, add the email to the string variable, and end with a semicolon.
  3. Finally, the variables are configured in the "attendees" field.

Image reference:

7.PNG

Run history:

8.PNG

Please take a try.

 

Best Regards,

Barry

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Frequent Visitor

Re: Create (only one) calendar entry from a sharepoint list

Hi @v-bacao-msft,

 

Thank you for your help! It works fine now.

 

Best regards,

Mars

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

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!

Top Solution Authors
Top Kudoed Authors
Users online (8,799)