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

Highlighted
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

Microsoft Ignite 2020

Check out the announcement of Power Platform content at Microsoft Ignite!

thirdImage

Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (3,379)